Erase the distinctClause if the result is unique by definition

Edit

Title

Topic

Performance

Created

2020-01-31 12:42:25

Last modified

2020-10-01 04:29:37 (2 weeks, 5 days ago)

Latest email

2020-10-12 02:33:17 (1 week, 1 day ago)

Status

2020-11: Needs review

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 zj (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 2020-10-12 02:33:17 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)

History

When	Who	What
2020-10-12 02:38:17	hou zj (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