Add provider expression filter tests for TVL

qgis · Nov 17, 2015 · 3d947e8 · 3d947e8
1 parent 26f7683
commit 3d947e8
Showing 1 changed file with 22 additions and 0 deletions.
diff --git a/tests/src/python/providertestbase.py b/tests/src/python/providertestbase.py
@@ -62,6 +62,28 @@ def runGetFeatureTests(self, provider):
         self.assert_query(provider, '"name" ~ \'[OP]ra[gne]+\'', [1])
         self.assert_query(provider, '"name"="name2"', [2, 4])  # mix of matched and non-matched case sensitive names
         self.assert_query(provider, 'true', [1, 2, 3, 4, 5])
+        #Three value logic
+        self.assert_query(provider, 'false and false', [])
+        self.assert_query(provider, 'false and true', [])
+        self.assert_query(provider, 'false and NULL', [])
+        self.assert_query(provider, 'true and false', [])
+        self.assert_query(provider, 'true and true', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'true and NULL', [])
+        self.assert_query(provider, 'NULL and false', [])
+        self.assert_query(provider, 'NULL and true', [])
+        self.assert_query(provider, 'NULL and NULL', [])
+        self.assert_query(provider, 'false or false', [])
+        self.assert_query(provider, 'false or true', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'false or NULL', [])
+        self.assert_query(provider, 'true or false', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'true or true', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'true or NULL', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'NULL or false', [])
+        self.assert_query(provider, 'NULL or true', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'NULL or NULL', [])
+        self.assert_query(provider, 'not true', [])
+        self.assert_query(provider, 'not false', [1, 2, 3, 4, 5])
+        self.assert_query(provider, 'not null', [])
 
     def testGetFeaturesUncompiled(self):
         try: