test SELECT ... WHERE value = NULL

funbringer · funbringer · commit caf6194e2780 · 2017-04-19T22:06:09.000+03:00
diff --git a/expected/pathman_basic.out b/expected/pathman_basic.out
@@ -450,6 +450,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;
    ->  Seq Scan on hash_rel_2
 (4 rows)
 
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;
+        QUERY PLAN        
+--------------------------
+ Result
+   One-Time Filter: false
+(2 rows)
+
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
           QUERY PLAN          
 ------------------------------
@@ -602,6 +609,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;
    ->  Seq Scan on hash_rel_2
 (4 rows)
 
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;
+        QUERY PLAN        
+--------------------------
+ Result
+   One-Time Filter: false
+(2 rows)
+
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
           QUERY PLAN          
 ------------------------------
diff --git a/sql/pathman_basic.sql b/sql/pathman_basic.sql
@@ -165,6 +165,7 @@ SET enable_bitmapscan = OFF;
 SET enable_seqscan = ON;
 
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;
 
@@ -188,6 +189,7 @@ SET enable_bitmapscan = OFF;
 SET enable_seqscan = OFF;
 
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;
+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;
 EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value IN (2);
