10000 Reset aqo data before droping test table. · postgrespro/aqo@af377b4 · GitHub
[go: up one dir, main page]

Skip to content

Commit af377b4

Browse files
author
Alena Rybakina
committed
Reset aqo data before droping test table.
1 parent 714a817 commit af377b4

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

expected/statement_timeout.out

Lines changed: 1 addition & 1 deletion
< 8000 td data-grid-cell-id="diff-87a3f638cfb1d41edda7cd73cfad88f595dd069c1dcabf00d8db12f0b53b4dfc-111-111-1" data-selected="false" role="gridcell" style="background-color:var(--bgColor-default);text-align:center" tabindex="-1" valign="top" class="focusable-grid-cell diff-line-number position-relative diff-line-number-neutral left-side">111
Original file line numberDiff line numberDiff line change
@@ -111,12 +111,12 @@ SELECT check_estimated_rows('SELECT *, pg_sleep(1) FROM t;');
111
5
112112
(1 row)
113113

114-
DROP TABLE t;
115114
SELECT 1 FROM aqo_reset();
116115
?column?
117116
----------
118117
1
119118
(1 row)
120119

120+
DROP TABLE t;
121121
DROP EXTENSION aqo;
122122
DROP FUNCTION check_estimated_rows;

sql/statement_timeout.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -60,7 +60,7 @@ SET statement_timeout = 5500;
6060
SELECT *, pg_sleep(1) FROM t; -- Get reliable data
6161
SELECT check_estimated_rows('SELECT *, pg_sleep(1) FROM t;');
6262

63-
DROP TABLE t;
6463
SELECT 1 FROM aqo_reset();
64+
DROP TABLE t;
6565
DROP EXTENSION aqo;
6666
DROP FUNCTION check_estimated_rows;

0 commit comments

Comments
 (0)
0