Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
1 patchset tracked - current t139899_8
v8t139899_8posted Jul 23, 14:44tests failedwon't retrystale 44dpg 20
base1a531f787 Sep 08, 03:42 on master
applyapplied Sep 08, 05:03
rebaselast tried Oct 07, 12:01 on 00e917ef6
Applying: Rebase UniqueKeys onto master (Andy Fan v3 + Houska 0002-0004) Using index info to reconstruct a base tree... M src/backend/nodes/list.c M src/backend/optimizer/path/allpaths.c M src/backend/optimizer/path/equivclass.c M src/backend/optimizer/path/joinrels.c M src/backend/optimizer/path/pathkeys.c M src/backend/optimizer/plan/analyzejoins.c M src/backend/optimizer/plan/initsplan.c M src/backend/optimizer/plan/planner.c M src/backend/optimizer/util/plancat.c M src/backend/optimizer/util/relnode.c M src/include/nodes/pathnodes.h M src/include/optimizer/paths.h M src/test/regress/expected/join.out M src/test/regress/parallel_schedule M src/test/regress/sql/join.sql Falling back to patching base and 3-way merge... Auto-merging src/test/regress/sql/join.sql Auto-merging src/test/regress/parallel_schedule Auto-merging src/test/regress/expected/join.out Auto-merging src/include/optimizer/paths.h CONFLICT (content): Merge conflict in src/include/optimizer/paths.h Auto-merging src/include/nodes/pathnodes.h Auto-merging src/backend/optimizer/util/relnode.c Auto-merging src/backend/optimizer/util/plancat.c Auto-merging src/backend/optimizer/plan/planner.c Auto-merging src/backend/optimizer/plan/initsplan.c Auto-merging src/backend/optimizer/plan/analyzejoins.c Auto-merging src/backend/optimizer/path/pathkeys.c Auto-merging src/backend/optimizer/path/joinrels.c Auto-merging src/backend/optimizer/path/equivclass.c CONFLICT (content): Merge conflict in src/backend/optimizer/path/equivclass.c Auto-merging src/backend/optimizer/path/allpaths.c Auto-merging src/backend/nodes/list.c Patch failed at 0001 Rebase UniqueKeys onto master (Andy Fan v3 + Houska 0002-0004) error: Failed to merge in the changes. hint: Use 'git am --show-current-patch=diff' to see the failed patch hint: When you have resolved this problem, run "git am --continue". hint: If you prefer to skip this patch, run "git am --skip" instead. hint: To restore the original branch and stop patching, run "git am --abort". hint: Disable this message with "git config advice.mergeConflict false"
conflicts on master: src/include/optimizer/paths.h, src/backend/optimizer/path/equivclass.c
pushSep 08, 05:03 -> 4ba6205acbranchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| tests failed | 1 | 20 | 477 / 486 | 2m 46s / 2m 33s | docker run ... :t139899 | Sep 08, 05:11 |
run 34189173039failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, pg_upgrade/002_pg_upgrade executed 486 - ccache 98 hit / 6524 miss - head 4ba6205ac - digest sha256:8306cda5757507... - run 34189173039 | ||||||
| tests failed | 1 | 20 | 595 / 605 | 1m 41s / 2m 18s | docker run ... @sha256:1243d04... | Sep 07, 05:09 |
run 34085191807failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 605 - ccache 98 hit / 6528 miss - head b126825b6 - digest sha256:1243d0455af20f... - run 34085191807 | ||||||
| tests failed | 1 | 20 | 634 / 645 | 2m 54s / 5m 20s | docker run ... @sha256:3c89f1a... | Sep 05, 07:03 |
run 33950993382failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 645 - ccache 98 hit / 6521 miss - head f8dcf7bb3 - digest sha256:3c89f1aec16d78... - run 33950993382 | ||||||
| tests failed | 1 | 20 | 622 / 632 | 3m 02s / 3m 15s | docker run ... @sha256:efa017a... | Sep 04, 07:03 |
run 33846030753failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 632 - ccache 98 hit / 6528 miss - head 23348d9d1 - digest sha256:efa017aae446cf... - run 33846030753 | ||||||
| tests failed | 1 | 20 | 597 / 607 | 2m 53s / 3m 06s | docker run ... @sha256:cdf8fa9... | Sep 03, 06:59 |
run 33724956475failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 607 - ccache 98 hit / 6527 miss - head b6516fa42 - digest sha256:cdf8fa9cef5f8d... - run 33724956475 | ||||||
| tests failed | 1 | 20 | 615 / 625 | 2m 51s / 3m 06s | docker run ... @sha256:d187354... | Sep 02, 06:54 |
run 33600230125failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 625 - ccache 98 hit / 6527 miss - head fae890864 - digest sha256:d187354aa00738... - run 33600230125 | ||||||
| tests failed | 1 | 20 | 596 / 606 | 2m 58s / 3m 13s | docker run ... @sha256:3d21b20... | Sep 01, 06:57 |
run 33478733907failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 606 - ccache 98 hit / 6527 miss - head 3a64a33d4 - digest sha256:3d21b20d26c35c... - run 33478733907 | ||||||
| tests failed | 1 | 20 | 588 / 598 | 2m 56s / 3m 14s | docker run ... @sha256:3eaf6be... | Aug 31, 06:34 |
run 33364071134failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 598 - ccache 98 hit / 6527 miss - head d7ae557b0 - digest sha256:3eaf6be2c447c6... - run 33364071134 | ||||||
| tests failed | 1 | 20 | 588 / 598 | 2m 37s / 2m 50s | docker run ... @sha256:402a6a4... | Aug 30, 06:20 |
run 33296322063failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 598 - ccache 98 hit / 6526 miss - head eb488a029 - digest sha256:402a6a45f1f0f8... - run 33296322063 | ||||||
| tests failed | 1 | 20 | 576 / 586 | 2m 55s / 3m 10s | docker run ... @sha256:d117a44... | Aug 29, 06:20 |
run 33237822376failed: isolation/matview-write-skew, isolation/lock-nowait, isolation/for-portion-of, isolation/ddl-dependency-locking, isolation/pub-concurrent-drop, isolation/drop-owned-grant, postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade executed 586 - ccache 98 hit / 6526 miss - head 9703028e6 - digest sha256:d117a440411d2e... - run 33237822376 | ||||||
| tests failed | 1 | 20 | 940 / 944 | 2m 46s / 5m 14s | docker run ... @sha256:c4074c8... | Aug 28, 06:16 |
run 33146795743failed: regress/join, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 944 - ccache 98 hit / 6526 miss - head e6a51e106 - digest sha256:c4074c8fab5c21... - run 33146795743 | ||||||
| tests failed | 1 | 20 | 940 / 944 | 2m 54s / 5m 17s | docker run ... @sha256:18a5ea8... | Aug 27, 06:15 |
run 33044624825failed: regress/join, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 944 - ccache 98 hit / 6526 miss - head 1c0224d21 - digest sha256:18a5ea8bba123f... - run 33044624825 | ||||||
| tests failed | 1 | 20 | 934 / 938 | 2m 49s / 5m 25s | docker run ... @sha256:242e309... | Aug 26, 05:52 |
run 32935070549failed: regress/join, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 938 - ccache 98 hit / 6526 miss - head 62d241ef1 - digest sha256:242e3095a87e43... - run 32935070549 | ||||||
| tests failed | 1 | 20 | 690 / 693 | 2m 01s / 4m 28s | docker run ... @sha256:ecdd86e... | Aug 25, 05:41 |
run 32813188027failed: test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 693 - ccache 98 hit / 6526 miss - head 107e59868 - digest sha256:ecdd86e3ca6539... - run 32813188027 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 59s / 5m 33s | docker run ... @sha256:563b55a... | Aug 24, 05:41 |
run 32693732899executed 1024 - ccache 98 hit / 6526 miss - head dcd949473 - digest sha256:563b55a942a881... - run 32693732899 | ||||||
| success | 1 | 20 | 1024 / 1024 | 3m 01s / 5m 23s | docker run ... @sha256:375989b... | Aug 23, 05:40 |
run 32620389208executed 1024 - ccache 98 hit / 6526 miss - head 5a02d7d80 - digest sha256:375989b5b4f36f... - run 32620389208 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 20s / 4m 10s | docker run ... @sha256:7ae585d... | Aug 22, 05:35 |
run 32554334543executed 1024 - ccache 98 hit / 6526 miss - head 17bb0f5bc - digest sha256:7ae585d1016c61... - run 32554334543 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 48s / 5m 26s | docker run ... @sha256:eec9820... | Aug 21, 05:36 |
run 32450440906executed 1024 - ccache 98 hit / 6526 miss - head acc0299a5 - digest sha256:eec9820be38fd5... - run 32450440906 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 16s / 4m 20s | docker run ... @sha256:fde2fa0... | Aug 20, 05:32 |
run 32335421235executed 1024 - ccache 98 hit / 6526 miss - head 67f8b8bf7 - digest sha256:fde2fa07a702ee... - run 32335421235 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 54s / 5m 40s | docker run ... @sha256:264e437... | Aug 19, 05:39 |
run 32219144449executed 1024 - ccache 98 hit / 6526 miss - head 02de293f7 - digest sha256:264e43750ab445... - run 32219144449 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 48s / 5m 07s | docker run ... @sha256:09011a2... | Aug 18, 05:36 |
run 32102481256executed 1021 - ccache 98 hit / 6525 miss - head 6be2b7f1c - digest sha256:09011a27353d34... - run 32102481256 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 55s / 5m 30s | docker run ... @sha256:e956ef2... | Aug 17, 05:36 |
run 31997411516executed 1020 - ccache 98 hit / 6525 miss - head b16275430 - digest sha256:e956ef2e11f2f3... - run 31997411516 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 57s / 5m 39s | docker run ... @sha256:920ea5c... | Aug 16, 05:22 |
run 31928372381executed 1020 - ccache 98 hit / 6525 miss - head ff820697b - digest sha256:920ea5c8279e41... - run 31928372381 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 56s / 5m 33s | docker run ... @sha256:aac52a4... | Aug 15, 05:21 |
run 31866219770executed 1020 - ccache 98 hit / 6525 miss - head 5e3237369 - digest sha256:aac52a4ac1eb84... - run 31866219770 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 54s / 5m 36s | docker run ... @sha256:833b32f... | Aug 14, 05:19 |
run 31771963042executed 1020 - ccache 165 hit / 6458 miss - head 6d5a28467 - digest sha256:833b32fd5ff101... - run 31771963042 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 55s / 5m 30s | docker run ... @sha256:2f820a6... | Aug 13, 05:16 |
run 31669059403executed 1020 - ccache 165 hit / 6458 miss - head 8d05a0334 - digest sha256:2f820a66b41a38... - run 31669059403 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 55s / 5m 13s | docker run ... @sha256:e2a4d0e... | Aug 12, 05:15 |
run 31565275531executed 1020 - ccache 165 hit / 6455 miss - head 6389d3c7f - digest sha256:e2a4d0e40e3fb2... - run 31565275531 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 51s / 5m 27s | docker run ... @sha256:362216d... | Aug 11, 05:13 |
run 31460364813executed 1020 - ccache 165 hit / 6454 miss - head 1f06c3a12 - digest sha256:362216d4efb3b5... - run 31460364813 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 47s / 5m 31s | docker run ... @sha256:c45f1c0... | Aug 10, 05:19 |
run 31357193376executed 1020 - ccache 166 hit / 6453 miss - head 87262e4d4 - digest sha256:c45f1c086b1306... - run 31357193376 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 53s / 5m 19s | docker run ... @sha256:96c484d... | Aug 08, 03:51 |
run 31237690648executed 1020 - ccache 166 hit / 6453 miss - head 079eaad65 - digest sha256:96c484d96d3e96... - run 31237690648 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 37s / 4m 07s | docker run ... @sha256:b367292... | Aug 07, 03:49 |
run 31144935842executed 1019 - ccache 166 hit / 6453 miss - head 6212d7aa9 - digest sha256:b367292ebe3c8a... - run 31144935842 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 56s / 5m 24s | docker run ... @sha256:0630b93... | Aug 05, 22:13 |
run 31051200468executed 1019 - ccache 166 hit / 6453 miss - head c9e0f9f5f - digest sha256:0630b93bd688d5... - run 31051200468 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 57s / 5m 36s | docker run ... @sha256:431fdbf... | Aug 04, 22:13 |
run 30954824151executed 1019 - ccache 166 hit / 6453 miss - head 4bc8e20aa - digest sha256:431fdbf1307f6c... - run 30954824151 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 47s / 5m 01s | docker run ... @sha256:76da564... | Aug 03, 22:11 |
run 30857044369executed 1019 - ccache 166 hit / 6453 miss - head ef39d4ced - digest sha256:76da564da301f8... - run 30857044369 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 56s / 5m 17s | docker run ... @sha256:e052a5d... | Aug 02, 22:11 |
run 30769144974executed 1018 - ccache 166 hit / 6453 miss - head 8865ae3e2 - digest sha256:e052a5d41c6db1... - run 30769144974 | ||||||
| success | 1 | 20 | 1018 / 1018 | 1m 51s / 3m 50s | docker run ... @sha256:19d3576... | Aug 01, 22:07 |
run 30720317267executed 1018 - ccache 166 hit / 6453 miss - head a06f0c20d - digest sha256:19d357685df1d5... - run 30720317267 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 54s / 5m 25s | docker run ... @sha256:d0c7d91... | Jul 31, 22:09 |
run 30668409135executed 1018 - ccache 166 hit / 6453 miss - head 2839ee0cb - digest sha256:d0c7d91065f73f... - run 30668409135 | ||||||
| tests failed | 1 | 20 | 1016 / 1017 | 2m 54s / 5m 15s | docker run ... @sha256:726175c... | Jul 30, 22:08 |
run 30585393271failed: recovery/051_effective_wal_level executed 1017 - ccache 166 hit / 6453 miss - head af3f510ae - digest sha256:726175c268b88d... - run 30585393271 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 53s / 5m 21s | docker run ... @sha256:9b2cf3d... | Jul 29, 22:08 |
run 30494304377executed 1017 - ccache 166 hit / 6453 miss - head 9edff79ec - digest sha256:9b2cf3d518a594... - run 30494304377 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 55s / 5m 19s | docker run ... @sha256:449df9b... | Jul 28, 22:07 |
run 30402596749executed 1016 - ccache 166 hit / 6453 miss - head 6e208ce51 - digest sha256:449df9b34206b4... - run 30402596749 | ||||||