Fix broken query with gather merge paths added in incremental sort patch

Edit
ID 2754
Title Fix broken query with gather merge paths added in incremental sort patch
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2020-10-06 13:36:25
Last modified 2020-12-22 01:06:58 (4 years ago)
Latest email 2020-12-16 01:25:43 (4 years ago)
Status
2021-01 (2021-01-01 – 2021-01-31): Committed
2020-11 (2020-11-01 – 2020-11-30): Moved to different CF
Target version 13
Authors James Coleman (jcole1989)
Reviewers Tomas Vondra (fuzzycz), Jaime Casanova (jcasanov)Become reviewer
Committer Tomas Vondra (fuzzycz)
Links
Emails
enable_incremental_sort changes query behavior
First at 2020-09-26 18:49:13 by Jaime Casanova <jaime.casanova at 2ndquadrant.com>
Latest at 2020-12-16 01:25:43 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest attachment (explain_verbose.txt) at 2020-11-20 18:51:09 from James Coleman <jtc331 at gmail.com>
    Attachment (explain_verbose.txt) at 2020-11-20 18:51:09 from James Coleman <jtc331 at gmail.com> (Patch: No)
    Attachment (incremental-sort-fix-parallel-safe.patch) at 2020-11-17 04:23:46 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v7-0001-Fix-get_useful_pathkeys_for_relation-for-volatile-ex.patch) at 2020-11-03 02:37:43 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (v6-0003-questions.patch) at 2020-10-30 23:37:33 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Fix-get_useful_pathkeys_for_relation-for-volatile.patch) at 2020-10-29 22:06:52 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (v4-0002-questions.patch) at 2020-10-06 11:45:49 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v3-0002-questions.patch) at 2020-10-06 02:38:08 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-get_useful_pathkeys_for_relation-for-volatile.patch) at 2020-10-04 02:10:52 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (gdb.txt) at 2020-10-03 14:54:36 from Jaime Casanova <jaime.casanova at 2ndquadrant.com> (Patch: No)
    Attachment (v1-0001-Fix-get_useful_pathkeys_for_relation-for-volatile.patch) at 2020-10-03 14:50:06 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (incremental_sort_fix_expr_lookup_idea.patch) at 2020-10-03 03:16:15 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (failure.sql) at 2020-10-02 20:56:20 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (incremental-sort-fix.patch) at 2020-10-02 14:32:07 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (query_plan.txt.txt) at 2020-09-26 18:49:13 from Jaime Casanova <jaime.casanova at 2ndquadrant.com> (Patch: No)
History
When Who What
2020-12-22 01:06:58 Tomas Vondra (fuzzycz) Closed in commitfest 2021-01 with status: Committed
2020-12-22 01:06:58 Tomas Vondra (fuzzycz) Changed committer to fuzzycz
2020-11-30 15:30:28 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-06 13:37:00 James Coleman (jcole1989) Changed reviewers to Tomas Vondra (fuzzycz), Jaime Casanova (jcasanov)
2020-10-06 13:37:00 James Coleman (jcole1989) Changed authors to James Coleman (jcole1989)
2020-10-06 13:37:00 James Coleman (jcole1989) Changed targetversion to 13
2020-10-06 13:36:25 James Coleman (jcole1989) Attached mail thread CAJGNTeNaxpXgBVcRhJX+2vSbq+F2kJqGBcvompmpvXb7pq+oFA@mail.gmail.com
2020-10-06 13:36:25 James Coleman (jcole1989) Created patch record
Edit