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

Commitaea4aec

Browse files
Alena Rybakinadanolivo
Alena Rybakina
authored andcommitted
[PGPRO-7183] bring in line stable 13, 14, 15
Cherry-pick commit:961bdcfFix aqo_fdw output test.
1 parent073b4d7 commitaea4aec

File tree

2 files changed

+20
-10
lines changed

2 files changed

+20
-10
lines changed

‎expected/aqo_fdw.out

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -169,10 +169,13 @@ INSERT INTO main SELECT i, 'val_' || i FROM generate_series(1,100) i;
169169
INSERT INTO ref SELECT i, mod(i, 10) + 1, 'val_' || i FROM generate_series(1,1000) i;
170170
ANALYZE local_main_p0, local_main_p1, main_p2;
171171
ANALYZE local_ref_p0, local_ref_p1, ref_p2;
172+
SELECT str AS result
173+
FROM expln('
172174
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
173175
SELECT * from main AS a, ref AS b
174-
WHERE a.aid = b.aid AND b.bval like 'val%';
175-
QUERY PLAN
176+
WHERE a.aid = b.aid AND b.bval like ''val%''') AS str
177+
WHERE str NOT LIKE '%Memory%';
178+
result
176179
--------------------------------------------------------------------
177180
Append (actual rows=1000 loops=1)
178181
AQO not used
@@ -189,18 +192,20 @@ WHERE a.aid = b.aid AND b.bval like 'val%';
189192
AQO not used
190193
Filter: (bval ~~ 'val%'::text)
191194
-> Hash (actual rows=38 loops=1)
192-
Buckets: 1024 Batches: 1 Memory Usage: 10kB
193195
-> Seq Scan on main_p2 a_3 (actual rows=38 loops=1)
194196
AQO not used
195197
Using aqo: true
196198
AQO mode: LEARN
197199
JOINS: 1
198-
(21 rows)
200+
(20 rows)
199201

202+
SELECT str AS result
203+
FROM expln('
200204
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
201205
SELECT * from main AS a, ref AS b
202-
WHERE a.aid = b.aid AND b.bval like 'val%';
203-
QUERY PLAN
206+
WHERE a.aid = b.aid AND b.bval like ''val%''') AS str
207+
WHERE str NOT LIKE '%Memory%';
208+
result
204209
--------------------------------------------------------------------
205210
Append (actual rows=1000 loops=1)
206211
AQO not used
@@ -217,13 +222,12 @@ WHERE a.aid = b.aid AND b.bval like 'val%';
217222
AQO: rows=300, error=0%
218223
Filter: (bval ~~ 'val%'::text)
219224
-> Hash (actual rows=38 loops=1)
220-
Buckets: 1024 Batches: 1 Memory Usage: 10kB
221225
-> Seq Scan on main_p2 a_3 (actual rows=38 loops=1)
222226
AQO: rows=38, error=0%
223227
Using aqo: true
224228
AQO mode: LEARN
225229
JOINS: 1
226-
(21 rows)
230+
(20 rows)
227231

228232
DROP TABLE main, local_main_p0, local_main_p1;
229233
DROP TABLE ref, local_ref_p0, local_ref_p1;

‎sql/aqo_fdw.sql

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -107,13 +107,19 @@ INSERT INTO ref SELECT i, mod(i, 10) + 1, 'val_' || i FROM generate_series(1,100
107107
ANALYZE local_main_p0, local_main_p1, main_p2;
108108
ANALYZE local_ref_p0, local_ref_p1, ref_p2;
109109

110+
SELECT strAS result
111+
FROM expln('
110112
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
111113
SELECT * from main AS a, ref AS b
112-
WHEREa.aid=b.aidANDb.bvallike'val%';
114+
WHERE a.aid = b.aid AND b.bval like''val%''')AS str
115+
WHERE str NOTLIKE'%Memory%';
113116

117+
SELECT strAS result
118+
FROM expln('
114119
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
115120
SELECT * from main AS a, ref AS b
116-
WHEREa.aid=b.aidANDb.bvallike'val%';
121+
WHERE a.aid = b.aid AND b.bval like''val%''')AS str
122+
WHERE str NOTLIKE'%Memory%';
117123

118124
DROPTABLE main, local_main_p0, local_main_p1;
119125
DROPTABLE ref, local_ref_p0, local_ref_p1;

0 commit comments

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