Empty targetlist in a plan for certain inherited updates causes user-facing errors

Title

Topic

Bug Fixes

Created

2019-02-13 04:03:55

Last modified

2019-02-22 17:27:31 (5 years, 9 months ago)

Latest email

2019-02-22 17:55:32 (5 years, 9 months ago)

Status

2019-03: Committed

Target version

stable

Authors

Amit Langote (amitlan)

Reviewers

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

Emails

'update returning *' returns 0 columns instead of empty row with 2 columns when (i) no rows updated and (ii) when applied to a partitioned table with sub-partition: First at 2019-02-01 14:32:43 by Petr Fedorov <petr.fedorov at phystech.edu>
Latest at 2019-02-22 17:55:32 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (fix-empty-plan-with-RETURNING-3.patch) at 2019-02-22 05:33:55 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
    Attachment (fix-empty-plan-with-RETURNING-3.patch) at 2019-02-22 05:33:55 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (fix-empty-plan-with-RETURNING-2.patch) at 2019-02-21 22:18:10 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (inheritance_planner-empty-Result-set-tlist.patch) at 2019-02-06 07:35:09 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)

History

When	Who	What
2019-02-22 17:27:31	Tom Lane (tgl)	Closed in commitfest 2019-03 with status: Committed
2019-02-22 17:27:31	Tom Lane (tgl)	Changed committer to tgl
2019-02-21 21:46:01	Tom Lane (tgl)	Added tgl as reviewer
2019-02-13 04:04:56	Amit Langote (amitlan)	Changed targetversion to stable
2019-02-13 04:04:08	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan)
2019-02-13 04:03:55	Amit Langote (amitlan)	Attached mail thread 5da6f0f0-1364-1876-6978-907678f89a3e@phystech.edu
2019-02-13 04:03:55	Amit Langote (amitlan)	Created patch record