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

Commit9ba9c70

Browse files
committed
Fix some regression tests ford3d55ce
Add missing (cost off) to explain.
1 parentd3d55ce commit9ba9c70

File tree

2 files changed

+24
-18
lines changed

2 files changed

+24
-18
lines changed

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

Lines changed: 18 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -6729,30 +6729,33 @@ SELECT * FROM emp1 e1, emp1 e2 WHERE e1.id = e2.id AND e2.code <> e1.code;
67296729
-- Shuffle self-joined relations. Only in the case of iterative deletion
67306730
-- attempts explains of these queries will be identical.
67316731
CREATE UNIQUE INDEX ON emp1((id*id));
6732-
explain SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
6732+
explain (costs off)
6733+
SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
67336734
WHERE c1.id=c2.id AND c1.id*c2.id=c3.id*c3.id;
6734-
QUERY PLAN
6735-
-----------------------------------------------------------------
6736-
Aggregate (cost=43.84..43.85 rows=1 width=8)
6737-
-> Seq Scan on emp1 c3 (cost=0.00..38.25 rows=2237 width=0)
6735+
QUERY PLAN
6736+
----------------------------------------------------------------
6737+
Aggregate
6738+
-> Seq Scan on emp1 c3
67386739
Filter: ((id IS NOT NULL) AND ((id * id) IS NOT NULL))
67396740
(3 rows)
67406741

6741-
explain SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
6742+
explain (costs off)
6743+
SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
67426744
WHERE c1.id=c3.id AND c1.id*c3.id=c2.id*c2.id;
6743-
QUERY PLAN
6744-
-----------------------------------------------------------------
6745-
Aggregate (cost=43.84..43.85 rows=1 width=8)
6746-
-> Seq Scan on emp1 c3 (cost=0.00..38.25 rows=2237 width=0)
6745+
QUERY PLAN
6746+
----------------------------------------------------------------
6747+
Aggregate
6748+
-> Seq Scan on emp1 c3
67476749
Filter: ((id IS NOT NULL) AND ((id * id) IS NOT NULL))
67486750
(3 rows)
67496751

6750-
explain SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
6752+
explain (costs off)
6753+
SELECT count(*) FROM emp1 c1, emp1 c2, emp1 c3
67516754
WHERE c3.id=c2.id AND c3.id*c2.id=c1.id*c1.id;
6752-
QUERY PLAN
6753-
-----------------------------------------------------------------
6754-
Aggregate (cost=43.84..43.85 rows=1 width=8)
6755-
-> Seq Scan on emp1 c3 (cost=0.00..38.25 rows=2237 width=0)
6755+
QUERY PLAN
6756+
----------------------------------------------------------------
6757+
Aggregate
6758+
-> Seq Scan on emp1 c3
67566759
Filter: ((id IS NOT NULL) AND ((id * id) IS NOT NULL))
67576760
(3 rows)
67586761

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

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2563,11 +2563,14 @@ SELECT * FROM emp1 e1, emp1 e2 WHERE e1.id = e2.id AND e2.code <> e1.code;
25632563
-- Shuffle self-joined relations. Only in the case of iterative deletion
25642564
-- attempts explains of these queries will be identical.
25652565
CREATEUNIQUE INDEXON emp1((id*id));
2566-
explainSELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
2566+
explain (costs off)
2567+
SELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
25672568
WHEREc1.id=c2.idANDc1.id*c2.id=c3.id*c3.id;
2568-
explainSELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
2569+
explain (costs off)
2570+
SELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
25692571
WHEREc1.id=c3.idANDc1.id*c3.id=c2.id*c2.id;
2570-
explainSELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
2572+
explain (costs off)
2573+
SELECTcount(*)FROM emp1 c1, emp1 c2, emp1 c3
25712574
WHEREc3.id=c2.idANDc3.id*c2.id=c1.id*c1.id;
25722575

25732576
-- We can remove the join even if we find the join can't duplicate rows and

0 commit comments

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