[virtual layer] Fix xFilter for null value comparisons

qgis · Dec 5, 2016 · 95ae154 · 95ae154
1 parent 10ae5e2
commit 95ae154
Showing 1 changed file with 5 additions and 5 deletions.
diff --git a/src/providers/virtual/qgsvirtuallayersqlitemodule.cpp b/src/providers/virtual/qgsvirtuallayersqlitemodule.cpp
@@ -619,13 +619,13 @@ int vtableFilter( sqlite3_vtab_cursor * cursor, int idxNum, const char *idxStr,
         expr += "'" + str.replace( "'", "''" ) + "'";
         break;
       }
+      case SQLITE_NULL:
+      case SQLITE_BLOB: // comparison to blob ignored
       default:
-        expr = "";
-    }
-    if ( !expr.isEmpty() )
-    {
-      request.setFilterExpression( expr );
+        expr += " is null";
+        break;
     }
+    request.setFilterExpression( expr );
   }
   VTableCursor *c = reinterpret_cast<VTableCursor*>( cursor );
   c->filter( request );