Commitef1454c

committed

improve mergejoin regression test

1 parentd6eeacd commitef1454cCopy full SHA for ef1454c

File tree

+14

-0

lines changed

+14

-0

lines changed

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -86,3 +86,8 @@ WHERE j1.dt < '2015-03-01' AND j2.dt >= '2015-02-01' ORDER BY j2.dt;`
`86`	`86`	`-> Index Scan using range_rel_2_pkey on range_rel_2 j1_1`
`87`	`87`	`(22 rows)`
`88`	`88`
	`89`	`+SET enable_hashjoin = ON;`
	`90`	`+SET enable_nestloop = ON;`
	`91`	`+DROP SCHEMA test CASCADE;`
	`92`	`+NOTICE: drop cascades to 12 other objects`
	`93`	`+DROP EXTENSION pg_pathman;`

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,6 +5,7 @@ CREATE SCHEMA pathman;`
`5`	`5`	`CREATE EXTENSION pg_pathman SCHEMA pathman;`
`6`	`6`	`CREATESCHEMAtest;`
`7`	`7`
	`8`	`+`
`8`	`9`	`CREATETABLEtest.range_rel (`
`9`	`10`	`idSERIALPRIMARY KEY,`
`10`	`11`	`dtTIMESTAMP,`
`@@ -35,8 +36,16 @@ INSERT INTO test.num_range_rel`
`35`	`36`	`SET enable_hashjoin= OFF;`
`36`	`37`	`SET enable_nestloop= OFF;`
`37`	`38`	`SET enable_mergejoin=ON;`
	`39`	`+`
`38`	`40`	`EXPLAIN (COSTS OFF)`
`39`	`41`	`SELECT*FROMtest.range_rel j1`
`40`	`42`	`JOINtest.range_rel j2onj2.id=j1.id`
`41`	`43`	`JOINtest.num_range_rel j3onj3.id=j1.id`
`42`	`44`	`WHEREj1.dt<'2015-03-01'ANDj2.dt>='2015-02-01'ORDER BYj2.dt;`
	`45`	`+`
	`46`	`+SET enable_hashjoin=ON;`
	`47`	`+SET enable_nestloop=ON;`
	`48`	`+`
	`49`	`+`
	`50`	`+DROPSCHEMA test CASCADE;`
	`51`	`+DROP EXTENSION pg_pathman;`

Comments

(0)