BUG #17335: Duplicate result rows in Gather node when "Suppress Append ... that have a single child" applied

1 patchset tracked - current t71121_3

v3t71121_3posted Dec 20, 2021successappliesrecent 0dpg 20

based39fda1cc about 1 hour ago on master

applyapplied 44 minutes ago

rebaselast tried 44 minutes ago on d39fda1cc

push44 minutes ago -> d06c80753 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1036 / 1036	2m 58s / 5m 23s	`docker run ... :t71121`	33 minutes ago
run 35593595474 executed 1036 - ccache 98 hit / 6524 miss - head d06c80753 - digest sha256:d06e56ece6f7cf... - run 35593595474
success	1	20	1036 / 1036	2m 51s / 5m 09s	`docker run ... @sha256:c60c368...`	1 day ago
run 35492650400 executed 1036 - ccache 98 hit / 6524 miss - head cb19e63ab - digest sha256:c60c368db7800f... - run 35492650400
success	1	20	1036 / 1036	2m 53s / 5m 14s	`docker run ... @sha256:4ccf25d...`	2 days ago
run 35424898692 executed 1036 - ccache 98 hit / 6524 miss - head 16264fbd4 - digest sha256:4ccf25d39a05b0... - run 35424898692
success	1	20	1036 / 1036	1m 54s / 4m 24s	`docker run ... @sha256:f5009bf...`	3 days ago
run 35312069348 executed 1036 - ccache 98 hit / 6524 miss - head eb6596eff - digest sha256:f5009bf0073f51... - run 35312069348
success	1	20	1036 / 1036	2m 55s / 5m 21s	`docker run ... @sha256:725e88c...`	4 days ago
run 35186863774 executed 1036 - ccache 98 hit / 6524 miss - head edfea0fa9 - digest sha256:725e88cdadc181... - run 35186863774
success	1	20	1036 / 1036	2m 10s / 4m 46s	`docker run ... @sha256:b5435a7...`	5 days ago
run 35060544815 executed 1036 - ccache 98 hit / 6524 miss - head 00edcd747 - digest sha256:b5435a74126f55... - run 35060544815
success	1	20	1036 / 1036	2m 16s / 4m 24s	`docker run ... @sha256:41eab09...`	6 days ago
run 34933609472 executed 1036 - ccache 98 hit / 6523 miss - head fffdd8ce4 - digest sha256:41eab09272abb4... - run 34933609472
success	1	20	1023 / 1023	2m 57s / 5m 34s	`docker run ... @sha256:5cbeb9f...`	Sep 14, 05:49
run 34810355336 executed 1023 - ccache 98 hit / 6523 miss - head 3bcd3f160 - digest sha256:5cbeb9fdcd8807... - run 34810355336
success	1	20	1023 / 1023	2m 52s / 5m 31s	`docker run ... @sha256:38e615f...`	Sep 13, 05:32
run 34740050516 executed 1023 - ccache 98 hit / 6523 miss - head d042341ed - digest sha256:38e615f4b7bcc8... - run 34740050516
success	1	20	1023 / 1023	1m 50s / 3m 58s	`docker run ... @sha256:6110d90...`	Sep 12, 05:10
run 34674511057 executed 1023 - ccache 98 hit / 6523 miss - head 54e8b1bb3 - digest sha256:6110d90c6d8cf2... - run 34674511057
success	1	20	1022 / 1022	2m 53s / 5m 28s	`docker run ... @sha256:f1d88b3...`	Sep 11, 05:10
run 34564250506 executed 1022 - ccache 98 hit / 6523 miss - head 88b4db863 - digest sha256:f1d88b3b82fe65... - run 34564250506
success	1	20	1022 / 1022	2m 54s / 4m 52s	`docker run ... @sha256:ce42549...`	Sep 10, 05:07
run 34439152276 executed 1022 - ccache 98 hit / 6523 miss - head 99c907523 - digest sha256:ce425495a567ff... - run 34439152276
success	1	20	1020 / 1020	3m 02s / 5m 41s	`docker run ... @sha256:672b6b3...`	Sep 09, 05:05
run 34312781650 executed 1020 - ccache 98 hit / 6523 miss - head cdc8a3a43 - digest sha256:672b6b34b3ec35... - run 34312781650
success	1	20	1020 / 1020	2m 24s / 4m 09s	`docker run ... @sha256:87f84ec...`	Sep 08, 04:59
run 34188397893 executed 1020 - ccache 98 hit / 6523 miss - head 2bb0d7d46 - digest sha256:87f84ec15bf690... - run 34188397893
success	1	20	1024 / 1024	2m 52s / 5m 32s	`docker run ... @sha256:74fbd30...`	Sep 07, 04:58
run 34084422110 executed 1024 - ccache 98 hit / 6527 miss - head 420ab5e3a - digest sha256:74fbd30fef69fd... - run 34084422110
success	1	20	1024 / 1024	2m 59s / 5m 25s	`docker run ... @sha256:4489ca9...`	Sep 05, 06:49
run 33950387308 executed 1024 - ccache 98 hit / 6527 miss - head d6782123f - digest sha256:4489ca96d097d8... - run 33950387308
success	1	20	1024 / 1024	2m 47s / 5m 08s	`docker run ... @sha256:c623bc7...`	Sep 04, 06:47
run 33845066732 executed 1024 - ccache 98 hit / 6527 miss - head fa37c1bb0 - digest sha256:c623bc774ea8ca... - run 33845066732
success	1	20	1023 / 1023	1m 49s / 4m 00s	`docker run ... @sha256:5f30cdd...`	Sep 03, 06:46
run 33723882321 executed 1023 - ccache 98 hit / 6526 miss - head b4de14687 - digest sha256:5f30cddeb01926... - run 33723882321
success	1	20	1022 / 1022	2m 47s / 4m 48s	`docker run ... @sha256:bb195ff...`	Sep 02, 06:41
run 33599182655 executed 1022 - ccache 98 hit / 6526 miss - head c466e2175 - digest sha256:bb195ff5a69af2... - run 33599182655
success	1	20	1022 / 1022	2m 55s / 5m 02s	`docker run ... @sha256:a07eaa4...`	Sep 01, 06:40
run 33477847998 executed 1022 - ccache 98 hit / 6526 miss - head 6738c86fe - digest sha256:a07eaa48d0ae0b... - run 33477847998
success	1	20	1022 / 1022	2m 53s / 5m 17s	`docker run ... @sha256:0fbf4d4...`	Aug 31, 06:20
run 33363126407 executed 1022 - ccache 98 hit / 6526 miss - head c0d29c9d3 - digest sha256:0fbf4d4e692a25... - run 33363126407
success	1	20	1021 / 1021	2m 46s / 4m 47s	`docker run ... @sha256:1dee3cb...`	Aug 30, 06:07
run 33295809390 executed 1021 - ccache 98 hit / 6525 miss - head 877e6f885 - digest sha256:1dee3cbafe6286... - run 33295809390
success	1	20	1021 / 1021	2m 52s / 5m 18s	`docker run ... @sha256:4fddf03...`	Aug 29, 06:07
run 33237303484 executed 1021 - ccache 98 hit / 6525 miss - head 331e68570 - digest sha256:4fddf0380391ba... - run 33237303484
success	1	20	1021 / 1021	2m 20s / 4m 13s	`docker run ... @sha256:75c2726...`	Aug 28, 05:59
run 33145976221 executed 1021 - ccache 98 hit / 6525 miss - head 3f7a2e576 - digest sha256:75c27260cc1194... - run 33145976221
success	1	20	1021 / 1021	2m 48s / 5m 05s	`docker run ... @sha256:84c800d...`	Aug 27, 05:58
run 33043684083 executed 1021 - ccache 98 hit / 6525 miss - head e8fc6bfd6 - digest sha256:84c800dfe91a20... - run 33043684083
success	1	20	1024 / 1024	2m 40s / 4m 56s	`docker run ... @sha256:6794ad2...`	Aug 26, 05:38
run 32933951735 executed 1024 - ccache 98 hit / 6525 miss - head 1713a209c - digest sha256:6794ad21d3f470... - run 32933951735
success	1	20	1024 / 1024	2m 53s / 5m 28s	`docker run ... @sha256:d8f1c32...`	Aug 25, 05:27
run 32812170138 executed 1024 - ccache 98 hit / 6525 miss - head a6f99a5a6 - digest sha256:d8f1c328203c49... - run 32812170138
success	1	20	1023 / 1023	2m 56s / 5m 20s	`docker run ... @sha256:e25cba3...`	Aug 24, 05:26
run 32692860242 executed 1023 - ccache 98 hit / 6525 miss - head 7516cd9d3 - digest sha256:e25cba39e3178d... - run 32692860242
success	1	20	1023 / 1023	2m 54s / 5m 09s	`docker run ... @sha256:de5fa54...`	Aug 23, 05:24
run 32619830889 executed 1023 - ccache 98 hit / 6525 miss - head 013aba824 - digest sha256:de5fa54f3b1653... - run 32619830889
success	1	20	1023 / 1023	2m 09s / 4m 48s	`docker run ... @sha256:9e71ae6...`	Aug 22, 05:22
run 32553736630 executed 1023 - ccache 98 hit / 6525 miss - head 6c9a16584 - digest sha256:9e71ae66b5bfb4... - run 32553736630
success	1	20	1023 / 1023	2m 10s / 4m 40s	`docker run ... @sha256:b89a95f...`	Aug 21, 05:20
run 32449588984 executed 1023 - ccache 98 hit / 6525 miss - head d4d652ea6 - digest sha256:b89a95f1ea17f3... - run 32449588984
success	1	20	1023 / 1023	2m 54s / 5m 34s	`docker run ... @sha256:7de9395...`	Aug 20, 05:20
run 32334491580 executed 1023 - ccache 98 hit / 6525 miss - head 64d283208 - digest sha256:7de9395a8e8437... - run 32334491580
success	1	20	1023 / 1023	2m 50s / 5m 14s	`docker run ... @sha256:930733b...`	Aug 19, 05:18
run 32218224998 executed 1023 - ccache 98 hit / 6525 miss - head a8a422a3e - digest sha256:930733b3d4bc93... - run 32218224998
success	1	20	1020 / 1020	1m 56s / 4m 14s	`docker run ... @sha256:60ccf83...`	Aug 18, 05:15
run 32101532081 executed 1020 - ccache 98 hit / 6524 miss - head f5cbb4f17 - digest sha256:60ccf8352945d0... - run 32101532081
success	1	20	1019 / 1019	2m 47s / 5m 27s	`docker run ... @sha256:ef2a9c0...`	Aug 17, 05:14
run 31996537334 executed 1019 - ccache 98 hit / 6524 miss - head aba0daeb9 - digest sha256:ef2a9c0de7ab03... - run 31996537334
success	1	20	1019 / 1019	2m 47s / 5m 14s	`docker run ... @sha256:397cd9c...`	Aug 16, 05:04
run 31927732029 executed 1019 - ccache 98 hit / 6524 miss - head 1f008f58b - digest sha256:397cd9c558aa85... - run 31927732029
success	1	20	1019 / 1019	2m 17s / 4m 33s	`docker run ... @sha256:832aaff...`	Aug 15, 05:03
run 31865539124 executed 1019 - ccache 98 hit / 6524 miss - head 537af8089 - digest sha256:832aaff9085e16... - run 31865539124
success	1	20	1019 / 1019	2m 54s / 5m 27s	`docker run ... @sha256:c23dd69...`	Aug 14, 05:03
run 31771175490 executed 1019 - ccache 165 hit / 6457 miss - head e674de2ef - digest sha256:c23dd6913398c7... - run 31771175490
success	1	20	1019 / 1019	2m 53s / 4m 53s	`docker run ... @sha256:fcfa989...`	Aug 13, 05:01
run 31668259368 executed 1019 - ccache 165 hit / 6457 miss - head b08ab4f44 - digest sha256:fcfa9891a98765... - run 31668259368
success	1	20	1019 / 1019	2m 46s / 5m 03s	`docker run ... @sha256:33cbf29...`	Aug 12, 04:58
run 31564399462 executed 1019 - ccache 165 hit / 6454 miss - head c7d156a11 - digest sha256:33cbf29adebcb6... - run 31564399462
success	1	20	1019 / 1019	2m 47s / 5m 22s	`docker run ... @sha256:85850c7...`	Aug 11, 04:57
run 31459496865 executed 1019 - ccache 165 hit / 6453 miss - head 659a64ec5 - digest sha256:85850c7f2454eb... - run 31459496865
success	1	20	1019 / 1019	2m 55s / 5m 30s	`docker run ... @sha256:bac54de...`	Aug 10, 04:55
run 31356404659 executed 1019 - ccache 166 hit / 6452 miss - head 13b0505ba - digest sha256:bac54de1d47ff1... - run 31356404659
success	1	20	1019 / 1019	2m 58s / 5m 35s	`docker run ... @sha256:7abb791...`	Aug 08, 03:37
run 31236877514 executed 1019 - ccache 166 hit / 6452 miss - head df8f6895a - digest sha256:7abb79130dc998... - run 31236877514
success	1	20	1018 / 1018	2m 52s / 5m 08s	`docker run ... @sha256:5ef368e...`	Aug 07, 03:35
run 31143832580 executed 1018 - ccache 166 hit / 6452 miss - head cc7790944 - digest sha256:5ef368e67cdebd... - run 31143832580
success	1	20	1018 / 1018	2m 55s / 5m 26s	`docker run ... @sha256:afe6109...`	Aug 05, 21:38
run 31048683893 executed 1018 - ccache 166 hit / 6452 miss - head 91c082f79 - digest sha256:afe6109ec7e47f... - run 31048683893
success	1	20	1018 / 1018	2m 48s / 5m 55s	`docker run ... @sha256:c2e4f2e...`	Aug 04, 21:37
run 30952198558 executed 1018 - ccache 166 hit / 6452 miss - head 1e58982c4 - digest sha256:c2e4f2eeeeb94d... - run 30952198558
success	1	20	1018 / 1018	2m 51s / 4m 42s	`docker run ... @sha256:187cc44...`	Aug 03, 21:34
run 30854280249 executed 1018 - ccache 166 hit / 6452 miss - head 2371f3d44 - digest sha256:187cc442718712... - run 30854280249
success	1	20	1017 / 1017	2m 47s / 5m 07s	`docker run ... @sha256:860db56...`	Aug 02, 21:32
run 30767653942 executed 1017 - ccache 166 hit / 6452 miss - head 81cb83454 - digest sha256:860db563b8d67e... - run 30767653942
success	1	20	1017 / 1017	2m 12s / 4m 44s	`docker run ... @sha256:0a4eeb5...`	Aug 01, 21:27
run 30718814543 executed 1017 - ccache 166 hit / 6452 miss - head fc5abf8a8 - digest sha256:0a4eeb5330015e... - run 30718814543
success	1	20	1017 / 1017	2m 59s / 5m 34s	`docker run ... @sha256:4e318c9...`	Jul 31, 21:30
run 30665963249 executed 1017 - ccache 166 hit / 6452 miss - head 2a888d1ac - digest sha256:4e318c9dd13be2... - run 30665963249
tests failed	1	20	1015 / 1016	2m 50s / 4m 45s	`docker run ... @sha256:f009738...`	Jul 30, 21:26
run 30582607634 failed: recovery/051_effective_wal_level executed 1016 - ccache 166 hit / 6452 miss - head c84791bc1 - digest sha256:f0097389e4b83f... - run 30582607634
success	1	20	1016 / 1016	2m 58s / 5m 33s	`docker run ... @sha256:aaa4860...`	Jul 29, 21:24
run 30491472200 executed 1016 - ccache 166 hit / 6452 miss - head 2a320e9f6 - digest sha256:aaa486032c8987... - run 30491472200
success	1	20	1015 / 1015	2m 49s / 5m 35s	`docker run ... @sha256:e2344be...`	Jul 28, 21:26
run 30399598221 executed 1015 - ccache 166 hit / 6452 miss - head ed7d87a95 - digest sha256:e2344bee50f551... - run 30399598221
success	1	20	1013 / 1013	2m 59s / 5m 26s	`docker run ... @sha256:e8d75e7...`	Jul 27, 15:51
run 30280740557 executed 1013 - ccache 166 hit / 6452 miss - head 9df064ff2 - digest sha256:e8d75e754f66b5... - run 30280740557