sql/json query function JsonBehavior default expression's collation may differ from returning type's collation

Edit
ID 6100
Title sql/json query function JsonBehavior default expression's collation may differ from returning type's collation
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 1, First patch: +113−14, All patches: +113−14
Topic Bug Fixes
Tags Backport Bugfix
Created 2025-10-03 13:45:22
Last modified 2025-10-03 13:45:22 (4 days ago)
Latest email 2025-10-08 04:10:03 (32 minutes ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
Target version stable
Authors Jian He (stayreal)
Reviewers Become reviewer
Committer
Links
Emails
sql/json query function JsonBehavior default expression's collation may differ from returning type's collation
First at 2025-07-14 11:39:18 by jian he <jian.universality at gmail.com>
Latest at 2025-10-08 04:10:03 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v4-0001-Fix-internal-error-from-CollateExpr-in-SQL-JSON-D.patch) at 2025-10-08 04:10:03 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v4-0001-Fix-internal-error-from-CollateExpr-in-SQL-JSON-D.patch) at 2025-10-08 04:10:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Pending check)
    Attachment (v3-0001-Fix-internal-error-from-CollateExpr-in-SQL-JSON-D.patch) at 2025-10-06 13:58:44 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-fix-SQL-JSON-default-expression-collation-issue.patch) at 2025-10-03 12:56:53 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-fix-SQL-JSON-default-expression-with-CollateExpr-node.patch) at 2025-07-21 08:57:41 from jian he <jian.universality at gmail.com> (Patch: Yes)
History
When Who What
2025-10-03 13:45:22 Jian He (stayreal) Attached mail thread CACJufxHVwYYSyiVQ6o+PsRX6zQ7rAFinh_fv1kCfTsT1xG4Zeg@mail.gmail.com
2025-10-03 13:45:22 Jian He (stayreal) Created patch record
Edit