[virtual layer] Fix xFilter for null value comparisons

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