BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables

back to CI dashboard

1 patchset tracked - current t73522_34

v34t73522_34posted May 25, 19:26successwon't retrystale 3mopg 20
base4d5fdb21d Aug 28, 13:36 on master
applyapplied Aug 28, 14:18
rebaselast tried Sep 26, 20:15 on 3c5d9d914
Applying: Deduplicate RestrictInfos differing only in outer_relids in SJE
Using index info to reconstruct a base tree...
M	src/backend/optimizer/plan/analyzejoins.c
M	src/include/nodes/pathnodes.h
M	src/test/regress/expected/join.out
M	src/test/regress/sql/join.sql
Falling back to patching base and 3-way merge...
Auto-merging src/test/regress/sql/join.sql
CONFLICT (content): Merge conflict in src/test/regress/sql/join.sql
Auto-merging src/test/regress/expected/join.out
CONFLICT (content): Merge conflict in src/test/regress/expected/join.out
Auto-merging src/include/nodes/pathnodes.h
Auto-merging src/backend/optimizer/plan/analyzejoins.c
CONFLICT (content): Merge conflict in src/backend/optimizer/plan/analyzejoins.c
Patch failed at 0001 Deduplicate RestrictInfos differing only in outer_relids in SJE

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/test/regress/sql/join.sql, src/test/regress/expected/join.out, src/backend/optimizer/plan/analyzejoins.c
pushAug 28, 14:18 -> 5a802f444branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201021 / 10212m 57s / 5m 17sdocker run ... :t73522Aug 28, 14:29
run 33179529777
executed 1021 - ccache 98 hit / 6525 miss - head 5a802f444 - digest sha256:634c452419430e... - run 33179529777
success1201021 / 10212m 57s / 5m 40sdocker run ... @sha256:572cb89...Aug 27, 14:27
run 33081218526
executed 1021 - ccache 98 hit / 6525 miss - head 6093724c4 - digest sha256:572cb890d6d71e... - run 33081218526
success1201024 / 10241m 47s / 4m 21sdocker run ... @sha256:c853360...Aug 26, 14:16
run 32978129276
executed 1024 - ccache 98 hit / 6525 miss - head 3be7ef822 - digest sha256:c853360dd207b2... - run 32978129276
success1201024 / 10242m 50s / 5m 13sdocker run ... @sha256:b75bf6b...Aug 25, 14:08
run 32856369007
executed 1024 - ccache 98 hit / 6525 miss - head ea7f77b51 - digest sha256:b75bf6bcd62da2... - run 32856369007
success1201023 / 10232m 48s / 5m 27sdocker run ... @sha256:c2f1d85...Aug 24, 14:06
run 32735541193
executed 1023 - ccache 98 hit / 6525 miss - head e54933e74 - digest sha256:c2f1d85625f730... - run 32735541193
success1201023 / 10232m 55s / 5m 35sdocker run ... @sha256:426b49b...Aug 23, 14:06
run 32643800870
executed 1023 - ccache 98 hit / 6525 miss - head de63db001 - digest sha256:426b49b963e7c0... - run 32643800870
success1201023 / 10233m 01s / 5m 51sdocker run ... @sha256:6750228...Aug 22, 14:04
run 32577080015
executed 1023 - ccache 98 hit / 6525 miss - head 1ad767c3d - digest sha256:6750228b02bd07... - run 32577080015
success1201023 / 10232m 50s / 5m 12sdocker run ... @sha256:8c32ee2...Aug 21, 14:02
run 32489097689
executed 1023 - ccache 98 hit / 6525 miss - head 547dba89b - digest sha256:8c32ee2cdb7828... - run 32489097689
success1201023 / 10232m 55s / 4m 56sdocker run ... @sha256:59aea24...Aug 20, 14:01
run 32376552055
executed 1023 - ccache 98 hit / 6525 miss - head c8882ee57 - digest sha256:59aea24dbe80e5... - run 32376552055
success1201023 / 10232m 15s / 4m 06sdocker run ... @sha256:b824b5d...Aug 19, 14:04
run 32260322689
executed 1023 - ccache 98 hit / 6525 miss - head 29970119c - digest sha256:b824b5d76ee5c5... - run 32260322689
success1201021 / 10212m 49s / 5m 17sdocker run ... @sha256:e63fcfe...Aug 18, 14:01
run 32143886341
executed 1021 - ccache 98 hit / 6525 miss - head 734d2e5a3 - digest sha256:e63fcfe3b19306... - run 32143886341