Make the planner treat empty jointrees as selecting from a new dummy RTE type

Title

Topic

Performance

Created

2018-10-14 22:11:23

Last modified

2019-01-28 22:54:49 (5 years, 10 months ago)

Latest email

2019-01-28 23:04:29 (5 years, 10 months ago)

Status

2019-01: Committed

2018-11: Moved to next CF

Target version

Authors

Tom Lane (tgl)

Reviewers

David Rowley (davidrowley), Mark Dilger (hornschnorter)Become reviewer

Committer

Tom Lane (tgl)

Links

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/1827
git checkout commitfest/cf/1827

Emails

"SELECT ... FROM DUAL" is not quite as silly as it appears: First at 2018-03-15 15:27:44 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2019-01-28 23:04:29 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (get-rid-of-empty-jointrees-6.patch) at 2019-01-14 20:48:32 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (get-rid-of-empty-jointrees-6.patch) at 2019-01-14 20:48:32 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (get-rid-of-empty-jointrees-5.patch) at 2019-01-04 19:48:57 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (get-rid-of-empty-jointrees-4.patch) at 2018-11-29 19:11:09 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (get-rid-of-empty-jointrees-2.patch) at 2018-10-15 03:25:09 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (get-rid-of-empty-jointrees-1.patch) at 2018-10-14 22:04:12 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2019-01-28 22:54:49	Tom Lane (tgl)	Closed in commitfest 2019-01 with status: Committed
2019-01-28 22:54:49	Tom Lane (tgl)	Changed committer to tgl
2019-01-06 03:18:25	David Rowley (davidrowley)	Added davidrowley as reviewer
2018-12-01 13:20:48	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-28 16:55:21	Mark Dilger (hornschnorter)	Posted review with messageid <154342412161.2094.14859341952034622342.pgcf@coridan.postgresql.org>
2018-11-28 16:52:31	Mark Dilger (hornschnorter)	Posted review with messageid <154342395130.2093.8013327151440360209.pgcf@coridan.postgresql.org>
2018-11-28 16:27:57	Mark Dilger (hornschnorter)	Added hornschnorter as reviewer
2018-11-28 04:15:13	Mark Dilger (hornschnorter)	Removed hornschnorter from reviewers
2018-11-27 20:15:15	Mark Dilger (hornschnorter)	Added hornschnorter as reviewer
2018-10-14 22:11:41	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2018-10-14 22:11:23	Tom Lane (tgl)	Attached mail thread 15944.1521127664@sss.pgh.pa.us
2018-10-14 22:11:23	Tom Lane (tgl)	Created patch record