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

2754

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2020-10-06 13:36:25

Last modified

2020-12-22 01:06:58 (4 years, 2 months ago)

Latest email

2020-12-16 01:25:43 (4 years, 2 months ago)

Status

2021-01: Committed

2020-11: Moved to next CF

Target version

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