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

Commit06b9f38

Browse files
author
Etsuro Fujita
committed
Clean up some misplaced comments in partition_join.sql regression test.
Also, add a comment explaining a test case.Back-patch to 11 where the regression test was added.Discussion:https://postgr.es/m/CAPmGK15adZPh2B%2BmGUjSOMH%2BH39ogDRWfCfm4G6jncZCAs9V_Q%40mail.gmail.com
1 parent332584d commit06b9f38

File tree

2 files changed

+13
-8
lines changed

2 files changed

+13
-8
lines changed

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

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1857,8 +1857,8 @@ SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_m t1 LEFT JOIN prt2_m t2 ON t1.c = t2.c;
18571857
-> Seq Scan on prt2_m_p3 t2_2
18581858
(11 rows)
18591859

1860-
-- partitionwise join can not be applied betweentables with different
1861-
--partition lists
1860+
-- partitionwise join can not be appliedfor a joinbetweenlist and range
1861+
--partitioned tables
18621862
EXPLAIN (COSTS OFF)
18631863
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_n t1 LEFT JOIN prt2_n t2 ON (t1.c = t2.c);
18641864
QUERY PLAN
@@ -1874,6 +1874,8 @@ SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_n t1 LEFT JOIN prt2_n t2 ON (t1.c = t2.c
18741874
-> Seq Scan on prt1_n_p2 t1_1
18751875
(9 rows)
18761876

1877+
-- partitionwise join can not be applied between tables with different
1878+
-- partition lists
18771879
EXPLAIN (COSTS OFF)
18781880
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_n t1 JOIN prt2_n t2 ON (t1.c = t2.c) JOIN plt1 t3 ON (t1.c = t3.c);
18791881
QUERY PLAN
@@ -1896,8 +1898,8 @@ SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_n t1 JOIN prt2_n t2 ON (t1.c = t2.c) JOI
18961898
-> Seq Scan on prt1_n_p2 t1_1
18971899
(16 rows)
18981900

1899-
-- partitionwise join can not be applied for a join betweenlist and range
1900-
--partitioned tables
1901+
-- partitionwise join can not be applied for a join betweenkey column and
1902+
--non-key column
19011903
EXPLAIN (COSTS OFF)
19021904
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_n t1 FULL JOIN prt1 t2 ON (t1.c = t2.c);
19031905
QUERY PLAN

‎src/test/regress/sql/partition_join.sql

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -394,14 +394,17 @@ SELECT t1.a, t1.c, t2.b, t2.c FROM prt1_m t1 LEFT JOIN prt2_m t2 ON t1.a = t2.b;
394394
EXPLAIN (COSTS OFF)
395395
SELECTt1.a,t1.c,t2.b,t2.cFROM prt1_m t1LEFT JOIN prt2_m t2ONt1.c=t2.c;
396396

397-
-- partitionwise join can not be applied betweentables with different
398-
--partition lists
397+
-- partitionwise join can not be appliedfor a joinbetweenlist and range
398+
--partitioned tables
399399
EXPLAIN (COSTS OFF)
400400
SELECTt1.a,t1.c,t2.b,t2.cFROM prt1_n t1LEFT JOIN prt2_n t2ON (t1.c=t2.c);
401+
402+
-- partitionwise join can not be applied between tables with different
403+
-- partition lists
401404
EXPLAIN (COSTS OFF)
402405
SELECTt1.a,t1.c,t2.b,t2.cFROM prt1_n t1JOIN prt2_n t2ON (t1.c=t2.c)JOIN plt1 t3ON (t1.c=t3.c);
403406

404-
-- partitionwise join can not be applied for a join betweenlist and range
405-
--partitioned tables
407+
-- partitionwise join can not be applied for a join betweenkey column and
408+
--non-key column
406409
EXPLAIN (COSTS OFF)
407410
SELECTt1.a,t1.c,t2.b,t2.cFROM prt1_n t1 FULLJOIN prt1 t2ON (t1.c=t2.c);

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp