Reset aqo data before droping test table.

Alena Rybakina · Alena Rybakina · commit af377b4b56cb · 2022-10-18T11:29:04.000+03:00
diff --git a/expected/statement_timeout.out b/expected/statement_timeout.out
@@ -111,12 +111,12 @@ SELECT check_estimated_rows('SELECT *, pg_sleep(1) FROM t;');
                     5
 (1 row)
 
-DROP TABLE t;
 SELECT 1 FROM aqo_reset();
  ?column? 
 ----------
         1
 (1 row)
 
+DROP TABLE t;
 DROP EXTENSION aqo;
 DROP FUNCTION check_estimated_rows;
diff --git a/sql/statement_timeout.sql b/sql/statement_timeout.sql
@@ -60,7 +60,7 @@ SET statement_timeout = 5500;
 SELECT *, pg_sleep(1) FROM t; -- Get reliable data
 SELECT check_estimated_rows('SELECT *, pg_sleep(1) FROM t;');
 
-DROP TABLE t;
 SELECT 1 FROM aqo_reset();
+DROP TABLE t;
 DROP EXTENSION aqo;
 DROP FUNCTION check_estimated_rows;

Original file line number	Diff line number	Diff line change
`@@ -111,12 +111,12 @@ SELECT check_estimated_rows('SELECT *, pg_sleep(1) FROM t;');`
`111`	`111`	`5`
`112`	`112`	`(1 row)`
`113`	`113`
`114`		`-DROP TABLE t;`
`115`	`114`	`SELECT 1 FROM aqo_reset();`
`116`	`115`	`?column?`
`117`	`116`	`----------`
`118`	`117`	`1`
`119`	`118`	`(1 row)`
`120`	`119`
	`120`	`+DROP TABLE t;`
`121`	`121`	`DROP EXTENSION aqo;`
`122`	`122`	`DROP FUNCTION check_estimated_rows;`