Add limiting parameters to generate bitmapscan, hashjoin, mergejoin and material nodes.

Alena Rybakina · Alena Rybakina · commit 853d99a2163a · 2023-01-30T14:42:13.000+03:00
diff --git a/expected/update_functions.out b/expected/update_functions.out
@@ -19,6 +19,10 @@ ANALYZE aqo_test2;
 CREATE EXTENSION aqo;
 SET aqo.join_threshold = 0;
 SET aqo.mode='intelligent';
+SET enable_material = 'off';
+SET enable_hashjoin = 'off';
+SET enable_bitmapscan = 'off';
+SET enable_mergejoin = 'off';
 SELECT count(*) FROM aqo_test1 a, aqo_test2 b WHERE a.a=b.a;
  count 
 -------
@@ -326,8 +330,7 @@ ORDER BY res;
  t
  t
  t
- t
-(27 rows)
+(26 rows)
 
 -- Check if data is the same as in source, no result rows expected.
 (TABLE aqo_data_dump EXCEPT TABLE aqo_data)
@@ -369,8 +372,7 @@ ORDER BY res;
  t
  t
  t
- t
-(27 rows)
+(26 rows)
 
 -- Check if data is the same as in source, no result rows expected.
 (TABLE aqo_data_dump EXCEPT TABLE aqo_data)
diff --git a/sql/update_functions.sql b/sql/update_functions.sql
@@ -22,6 +22,10 @@ CREATE EXTENSION aqo;
 SET aqo.join_threshold = 0;
 
 SET aqo.mode='intelligent';
+SET enable_material = 'off';
+SET enable_hashjoin = 'off';
+SET enable_bitmapscan = 'off';
+SET enable_mergejoin = 'off';
 
 SELECT count(*) FROM aqo_test1 a, aqo_test2 b WHERE a.a=b.a;
 SELECT count(*) FROM aqo_test1 a, aqo_test2 b, aqo_test2 c WHERE a.a = b.a AND b.a = c.a;

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,10 @@ ANALYZE aqo_test2;`
`19`	`19`	`CREATE EXTENSION aqo;`
`20`	`20`	`SET aqo.join_threshold = 0;`
`21`	`21`	`SET aqo.mode='intelligent';`
	`22`	`+SET enable_material = 'off';`
	`23`	`+SET enable_hashjoin = 'off';`
	`24`	`+SET enable_bitmapscan = 'off';`
	`25`	`+SET enable_mergejoin = 'off';`
`22`	`26`	`SELECT count(*) FROM aqo_test1 a, aqo_test2 b WHERE a.a=b.a;`
`23`	`27`	`count`
`24`	`28`	`-------`
`@@ -326,8 +330,7 @@ ORDER BY res;`
`326`	`330`	`t`
`327`	`331`	`t`
`328`	`332`	`t`
`329`		`- t`
`330`		`-(27 rows)`
	`333`	`+(26 rows)`
`331`	`334`
`332`	`335`	`-- Check if data is the same as in source, no result rows expected.`
`333`	`336`	`(TABLE aqo_data_dump EXCEPT TABLE aqo_data)`
`@@ -369,8 +372,7 @@ ORDER BY res;`
`369`	`372`	`t`
`370`	`373`	`t`
`371`	`374`	`t`
`372`		`- t`
`373`		`-(27 rows)`
	`375`	`+(26 rows)`
`374`	`376`
`375`	`377`	`-- Check if data is the same as in source, no result rows expected.`
`376`	`378`	`(TABLE aqo_data_dump EXCEPT TABLE aqo_data)`