Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite8633ee

Browse files
committed
Arrange code with specifics of PG15.
1 parent599fff9 commite8633ee

File tree

6 files changed

+25
-25
lines changed

6 files changed

+25
-25
lines changed

‎aqo--1.4--1.5.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -143,8 +143,8 @@ COMMENT ON FUNCTION aqo_drop_class(bigint) IS
143143
-- tables even if only one oid for one feature subspace of the space is illegal.
144144
-- Returns number of deleted rows from aqo_queries and aqo_data tables.
145145
--
146-
CREATE OR REPLACEFUNCTIONaqo_cleanup(OUT nfsinteger, OUT nfssinteger)
147-
AS'MODULE_PATHNAME','aqo_cleanup'
146+
CREATE OR REPLACEFUNCTIONaqo_cleanup()
147+
RETURNS TABLE(nfsinteger, nfssinteger)AS'MODULE_PATHNAME','aqo_cleanup'
148148
LANGUAGE C STRICT VOLATILE;
149149
COMMENT ON FUNCTION aqo_cleanup() IS
150150
'Remove unneeded rows from the AQO ML storage';

‎expected/clean_aqo_data.out‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -12,8 +12,8 @@ SELECT * FROM a;
1212

1313
SELECT 'a'::regclass::oid AS a_oid \gset
1414
SELECT true FROM aqo_cleanup();
15-
bool
16-
------
15+
?column?
16+
----------
1717
t
1818
(1 row)
1919

@@ -55,8 +55,8 @@ SELECT count(*) FROM aqo_query_stat WHERE
5555

5656
DROP TABLE a;
5757
SELECT true FROM aqo_cleanup();
58-
bool
59-
------
58+
?column?
59+
----------
6060
t
6161
(1 row)
6262

@@ -176,8 +176,8 @@ SELECT count(*) FROM aqo_query_stat WHERE
176176

177177
DROP TABLE a;
178178
SELECT true FROM aqo_cleanup();
179-
bool
180-
------
179+
?column?
180+
----------
181181
t
182182
(1 row)
183183

@@ -254,8 +254,8 @@ SELECT count(*) FROM aqo_query_stat WHERE
254254

255255
DROP TABLE b;
256256
SELECT true FROM aqo_cleanup();
257-
bool
258-
------
257+
?column?
258+
----------
259259
t
260260
(1 row)
261261

‎expected/feature_subspace.out‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -76,8 +76,8 @@ WHERE 'a'::regclass = ANY (d1.oids) AND 'b'::regclass = ANY (d1.oids) order by t
7676

7777
DROP TABLE a,b CASCADE;
7878
SELECT true FROM aqo_reset();
79-
bool
80-
------
79+
?column?
80+
----------
8181
t
8282
(1 row)
8383

‎expected/gucs.out‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -6,8 +6,8 @@ CREATE TABLE t(x int);
66
INSERT INTO t (x) (SELECT * FROM generate_series(1, 100) AS gs);
77
ANALYZE t;
88
SELECT true FROM aqo_reset(); -- Remember! DROP EXTENSION doesn't remove any AQO data gathered.
9-
bool
10-
------
9+
?column?
10+
----------
1111
t
1212
(1 row)
1313

@@ -90,10 +90,10 @@ SELECT obj_description('aqo_reset'::regproc::oid);
9090
(1 row)
9191

9292
\df aqo_cleanup
93-
List of functions
94-
Schema | Name |Result data type | Argument data types | Type
95-
--------+-------------+------------------+-----------------------------------+------
96-
public | aqo_cleanup |record| OUT nfs integer, OUT nfss integer | func
93+
List of functions
94+
Schema | Name |Result data type| Argument data types | Type
95+
--------+-------------+----------------------------------+---------------------+------
96+
public | aqo_cleanup |TABLE(nfs integer, nfss integer) | | func
9797
(1 row)
9898

9999
\df aqo_reset
@@ -111,8 +111,8 @@ SELECT count(*) FROM aqo_query_stat;
111111
(1 row)
112112

113113
SELECT true FROM aqo_reset(); -- Remove one record from all tables
114-
bool
115-
------
114+
?column?
115+
----------
116116
t
117117
(1 row)
118118

‎expected/look_a_like.out‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -232,8 +232,8 @@ WHERE str NOT LIKE 'Query Identifier%' and str NOT LIKE '%Memory%';
232232

233233
DROP TABLE a,b CASCADE;
234234
SELECT true FROM aqo_reset();
235-
bool
236-
------
235+
?column?
236+
----------
237237
t
238238
(1 row)
239239

‎expected/unsupported.out‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,7 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
4444
AQO not used
4545
Group Key: x
4646
-> Seq Scan on t (actual rows=801 loops=1)
47-
AQO not used
47+
AQO: rows=801, error=0%
4848
Filter: (x > 3)
4949
Rows Removed by Filter: 199
5050
Using aqo: true
@@ -605,13 +605,13 @@ DROP TABLE t,t1 CASCADE; -- delete all tables used in the test
605605
SELECT count(*) FROM aqo_data; -- Just to detect some changes in the logic. May some false positives really bother us here?
606606
count
607607
-------
608-
42
608+
44
609609
(1 row)
610610

611611
SELECT * FROM aqo_cleanup();
612612
nfs | nfss
613613
-----+------
614-
12 |42
614+
13 |44
615615
(1 row)
616616

617617
SELECT count(*) FROM aqo_data; -- No one row should be returned

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp