[virtual] Fix xFilter for null value comparisons

qgis · Dec 2, 2016 · e0e60da · e0e60da
1 parent 499ae31
commit e0e60da
Showing 1 changed file with 6 additions and 6 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;
       }
-      default:
-        expr = "";
-    }
-    if ( !expr.isEmpty() )
-    {
-      request.setFilterExpression( expr );
+    case SQLITE_NULL:
+    case SQLITE_BLOB: // comparison to blob ignored
+    default:
+      expr += " is null";
+      break;
     }
+    request.setFilterExpression( expr );
   }
   VTableCursor *c = reinterpret_cast<VTableCursor*>( cursor );
   c->filter( request );