Remove redundant DISTINCT when GROUP BY already guarantees uniqueness

back to CI dashboard

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
ResultAttPGTestsBuild / testImageWhen
tests failed120477 / 4862m 46s / 2m 33sdocker run ... :t139899Sep 08, 05:11
run 34189173039
failed: 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 failed120595 / 6051m 41s / 2m 18sdocker run ... @sha256:1243d04...Sep 07, 05:09
run 34085191807
failed: 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 failed120634 / 6452m 54s / 5m 20sdocker run ... @sha256:3c89f1a...Sep 05, 07:03
run 33950993382
failed: 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 failed120622 / 6323m 02s / 3m 15sdocker run ... @sha256:efa017a...Sep 04, 07:03
run 33846030753
failed: 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 failed120597 / 6072m 53s / 3m 06sdocker run ... @sha256:cdf8fa9...Sep 03, 06:59
run 33724956475
failed: 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 failed120615 / 6252m 51s / 3m 06sdocker run ... @sha256:d187354...Sep 02, 06:54
run 33600230125
failed: 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 failed120596 / 6062m 58s / 3m 13sdocker run ... @sha256:3d21b20...Sep 01, 06:57
run 33478733907
failed: 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 failed120588 / 5982m 56s / 3m 14sdocker run ... @sha256:3eaf6be...Aug 31, 06:34
run 33364071134
failed: 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 failed120588 / 5982m 37s / 2m 50sdocker run ... @sha256:402a6a4...Aug 30, 06:20
run 33296322063
failed: 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 failed120576 / 5862m 55s / 3m 10sdocker run ... @sha256:d117a44...Aug 29, 06:20
run 33237822376
failed: 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 failed120940 / 9442m 46s / 5m 14sdocker run ... @sha256:c4074c8...Aug 28, 06:16
run 33146795743
failed: 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 failed120940 / 9442m 54s / 5m 17sdocker run ... @sha256:18a5ea8...Aug 27, 06:15
run 33044624825
failed: 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 failed120934 / 9382m 49s / 5m 25sdocker run ... @sha256:242e309...Aug 26, 05:52
run 32935070549
failed: 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 failed120690 / 6932m 01s / 4m 28sdocker run ... @sha256:ecdd86e...Aug 25, 05:41
run 32813188027
failed: 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
success1201024 / 10242m 59s / 5m 33sdocker run ... @sha256:563b55a...Aug 24, 05:41
run 32693732899
executed 1024 - ccache 98 hit / 6526 miss - head dcd949473 - digest sha256:563b55a942a881... - run 32693732899
success1201024 / 10243m 01s / 5m 23sdocker run ... @sha256:375989b...Aug 23, 05:40
run 32620389208
executed 1024 - ccache 98 hit / 6526 miss - head 5a02d7d80 - digest sha256:375989b5b4f36f... - run 32620389208
success1201024 / 10242m 20s / 4m 10sdocker run ... @sha256:7ae585d...Aug 22, 05:35
run 32554334543
executed 1024 - ccache 98 hit / 6526 miss - head 17bb0f5bc - digest sha256:7ae585d1016c61... - run 32554334543
success1201024 / 10242m 48s / 5m 26sdocker run ... @sha256:eec9820...Aug 21, 05:36
run 32450440906
executed 1024 - ccache 98 hit / 6526 miss - head acc0299a5 - digest sha256:eec9820be38fd5... - run 32450440906
success1201024 / 10242m 16s / 4m 20sdocker run ... @sha256:fde2fa0...Aug 20, 05:32
run 32335421235
executed 1024 - ccache 98 hit / 6526 miss - head 67f8b8bf7 - digest sha256:fde2fa07a702ee... - run 32335421235
success1201024 / 10242m 54s / 5m 40sdocker run ... @sha256:264e437...Aug 19, 05:39
run 32219144449
executed 1024 - ccache 98 hit / 6526 miss - head 02de293f7 - digest sha256:264e43750ab445... - run 32219144449
success1201021 / 10212m 48s / 5m 07sdocker run ... @sha256:09011a2...Aug 18, 05:36
run 32102481256
executed 1021 - ccache 98 hit / 6525 miss - head 6be2b7f1c - digest sha256:09011a27353d34... - run 32102481256
success1201020 / 10202m 55s / 5m 30sdocker run ... @sha256:e956ef2...Aug 17, 05:36
run 31997411516
executed 1020 - ccache 98 hit / 6525 miss - head b16275430 - digest sha256:e956ef2e11f2f3... - run 31997411516
success1201020 / 10202m 57s / 5m 39sdocker run ... @sha256:920ea5c...Aug 16, 05:22
run 31928372381
executed 1020 - ccache 98 hit / 6525 miss - head ff820697b - digest sha256:920ea5c8279e41... - run 31928372381
success1201020 / 10202m 56s / 5m 33sdocker run ... @sha256:aac52a4...Aug 15, 05:21
run 31866219770
executed 1020 - ccache 98 hit / 6525 miss - head 5e3237369 - digest sha256:aac52a4ac1eb84... - run 31866219770
success1201020 / 10202m 54s / 5m 36sdocker run ... @sha256:833b32f...Aug 14, 05:19
run 31771963042
executed 1020 - ccache 165 hit / 6458 miss - head 6d5a28467 - digest sha256:833b32fd5ff101... - run 31771963042
success1201020 / 10202m 55s / 5m 30sdocker run ... @sha256:2f820a6...Aug 13, 05:16
run 31669059403
executed 1020 - ccache 165 hit / 6458 miss - head 8d05a0334 - digest sha256:2f820a66b41a38... - run 31669059403
success1201020 / 10202m 55s / 5m 13sdocker run ... @sha256:e2a4d0e...Aug 12, 05:15
run 31565275531
executed 1020 - ccache 165 hit / 6455 miss - head 6389d3c7f - digest sha256:e2a4d0e40e3fb2... - run 31565275531
success1201020 / 10202m 51s / 5m 27sdocker run ... @sha256:362216d...Aug 11, 05:13
run 31460364813
executed 1020 - ccache 165 hit / 6454 miss - head 1f06c3a12 - digest sha256:362216d4efb3b5... - run 31460364813
success1201020 / 10202m 47s / 5m 31sdocker run ... @sha256:c45f1c0...Aug 10, 05:19
run 31357193376
executed 1020 - ccache 166 hit / 6453 miss - head 87262e4d4 - digest sha256:c45f1c086b1306... - run 31357193376
success1201020 / 10202m 53s / 5m 19sdocker run ... @sha256:96c484d...Aug 08, 03:51
run 31237690648
executed 1020 - ccache 166 hit / 6453 miss - head 079eaad65 - digest sha256:96c484d96d3e96... - run 31237690648
success1201019 / 10192m 37s / 4m 07sdocker run ... @sha256:b367292...Aug 07, 03:49
run 31144935842
executed 1019 - ccache 166 hit / 6453 miss - head 6212d7aa9 - digest sha256:b367292ebe3c8a... - run 31144935842
success1201019 / 10192m 56s / 5m 24sdocker run ... @sha256:0630b93...Aug 05, 22:13
run 31051200468
executed 1019 - ccache 166 hit / 6453 miss - head c9e0f9f5f - digest sha256:0630b93bd688d5... - run 31051200468
success1201019 / 10192m 57s / 5m 36sdocker run ... @sha256:431fdbf...Aug 04, 22:13
run 30954824151
executed 1019 - ccache 166 hit / 6453 miss - head 4bc8e20aa - digest sha256:431fdbf1307f6c... - run 30954824151
success1201019 / 10192m 47s / 5m 01sdocker run ... @sha256:76da564...Aug 03, 22:11
run 30857044369
executed 1019 - ccache 166 hit / 6453 miss - head ef39d4ced - digest sha256:76da564da301f8... - run 30857044369
success1201018 / 10182m 56s / 5m 17sdocker run ... @sha256:e052a5d...Aug 02, 22:11
run 30769144974
executed 1018 - ccache 166 hit / 6453 miss - head 8865ae3e2 - digest sha256:e052a5d41c6db1... - run 30769144974
success1201018 / 10181m 51s / 3m 50sdocker run ... @sha256:19d3576...Aug 01, 22:07
run 30720317267
executed 1018 - ccache 166 hit / 6453 miss - head a06f0c20d - digest sha256:19d357685df1d5... - run 30720317267
success1201018 / 10182m 54s / 5m 25sdocker run ... @sha256:d0c7d91...Jul 31, 22:09
run 30668409135
executed 1018 - ccache 166 hit / 6453 miss - head 2839ee0cb - digest sha256:d0c7d91065f73f... - run 30668409135
tests failed1201016 / 10172m 54s / 5m 15sdocker run ... @sha256:726175c...Jul 30, 22:08
run 30585393271
failed: recovery/051_effective_wal_level
executed 1017 - ccache 166 hit / 6453 miss - head af3f510ae - digest sha256:726175c268b88d... - run 30585393271
success1201017 / 10172m 53s / 5m 21sdocker run ... @sha256:9b2cf3d...Jul 29, 22:08
run 30494304377
executed 1017 - ccache 166 hit / 6453 miss - head 9edff79ec - digest sha256:9b2cf3d518a594... - run 30494304377
success1201016 / 10162m 55s / 5m 19sdocker run ... @sha256:449df9b...Jul 28, 22:07
run 30402596749
executed 1016 - ccache 166 hit / 6453 miss - head 6e208ce51 - digest sha256:449df9b34206b4... - run 30402596749