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
Topic Bug Fixes
Created 2020-10-06 13:36:25
Last modified 2020-12-22 01:06:58 (3 years, 9 months ago)
Latest email 2020-12-16 01:25:43 (3 years, 10 months ago)
Status
2021-01: Committed
2020-11: Moved to next CF
Target version 13
Authors James Coleman (jcole1989)
Reviewers Tomas Vondra (fuzzycz), Jaime Casanova (jcasanov)Become reviewer
Committer Tomas Vondra (fuzzycz)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2754
git checkout commitfest/cf/2754
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