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

Commitd9c501d

Browse files
Add nbtree ScalarArrayOpExpr tests.
Add test coverage for the nbtutils.c routines concerned with IndexScansthat have native ScalarArrayOpExpr quals. The ScalarArrayOpExprspecialized mark and restore routines, and the "find extreme element"routine now have some test coverage.These functions are probably infrequently exercised by real worldqueries, so having some coverage seems like a good idea. The mark andrestore routines were originally added by a bugfix that came severalweeks after the first stable release of Postgres 9.2 (see commit70bc583).
1 parentdd1f645 commitd9c501d

File tree

2 files changed

+65
-0
lines changed

2 files changed

+65
-0
lines changed

‎src/test/regress/expected/join.out

Lines changed: 47 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6176,6 +6176,53 @@ where j1.id1 % 1000 = 1 and j2.id1 % 1000 = 1;
61766176
1 | 2 | 1 | 2
61776177
(2 rows)
61786178

6179+
-- Exercise array keys mark/restore B-Tree code
6180+
explain (costs off) select * from j1
6181+
inner join j2 on j1.id1 = j2.id1 and j1.id2 = j2.id2
6182+
where j1.id1 % 1000 = 1 and j2.id1 % 1000 = 1 and j2.id1 = any (array[1]);
6183+
QUERY PLAN
6184+
----------------------------------------------------
6185+
Merge Join
6186+
Merge Cond: (j1.id1 = j2.id1)
6187+
Join Filter: (j1.id2 = j2.id2)
6188+
-> Index Scan using j1_id1_idx on j1
6189+
-> Index Scan using j2_id1_idx on j2
6190+
Index Cond: (id1 = ANY ('{1}'::integer[]))
6191+
(6 rows)
6192+
6193+
select * from j1
6194+
inner join j2 on j1.id1 = j2.id1 and j1.id2 = j2.id2
6195+
where j1.id1 % 1000 = 1 and j2.id1 % 1000 = 1 and j2.id1 = any (array[1]);
6196+
id1 | id2 | id1 | id2
6197+
-----+-----+-----+-----
6198+
1 | 1 | 1 | 1
6199+
1 | 2 | 1 | 2
6200+
(2 rows)
6201+
6202+
-- Exercise array keys "find extreme element" B-Tree code
6203+
explain (costs off) select * from j1
6204+
inner join j2 on j1.id1 = j2.id1 and j1.id2 = j2.id2
6205+
where j1.id1 % 1000 = 1 and j2.id1 % 1000 = 1 and j2.id1 >= any (array[1,5]);
6206+
QUERY PLAN
6207+
-------------------------------------------------------
6208+
Merge Join
6209+
Merge Cond: (j1.id1 = j2.id1)
6210+
Join Filter: (j1.id2 = j2.id2)
6211+
-> Index Scan using j1_id1_idx on j1
6212+
-> Index Only Scan using j2_pkey on j2
6213+
Index Cond: (id1 >= ANY ('{1,5}'::integer[]))
6214+
Filter: ((id1 % 1000) = 1)
6215+
(7 rows)
6216+
6217+
select * from j1
6218+
inner join j2 on j1.id1 = j2.id1 and j1.id2 = j2.id2
6219+
where j1.id1 % 1000 = 1 and j2.id1 % 1000 = 1 and j2.id1 >= any (array[1,5]);
6220+
id1 | id2 | id1 | id2
6221+
-----+-----+-----+-----
6222+
1 | 1 | 1 | 1
6223+
1 | 2 | 1 | 2
6224+
(2 rows)
6225+
61796226
reset enable_nestloop;
61806227
reset enable_hashjoin;
61816228
reset enable_sort;

‎src/test/regress/sql/join.sql

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2124,6 +2124,24 @@ select * from j1
21242124
inner join j2onj1.id1=j2.id1andj1.id2=j2.id2
21252125
wherej1.id1 %1000=1andj2.id1 %1000=1;
21262126

2127+
-- Exercise array keys mark/restore B-Tree code
2128+
explain (costs off)select*from j1
2129+
inner join j2onj1.id1=j2.id1andj1.id2=j2.id2
2130+
wherej1.id1 %1000=1andj2.id1 %1000=1andj2.id1= any (array[1]);
2131+
2132+
select*from j1
2133+
inner join j2onj1.id1=j2.id1andj1.id2=j2.id2
2134+
wherej1.id1 %1000=1andj2.id1 %1000=1andj2.id1= any (array[1]);
2135+
2136+
-- Exercise array keys "find extreme element" B-Tree code
2137+
explain (costs off)select*from j1
2138+
inner join j2onj1.id1=j2.id1andj1.id2=j2.id2
2139+
wherej1.id1 %1000=1andj2.id1 %1000=1andj2.id1>= any (array[1,5]);
2140+
2141+
select*from j1
2142+
inner join j2onj1.id1=j2.id1andj1.id2=j2.id2
2143+
wherej1.id1 %1000=1andj2.id1 %1000=1andj2.id1>= any (array[1,5]);
2144+
21272145
reset enable_nestloop;
21282146
reset enable_hashjoin;
21292147
reset enable_sort;

0 commit comments

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