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

Title

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-09 07:24:24 (5 days ago)

Latest email

2025-10-09 04:24:13 (5 days ago)

Status

PG19-3 (2025-11-01 – 2025-11-30): Committed

Target version

stable

Authors

Jian He (stayreal)

Reviewers

Committer

Amit Langote (amitlan)

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-09 04:24:13 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: Yes)
    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-09 07:24:24	Jian He (stayreal)	Closed in commitfest PG19-3 with status: Committed
2025-10-09 07:24:23	Jian He (stayreal)	Closed in commitfest PG19-3 with status: Committed
2025-10-09 07:24:23	Jian He (stayreal)	Changed committer to amitlan
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