Erase the distinctClause if the result is unique by definition

Edit
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 (1 year, 11 months ago)
Latest email 2022-03-31 20:33:20 (1 year, 12 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), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj)Become reviewer
Committer
Links
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