planner weirdness: a join uses nestloop with checking condition when there are two subplan-or-hashed subqueries

back to CI dashboard

1 patchset tracked - current t69827_3

v3t69827_3posted May 22, 2020tests failedappliesrecent 0dpg 20
base9e17d25e7 about 12 hours ago on master
applyapplied about 6 hours ago
rebaselast tried about 6 hours ago on 9e17d25e7
pushabout 6 hours ago -> 98a116364branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed120948 / 9522m 47s / 5m 07sdocker run ... :t69827about 5 hours ago
run 35509539686
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 952 - ccache 98 hit / 6524 miss - head 98a116364 - digest sha256:cbd89320552663... - run 35509539686
tests failed120947 / 9511m 57s / 4m 18sdocker run ... @sha256:cc1d8c4...1 day ago
run 35441652253
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 951 - ccache 98 hit / 6524 miss - head 49df3668b - digest sha256:cc1d8c442ac3b1... - run 35441652253
tests failed120956 / 9602m 43s / 4m 34sdocker run ... @sha256:b3e4aa0...2 days ago
run 35342219739
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 960 - ccache 98 hit / 6524 miss - head 08b5b2ce0 - digest sha256:b3e4aa0faf2c1e... - run 35342219739
tests failed120949 / 9532m 14s / 4m 29sdocker run ... @sha256:26e4bf3...3 days ago
run 35218407695
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 953 - ccache 98 hit / 6524 miss - head 8da175869 - digest sha256:26e4bf3f959ffb... - run 35218407695
tests failed120944 / 9482m 52s / 5m 27sdocker run ... @sha256:39d348d...4 days ago
run 35092439817
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 948 - ccache 98 hit / 6524 miss - head dce32fef0 - digest sha256:39d348d2037d00... - run 35092439817
tests failed120942 / 9462m 54s / 5m 17sdocker run ... @sha256:c4e7b89...5 days ago
run 34964878145
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 946 - ccache 98 hit / 6523 miss - head e6d77c42f - digest sha256:c4e7b8931fb822... - run 34964878145
tests failed120931 / 9352m 58s / 5m 16sdocker run ... @sha256:587d9bc...6 days ago
run 34839367694
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 98 hit / 6523 miss - head b9159dbcd - digest sha256:587d9bc017acac... - run 34839367694
tests failed120937 / 9412m 48s / 4m 58sdocker run ... @sha256:487828a...Sep 13, 11:12
run 34753373248
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 941 - ccache 98 hit / 6523 miss - head c8a718340 - digest sha256:487828aefebb89... - run 34753373248
tests failed120935 / 9392m 51s / 5m 15sdocker run ... @sha256:d7e6e51...Sep 12, 11:02
run 34689472849
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 98 hit / 6523 miss - head 94ec15939 - digest sha256:d7e6e51a3c42cc... - run 34689472849
tests failed120935 / 9392m 56s / 5m 23sdocker run ... @sha256:63f2ff4...Sep 11, 11:03
run 34591010247
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 98 hit / 6523 miss - head 036b543e3 - digest sha256:63f2ff4a248ef3... - run 34591010247
tests failed120941 / 9452m 59s / 5m 23sdocker run ... @sha256:d108434...Sep 10, 11:02
run 34467828623
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 945 - ccache 98 hit / 6523 miss - head 7b599e53b - digest sha256:d108434b6f12b2... - run 34467828623
tests failed120931 / 9352m 39s / 4m 31sdocker run ... @sha256:c949360...Sep 09, 10:59
run 34341873436
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 98 hit / 6523 miss - head 7a6b24370 - digest sha256:c9493606d8dd9e... - run 34341873436
tests failed120931 / 9353m 05s / 5m 48sdocker run ... @sha256:c896f43...Sep 08, 10:56
run 34216977281
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 98 hit / 6523 miss - head dfb9dd19c - digest sha256:c896f43c78e338... - run 34216977281
tests failed120933 / 9372m 56s / 5m 29sdocker run ... @sha256:5debeea...Sep 07, 10:54
run 34112423101
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 937 - ccache 98 hit / 6527 miss - head 6b567a8ab - digest sha256:5debeea34aa0d9... - run 34112423101
tests failed120934 / 9381m 48s / 4m 22sdocker run ... @sha256:3d1a584...Sep 05, 12:39
run 33966219007
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 938 - ccache 98 hit / 6527 miss - head 7193a8d2b - digest sha256:3d1a584543c80b... - run 33966219007
tests failed120938 / 9422m 54s / 5m 30sdocker run ... @sha256:12e3d3b...Sep 04, 12:43
run 33872898165
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 942 - ccache 98 hit / 6527 miss - head 9b2cbfd8a - digest sha256:12e3d3b0c1d3e3... - run 33872898165
tests failed120934 / 9382m 50s / 5m 25sdocker run ... @sha256:989c984...Sep 03, 12:41
run 33755117557
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 938 - ccache 98 hit / 6526 miss - head 407bbcf59 - digest sha256:989c984ed588c0... - run 33755117557
tests failed120936 / 9402m 51s / 5m 06sdocker run ... @sha256:cf72859...Sep 02, 12:38
run 33629606275
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 940 - ccache 98 hit / 6526 miss - head 46214d730 - digest sha256:cf72859601a90c... - run 33629606275
tests failed120931 / 9352m 51s / 5m 17sdocker run ... @sha256:468b48a...Sep 01, 12:33
run 33507192054
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 98 hit / 6526 miss - head eb889ef18 - digest sha256:468b48ada03f21... - run 33507192054
tests failed120940 / 9442m 49s / 5m 07sdocker run ... @sha256:fc60c5c...Aug 31, 12:24
run 33390662558
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 944 - ccache 98 hit / 6526 miss - head 41f2273e3 - digest sha256:fc60c5c85323d6... - run 33390662558
tests failed120937 / 9412m 13s / 4m 26sdocker run ... @sha256:eb2b991...Aug 30, 12:21
run 33310849089
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 941 - ccache 98 hit / 6525 miss - head 0f6720a26 - digest sha256:eb2b99138dc71f... - run 33310849089
tests failed120941 / 9452m 56s / 5m 19sdocker run ... @sha256:767a372...Aug 29, 12:20
run 33251844920
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 945 - ccache 98 hit / 6525 miss - head a22b3ddc9 - digest sha256:767a372e470613... - run 33251844920
tests failed120930 / 9342m 14s / 4m 13sdocker run ... @sha256:00c1238...Aug 28, 12:17
run 33169921489
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 98 hit / 6525 miss - head f225c013f - digest sha256:00c12384712008... - run 33169921489
tests failed120930 / 9342m 49s / 5m 02sdocker run ... @sha256:e94f6d8...Aug 27, 12:17
run 33070399599
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 98 hit / 6525 miss - head e632b0409 - digest sha256:e94f6d82093d55... - run 33070399599
tests failed120944 / 9482m 53s / 5m 30sdocker run ... @sha256:b07b408...Aug 26, 12:08
run 32965859997
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 948 - ccache 98 hit / 6525 miss - head 2715fe7a9 - digest sha256:b07b4085eceb43... - run 32965859997
tests failed120939 / 9432m 10s / 4m 38sdocker run ... @sha256:3b86ca0...Aug 25, 11:54
run 32843907363
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 943 - ccache 98 hit / 6525 miss - head 88c882c21 - digest sha256:3b86ca0ebc65ec... - run 32843907363
tests failed120933 / 9372m 59s / 5m 02sdocker run ... @sha256:bfb97b4...Aug 24, 11:51
run 32723090168
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 937 - ccache 98 hit / 6525 miss - head 2429223c9 - digest sha256:bfb97b430743aa... - run 32723090168
tests failed120935 / 9392m 54s / 5m 09sdocker run ... @sha256:6c54a35...Aug 23, 11:51
run 32637190724
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 98 hit / 6525 miss - head 1a628e4e4 - digest sha256:6c54a35e06cc13... - run 32637190724
tests failed120933 / 9371m 51s / 4m 05sdocker run ... @sha256:cb4697c...Aug 22, 11:47
run 32570861733
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 937 - ccache 98 hit / 6525 miss - head 9465d95af - digest sha256:cb4697c488b4b9... - run 32570861733
tests failed120934 / 9382m 47s / 5m 11sdocker run ... @sha256:0ec7610...Aug 21, 11:48
run 32478053977
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 938 - ccache 98 hit / 6525 miss - head 993882dd4 - digest sha256:0ec76103939028... - run 32478053977
tests failed120935 / 9392m 46s / 5m 00sdocker run ... @sha256:cfe7359...Aug 20, 11:47
run 32364642531
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 98 hit / 6525 miss - head 188be3936 - digest sha256:cfe7359b9e44d8... - run 32364642531
tests failed120932 / 9362m 59s / 5m 29sdocker run ... @sha256:7f39570...Aug 19, 11:49
run 32248318474
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 936 - ccache 98 hit / 6525 miss - head 0cefd02b1 - digest sha256:7f39570374ddc8... - run 32248318474
tests failed120930 / 9342m 54s / 5m 18sdocker run ... @sha256:52f50a8...Aug 18, 11:34
run 32131402443
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 98 hit / 6524 miss - head a9cb227a6 - digest sha256:52f50a8c0ed225... - run 32131402443
tests failed120929 / 9332m 58s / 5m 14sdocker run ... @sha256:635decd...Aug 17, 11:32
run 32024485937
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 933 - ccache 98 hit / 6524 miss - head e6e0d2010 - digest sha256:635decd962bb8d... - run 32024485937
tests failed120938 / 9422m 49s / 5m 16sdocker run ... @sha256:b4587d8...Aug 16, 11:30
run 31944001809
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 942 - ccache 98 hit / 6524 miss - head 898716805 - digest sha256:b4587d8fc93cc6... - run 31944001809
tests failed120931 / 9352m 49s / 5m 25sdocker run ... @sha256:af23885...Aug 15, 11:29
run 31881708226
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 98 hit / 6524 miss - head 58895839b - digest sha256:af23885cd8ac5e... - run 31881708226
tests failed120935 / 9392m 58s / 5m 14sdocker run ... @sha256:2b7581d...Aug 14, 11:29
run 31795579500
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 165 hit / 6457 miss - head bd834a4b3 - digest sha256:2b7581d26bf57c... - run 31795579500
tests failed120931 / 9352m 56s / 5m 29sdocker run ... @sha256:94a4e0e...Aug 13, 11:27
run 31694672518
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 165 hit / 6457 miss - head c3a385cdd - digest sha256:94a4e0e938f276... - run 31694672518
tests failed120936 / 9402m 50s / 5m 15sdocker run ... @sha256:717e6f5...Aug 12, 11:25
run 31590851343
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 940 - ccache 165 hit / 6457 miss - head af25dd947 - digest sha256:717e6f562d6a0f... - run 31590851343
tests failed120930 / 9342m 15s / 4m 45sdocker run ... @sha256:d134e25...Aug 11, 11:23
run 31485600032
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 165 hit / 6453 miss - head e382840ef - digest sha256:d134e25d1e1282... - run 31485600032
tests failed120931 / 9352m 38s / 4m 30sdocker run ... @sha256:8ae7288...Aug 10, 11:12
run 31381699359
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 935 - ccache 166 hit / 6452 miss - head 7ae741414 - digest sha256:8ae72888a79f40... - run 31381699359
tests failed120930 / 9342m 58s / 5m 33sdocker run ... @sha256:5c94420...Aug 08, 13:30
run 31259241807
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 166 hit / 6452 miss - head 31711ba39 - digest sha256:5c9442017449e8... - run 31259241807
tests failed120929 / 9332m 58s / 5m 12sdocker run ... @sha256:6e56651...Aug 07, 13:28
run 31181779307
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 933 - ccache 166 hit / 6452 miss - head c80133393 - digest sha256:6e5665170cf5c2... - run 31181779307
tests failed120935 / 9392m 54s / 5m 20sdocker run ... @sha256:5a5f393...Aug 06, 13:27
run 31104976810
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 166 hit / 6452 miss - head 47887e87e - digest sha256:5a5f39349779de... - run 31104976810
tests failed120928 / 9322m 54s / 5m 16sdocker run ... @sha256:850478d...Aug 05, 13:24
run 31009083523
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 932 - ccache 166 hit / 6452 miss - head 11c87e0c8 - digest sha256:850478de1d6cab... - run 31009083523
tests failed120929 / 9332m 58s / 5m 23sdocker run ... @sha256:c5b271b...Aug 04, 13:24
run 30912450900
failed: test_plan_advice/001_replan_regress, regress/updatable_views, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 933 - ccache 166 hit / 6452 miss - head 7323ea0dd - digest sha256:c5b271b2bf2546... - run 30912450900
tests failed120927 / 9312m 46s / 5m 01sdocker run ... @sha256:b48ded0...Aug 03, 13:22
run 30816634235
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 931 - ccache 166 hit / 6452 miss - head 4a88cdfc9 - digest sha256:b48ded0978a25f... - run 30816634235
tests failed120928 / 9322m 55s / 5m 08sdocker run ... @sha256:a810e31...Aug 02, 13:20
run 30749318082
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 932 - ccache 166 hit / 6452 miss - head a4190477c - digest sha256:a810e3144e45ef... - run 30749318082
tests failed120930 / 9342m 50s / 5m 23sdocker run ... @sha256:2f210e2...Aug 01, 13:19
run 30701124354
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 934 - ccache 166 hit / 6452 miss - head 87c3979d3 - digest sha256:2f210e2442508a... - run 30701124354
tests failed120935 / 9392m 55s / 5m 18sdocker run ... @sha256:52cf082...Jul 31, 13:19
run 30633260538
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 939 - ccache 166 hit / 6452 miss - head c957a17c1 - digest sha256:52cf0827e570e1... - run 30633260538
tests failed120928 / 9322m 41s / 4m 34sdocker run ... @sha256:919ce63...Jul 30, 13:18
run 30545461475
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 932 - ccache 166 hit / 6452 miss - head e7e6bc7ed - digest sha256:919ce638c5313f... - run 30545461475
tests failed120925 / 9292m 55s / 5m 21sdocker run ... @sha256:13b37b6...Jul 29, 13:16
run 30454404421
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 929 - ccache 166 hit / 6452 miss - head 90633a0b9 - digest sha256:13b37b65a0dc93... - run 30454404421
tests failed120926 / 9302m 56s / 5m 13sdocker run ... @sha256:48d7848...Jul 28, 13:16
run 30361774247
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 930 - ccache 166 hit / 6452 miss - head 654b865c7 - digest sha256:48d784861d530d... - run 30361774247
tests failed120929 / 9332m 50s / 5m 05sdocker run ... @sha256:8f47f5f...Jul 27, 19:06
run 30295551225
failed: regress/updatable_views, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 933 - ccache 166 hit / 6452 miss - head 7f15485a8 - digest sha256:8f47f5fc222cfe... - run 30295551225