ydb/yql/essentials/tests/sql/suites/pg/fail_collate_mixed.sql, branch mainMirror of YDB github reposhttps://code.mastervirt.ru/ydb/atom?h=main2026-07-14T14:57:28ZYQL-21404 implemented syscache, table, func call2026-07-14T14:57:28Zvvvvvvvv@yandex-team.com2026-07-14T14:17:32Zurn:sha1:4f6a4597ecf74d3d25e8df990b45ee81026c73b0
#### `YQL-21404`: Implemented syscache, table, and function call support for collations ✎
- Added support for PostgreSQL collation handling in function calls, enabling explicit collation specification via named arguments
- Implemented syscache and table catalog support for pg_collation system table to provide complete catalog information
- Enhanced type annotation and runtime compilation to properly handle collation OIDs and validate collation names
- Introduced ICU locale collation support with stable OID assignment based on locale position in generated catalog
- Added comprehensive test coverage for collation functionality including standard and ICU locales, collation validation, and error cases
- Extended SQL parsing to support COLLATE clauses and proper collation propagation in function calls
<a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a>
commit_hash:e9a32cc848bef7b68b4f57f71a1f5f69e0de9653