Commitcaf6194

committed

test SELECT ... WHERE value = NULL

1 parent11f6d4a commitcaf6194Copy full SHA for caf6194

File tree

+16

-0

lines changed

+16

-0

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -450,6 +450,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;`
`450`	`450`	`-> Seq Scan on hash_rel_2`
`451`	`451`	`(4 rows)`
`452`	`452`
	`453`	`+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;`
	`454`	`+ QUERY PLAN`
	`455`	`+--------------------------`
	`456`	`+ Result`
	`457`	`+ One-Time Filter: false`
	`458`	`+(2 rows)`
	`459`	`+`
`453`	`460`	`EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;`
`454`	`461`	`QUERY PLAN`
`455`	`462`	`------------------------------`
`@@ -602,6 +609,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;`
`602`	`609`	`-> Seq Scan on hash_rel_2`
`603`	`610`	`(4 rows)`
`604`	`611`
	`612`	`+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = NULL;`
	`613`	`+ QUERY PLAN`
	`614`	`+--------------------------`
	`615`	`+ Result`
	`616`	`+ One-Time Filter: false`
	`617`	`+(2 rows)`
	`618`	`+`
`605`	`619`	`EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2;`
`606`	`620`	`QUERY PLAN`
`607`	`621`	`------------------------------`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -165,6 +165,7 @@ SET enable_bitmapscan = OFF;`
`165`	`165`	`SET enable_seqscan=ON;`
`166`	`166`
`167`	`167`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_rel;`
	`168`	`+EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=NULL;`
`168`	`169`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2;`
`169`	`170`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2OR value=1;`
`170`	`171`
`@@ -188,6 +189,7 @@ SET enable_bitmapscan = OFF;`
`188`	`189`	`SET enable_seqscan= OFF;`
`189`	`190`
`190`	`191`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_rel;`
	`192`	`+EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=NULL;`
`191`	`193`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2;`
`192`	`194`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2OR value=1;`
`193`	`195`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE valueIN (2);`

Comments

(0)