Query builder: IS NOT NULL support implementation, see #3194
diff --git a/system/database/DB_query_builder.php b/system/database/DB_query_builder.php
index 085c615..c75a469 100644
--- a/system/database/DB_query_builder.php
+++ b/system/database/DB_query_builder.php
@@ -661,6 +661,15 @@
// value appears not to have been set, assign the test to IS NULL
$k .= ' IS NULL';
}
+ else
+ {
+ $operator = trim($this->_get_operator($k));
+
+ if ($operator == '<>' OR $operator == '!=')
+ {
+ $k = str_replace($operator, ' IS NOT NULL', $k);
+ }
+ }
$this->{$qb_key}[] = array('condition' => $prefix.$k.$v, 'escape' => $escape);
if ($this->qb_caching === TRUE)