Erase the distinctClause if the result is unique by definition

Edit
Comment/Review
Change Status
ID 2433
Title Erase the distinctClause if the result is unique by definition
Topic Performance
Created 2020-01-31 12:42:25
Last modified 2022-04-05 03:43:58 (2 years, 7 months ago)
Latest email 2022-03-31 20:33:20 (2 years, 7 months ago)
Status
2022-03: Returned with feedback
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
Target version
Authors Andy Fan (andyf)
Reviewers David Rowley (davidrowley), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj), Dmitry Dolgov (erthalion)Become reviewer
Committer
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/2433
git checkout commitfest/cf/2433
Emails
[PATCH] Keeps tracking the uniqueness with UniqueKey
First at 2020-03-23 10:21:38 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest at 2021-02-11 02:05:07 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest attachment (v11-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-09-08 23:51:12 from Andy Fan <zhihui.fan1213 at gmail.com>
    Attachment (v11-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-09-08 23:51:12 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Introduce-UniqueKey-attributes-on-RelOptInfo-str.patch) at 2020-07-19 03:03:26 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v9-0005-Treat-the-input-as-sorted-if-the-group-by-clause-.patch) at 2020-06-29 09:59:21 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Remove-distinct-node-AggNode-if-the-input-is-uniq.patch) at 2020-05-13 11:59:08 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v7-0005-If-the-group-by-clause-is-unique-and-we-have-aggr.patch) at 2020-05-07 01:31:51 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Skip-DISTINCT-GROUP-BY-if-input-is-already-unique.patch) at 2020-04-16 02:17:00 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Introduce-UniqueKeys-to-determine-RelOptInfo-uniq.patch) at 2020-04-14 09:09:31 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Maintain-UniqueKey-at-each-RelOptInfo-this-inform.patch) at 2020-04-03 02:17:11 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: No)
    Attachment (v3-0001-Maintain-UniqueKey-at-each-RelOptInfo-this-inform.patch) at 2020-03-29 07:48:42 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-26 01:55:35 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-25 14:24:42 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Maintain-the-uniqueness-of-a-Query-from-bottom-to.patch) at 2020-03-23 10:21:38 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series)
First at 2021-02-10 03:18:47 by Andy Fan <zhihui.fan1213 at gmail.com>
Latest at 2022-03-31 20:33:20 by Greg Stark <stark at mit.edu>
Latest attachment (v4-0005-Support-UniqueKey-on-JoinRel.patch) at 2021-08-18 12:29:33 from Andy Fan <zhihui.fan1213 at gmail.com>
    Attachment (v4-0005-Support-UniqueKey-on-JoinRel.patch) at 2021-08-18 12:29:33 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Just-refactor-pathkeys_useful_for_merging-split-a.patch) at 2021-08-15 14:33:13 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-design-uniquekey-v2.patch) at 2021-07-07 09:00:05 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-add-the-not-null-attrs-for-RelOptInfo.-Here-is-ho.patch) at 2021-07-03 14:08:26 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-18 12:58:13 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-16 14:03:46 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch) at 2021-02-10 03:27:25 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
History
When Who What
2022-04-05 03:43:58 Greg Stark (stark) Closed in commitfest 2022-03 with status: Returned with feedback
2022-02-02 16:29:53 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-17 09:17:19 Dmitry Dolgov (erthalion) Added erthalion as reviewer
2021-12-02 11:14:03 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-06 13:16:01 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-01 13:29:21 Andy Fan (andyf) New status: Needs review
2021-09-01 13:29:01 Andy Fan (andyf) Detached mail thread CAKU4AWrU35c9g3cE15JmVwh6B2Hzf4hf7cZUkRsiktv7AKR3Ag@mail.gmail.com
2021-08-03 02:43:35 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-08-03 02:42:34 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:42:31 Masahiko Sawada (masahikosawada) New status: Needs review
2021-04-08 14:40:00 David Steele (dsteele) New status: Waiting on Author
2021-04-08 14:39:45 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-08 14:39:39 David Steele (dsteele) New status: Needs review
2021-03-04 15:58:38 Dmitry Dolgov (erthalion) Attached mail thread CAKU4AWrU35c9g3cE15JmVwh6B2Hzf4hf7cZUkRsiktv7AKR3Ag@mail.gmail.com
2021-03-04 15:57:52 Dmitry Dolgov (erthalion) Attached mail thread CAKU4AWpQjAqJwQ2X-aR9g3+ZHRzU1k8hNP7A+_mLuOv-n5aVKA@mail.gmail.com
2021-02-01 13:12:56 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-02-01 13:12:43 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-02-01 13:12:37 Masahiko Sawada (masahikosawada) New status: Needs review
2020-12-01 12:27:18 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2020-12-01 12:27:14 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 12:27:09 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2020-11-30 16:23:13 Heikki Linnakangas (heikki) New status: Waiting on Author
2020-10-12 02:38:17 Hou Zhijie (houzj) Added houzj as reviewer
2020-10-01 04:29:37 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-10 14:04:35 Andy Fan (andyf) New status: Needs review
2020-09-07 07:22:27 Michael Paquier (michael-kun) New status: Waiting on Author
2020-08-03 09:13:22 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 16:08:24 David Steele (dsteele) Changed targetversion to None
2020-04-08 15:31:38 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-04-03 05:51:04 Andy Fan (andyf) New status: Needs review
2020-03-31 01:44:48 David Rowley (davidrowley) New status: Waiting on Author
2020-03-26 01:52:16 Andy Fan (andyf) Detached mail thread CAKU4AWqZvSyxroHkbpiHSCEAY2C41dG7VWs=c188KKznSK_2Zg@mail.gmail.com
2020-03-25 01:34:49 Andy Fan (andyf) Changed targetversion to 13
2020-03-23 11:15:53 Andy Fan (andyf) New status: Needs review
2020-03-23 11:15:33 Andy Fan (andyf) Attached mail thread CAKU4AWrwZMAL=uaFUDMf4WGOVkEL3ONbatqju9nSXTUucpp_pw@mail.gmail.com
2020-03-10 14:01:43 Ashutosh Bapat (ashutoshbapat) Added ashutoshbapat as reviewer
2020-03-10 02:31:57 David Rowley (davidrowley) Added davidrowley as reviewer
2020-03-10 02:31:54 David Rowley (davidrowley) New status: Waiting on Author
2020-02-07 10:15:15 Julien Rouhaud (rjuju) Changed authors to Andy Fan (andyf)
2020-01-31 12:42:25 Andy Fan (andyf) Attached mail thread CAKU4AWqZvSyxroHkbpiHSCEAY2C41dG7VWs=c188KKznSK_2Zg@mail.gmail.com
2020-01-31 12:42:25 Andy Fan (andyf) Created patch record
Edit
Comment/Review
Change Status