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

Edit
ID 1996
Title Empty targetlist in a plan for certain inherited updates causes user-facing errors
Topic Bug Fixes
Created 2019-02-13 04:03:55
Last modified 2019-02-22 17:27:31 (5 years, 7 months ago)
Latest email 2019-02-22 17:55:32 (5 years, 7 months ago)
Status
2019-03: Committed
Target version stable
Authors Amit Langote (amitlan)
Reviewers Tom Lane (tgl)Become reviewer
Committer Tom Lane (tgl)
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/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
Edit