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

Edit
ID 3072
Title Coerce Type: CollateExpr should be discarded if the target type is non-collatable
Topic Bug Fixes
Created 2021-04-13 08:34:28
Last modified 2021-05-12 18:16:18 (3 years, 5 months ago)
Latest email 2021-04-19 16:47:38 (3 years, 6 months ago)
Status
2021-07: Committed
Target version stable
Authors Yulin PEI (pylser)
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/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
Edit