Coerce Type: CollateExpr should be discarded if the target type is non-collatable

Title

Topic

Bug Fixes

Created

2021-04-13 08:34:28

Last modified

2021-05-12 18:16:18 (3 years, 6 months ago)

Latest email

2021-04-19 16:47:38 (3 years, 7 months ago)

Status

2021-07: Committed

Target version

stable

Authors

Yulin PEI (pylser)

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

Emails

Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10));: First at 2021-04-12 15:39:38 by Yulin PEI <ypeiae at connect.ust.hk>
Latest at 2021-04-19 16:47:38 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (fix-collation-coercion.patch) at 2021-04-18 16:31:07 from Yulin PEI <ypeiae at connect.ust.hk>
    Attachment (fix-collation-coercion.patch) at 2021-04-18 16:31:07 from Yulin PEI <ypeiae at connect.ust.hk> (Patch: Yes)
    Attachment (0001-add-regress.patch) at 2021-04-13 09:27:08 from Yulin PEI <ypeiae at connect.ust.hk> (Patch: Yes)
    Attachment (fix-bogus-collation-coercion.patch) at 2021-04-12 16:59:43 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2021-05-12 18:16:18	Tom Lane (tgl)	Closed in commitfest 2021-07 with status: Committed
2021-04-13 08:36:44	Yulin PEI (pylser)	Changed reviewers to Tom Lane (tgl)
2021-04-13 08:36:44	Yulin PEI (pylser)	Changed authors to Yulin PEI (pylser)
2021-04-13 08:35:18	Yulin PEI (pylser)	Changed authors to Tom Lane (tgl), Yulin PEI (pylser)
2021-04-13 08:35:18	Yulin PEI (pylser)	Changed committer to tgl
2021-04-13 08:35:18	Yulin PEI (pylser)	Changed targetversion to stable
2021-04-13 08:34:28	Yulin PEI (pylser)	Attached mail thread HK0PR01MB22744393C474D503E16C8509F4709@HK0PR01MB2274.apcprd01.prod.exchangelabs.com
2021-04-13 08:34:28	Yulin PEI (pylser)	Created patch record