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

Commitafbec7f

Browse files
author
Ekaterina Sokolova
committed
Update pg_pathman due to vanilla PostgreSQL.
1. Fix regression output due to fd0398fcb099. Changed tests: pathman_only and pathman_rowmarks.2. Fix code due to commit d20d8fbd3e4d.3. Fix comments in test files due to alternate outputs.
1 parent92b69d8 commitafbec7f

14 files changed

+939
-46
lines changed

‎expected/pathman_only.out‎

Lines changed: 22 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,13 +3,31 @@
33
* NOTE: This test behaves differenly on PgPro
44
* ---------------------------------------------
55
*
6-
* Since 12 (608b167f9f), CTEs which are scanned once are no longer an
7-
* optimization fence, which changes practically all plans here. There is
6+
* --------------------
7+
* pathman_only_1.sql
8+
* --------------------
9+
* Since 608b167f9f in PostgreSQL 12, CTEs which are scanned once are no longer
10+
* an optimization fence, which changes practically all plans here. There is
811
* an option to forcibly make them MATERIALIZED, but we also need to run tests
912
* on older versions, so create pathman_only_1.out instead.
1013
*
11-
* Since 55a1954da16 and 6ef77cf46e8 (>= 13) output of EXPLAIN was changed,
12-
* now it includes aliases for inherited tables.
14+
* --------------------
15+
* pathman_only_2.sql
16+
* --------------------
17+
* Since 55a1954da16 and 6ef77cf46e8 in PostgreSQL 13, output of EXPLAIN was
18+
* changed, now it includes aliases for inherited tables.
19+
*
20+
* --------------------
21+
* pathman_only_3.sql
22+
* --------------------
23+
* Since a5fc46414de in PostgreSQL 16, the order of the operands was changed,
24+
* which affected the output of the "Prune by" in EXPLAIN.
25+
*
26+
* --------------------
27+
* pathman_only_4.sql
28+
* --------------------
29+
* Since fd0398fcb09 in PostgreSQL 17, output of EXPLAIN was
30+
* changed, now it displays SubPlan nodes and output parameters.
1331
*/
1432
\set VERBOSITY terse
1533
SET search_path = 'public';

‎expected/pathman_only_1.out‎

Lines changed: 22 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,13 +3,31 @@
33
* NOTE: This test behaves differenly on PgPro
44
* ---------------------------------------------
55
*
6-
* Since 12 (608b167f9f), CTEs which are scanned once are no longer an
7-
* optimization fence, which changes practically all plans here. There is
6+
* --------------------
7+
* pathman_only_1.sql
8+
* --------------------
9+
* Since 608b167f9f in PostgreSQL 12, CTEs which are scanned once are no longer
10+
* an optimization fence, which changes practically all plans here. There is
811
* an option to forcibly make them MATERIALIZED, but we also need to run tests
912
* on older versions, so create pathman_only_1.out instead.
1013
*
11-
* Since 55a1954da16 and 6ef77cf46e8 (>= 13) output of EXPLAIN was changed,
12-
* now it includes aliases for inherited tables.
14+
* --------------------
15+
* pathman_only_2.sql
16+
* --------------------
17+
* Since 55a1954da16 and 6ef77cf46e8 in PostgreSQL 13, output of EXPLAIN was
18+
* changed, now it includes aliases for inherited tables.
19+
*
20+
* --------------------
21+
* pathman_only_3.sql
22+
* --------------------
23+
* Since a5fc46414de in PostgreSQL 16, the order of the operands was changed,
24+
* which affected the output of the "Prune by" in EXPLAIN.
25+
*
26+
* --------------------
27+
* pathman_only_4.sql
28+
* --------------------
29+
* Since fd0398fcb09 in PostgreSQL 17, output of EXPLAIN was
30+
* changed, now it displays SubPlan nodes and output parameters.
1331
*/
1432
\set VERBOSITY terse
1533
SET search_path = 'public';

‎expected/pathman_only_2.out‎

Lines changed: 22 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,13 +3,31 @@
33
* NOTE: This test behaves differenly on PgPro
44
* ---------------------------------------------
55
*
6-
* Since 12 (608b167f9f), CTEs which are scanned once are no longer an
7-
* optimization fence, which changes practically all plans here. There is
6+
* --------------------
7+
* pathman_only_1.sql
8+
* --------------------
9+
* Since 608b167f9f in PostgreSQL 12, CTEs which are scanned once are no longer
10+
* an optimization fence, which changes practically all plans here. There is
811
* an option to forcibly make them MATERIALIZED, but we also need to run tests
912
* on older versions, so create pathman_only_1.out instead.
1013
*
11-
* Since 55a1954da16 and 6ef77cf46e8 (>= 13) output of EXPLAIN was changed,
12-
* now it includes aliases for inherited tables.
14+
* --------------------
15+
* pathman_only_2.sql
16+
* --------------------
17+
* Since 55a1954da16 and 6ef77cf46e8 in PostgreSQL 13, output of EXPLAIN was
18+
* changed, now it includes aliases for inherited tables.
19+
*
20+
* --------------------
21+
* pathman_only_3.sql
22+
* --------------------
23+
* Since a5fc46414de in PostgreSQL 16, the order of the operands was changed,
24+
* which affected the output of the "Prune by" in EXPLAIN.
25+
*
26+
* --------------------
27+
* pathman_only_4.sql
28+
* --------------------
29+
* Since fd0398fcb09 in PostgreSQL 17, output of EXPLAIN was
30+
* changed, now it displays SubPlan nodes and output parameters.
1331
*/
1432
\set VERBOSITY terse
1533
SET search_path = 'public';

‎expected/pathman_only_3.out‎

Lines changed: 22 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,13 +3,31 @@
33
* NOTE: This test behaves differenly on PgPro
44
* ---------------------------------------------
55
*
6-
* Since 12 (608b167f9f), CTEs which are scanned once are no longer an
7-
* optimization fence, which changes practically all plans here. There is
6+
* --------------------
7+
* pathman_only_1.sql
8+
* --------------------
9+
* Since 608b167f9f in PostgreSQL 12, CTEs which are scanned once are no longer
10+
* an optimization fence, which changes practically all plans here. There is
811
* an option to forcibly make them MATERIALIZED, but we also need to run tests
912
* on older versions, so create pathman_only_1.out instead.
1013
*
11-
* Since 55a1954da16 and 6ef77cf46e8 (>= 13) output of EXPLAIN was changed,
12-
* now it includes aliases for inherited tables.
14+
* --------------------
15+
* pathman_only_2.sql
16+
* --------------------
17+
* Since 55a1954da16 and 6ef77cf46e8 in PostgreSQL 13, output of EXPLAIN was
18+
* changed, now it includes aliases for inherited tables.
19+
*
20+
* --------------------
21+
* pathman_only_3.sql
22+
* --------------------
23+
* Since a5fc46414de in PostgreSQL 16, the order of the operands was changed,
24+
* which affected the output of the "Prune by" in EXPLAIN.
25+
*
26+
* --------------------
27+
* pathman_only_4.sql
28+
* --------------------
29+
* Since fd0398fcb09 in PostgreSQL 17, output of EXPLAIN was
30+
* changed, now it displays SubPlan nodes and output parameters.
1331
*/
1432
\set VERBOSITY terse
1533
SET search_path = 'public';

0 commit comments

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