Commitd874c6b

Alexander Korotkov

committed

Regression tests for BETWEEN support in hash partitioning.

1 parent773fbb1 commitd874c6bCopy full SHA for d874c6b

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -190,6 +190,16 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value = 2 OR value = 1;`
`190`	`190`	`Filter: (value = 2)`
`191`	`191`	`(5 rows)`
`192`	`192`
	`193`	`+EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel WHERE value BETWEEN 1 AND 2;`
	`194`	`+ QUERY PLAN`
	`195`	`+-------------------------------------------------`
	`196`	`+ Append`
	`197`	`+ -> Seq Scan on hash_rel_1`
	`198`	`+ Filter: ((value >= 1) AND (value <= 2))`
	`199`	`+ -> Seq Scan on hash_rel_2`
	`200`	`+ Filter: ((value >= 1) AND (value <= 2))`
	`201`	`+(5 rows)`
	`202`	`+`
`193`	`203`	`EXPLAIN (COSTS OFF) SELECT * FROM test.num_range_rel WHERE id > 2500;`
`194`	`204`	`QUERY PLAN`
`195`	`205`	`-----------------------------------`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -66,6 +66,7 @@ SET enable_seqscan = ON;`
`66`	`66`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_rel;`
`67`	`67`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2;`
`68`	`68`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value=2OR value=1;`
	`69`	`+EXPLAIN (COSTS OFF)SELECT*FROMtest.hash_relWHERE value BETWEEN1AND2;`
`69`	`70`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.num_range_relWHERE id>2500;`
`70`	`71`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.num_range_relWHERE id>=1000AND id<3000;`
`71`	`72`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.num_range_relWHERE id>=1500AND id<2500;`

Comments

(0)