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, 11 months ago)

Latest email 2020-12-16 01:25:43 (3 years, 11 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