ydb/yql/essentials/tests/sql/suites/pg, 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
Intermediate changes2026-06-25T05:59:16Zrobot-pigletrobot-piglet@yandex-team.com2026-06-25T05:38:05Zurn:sha1:de27721af9b849663b179cf9bdd98c9ceff1fc2f
commit_hash:da9e5d384dc00d37d939afe28f789f2f608acb0e
Intermediate changes2026-06-24T21:06:00Zrobot-pigletrobot-piglet@yandex-team.com2026-06-24T20:30:23Zurn:sha1:bf1acd3044f6b246fa23f96675060224ca692b31
commit_hash:d17bed0c3f0053f8f24a0e6f3053213ed5fbf423
Intermediate changes2026-06-24T09:30:49Zrobot-pigletrobot-piglet@yandex-team.com2026-06-24T07:56:17Zurn:sha1:cc633200724afe7547eb5ee2206e2f994043b5da
commit_hash:16b28b4a2fa4a98d0bef3efe97d563373903df25
YQL-21152: Support implicit USING at YqlSelect2026-05-27T11:54:47Zvitya-smirnovvitya-smirnov@yandex-team.com2026-05-27T10:42:36Zurn:sha1:697628b31142f184ce280c1893db660679024020
commit_hash:958a606c2956a1155a487070452acc770455bf66
YQL-21027: Fix pg value serialization2026-04-13T16:26:59Zatarasov5atarasov5@yandex-team.com2026-04-13T14:23:52Zurn:sha1:7df251978a33c794fcb66c0d3da0c232dc5c09a3
commit_hash:9ee085f14c8ce1d9c66c3b1008f71570ea975bf8
YQL-21026: Fix IS DISTINCT from pg and null2026-04-01T09:08:19Zatarasov5atarasov5@yandex-team.com2026-04-01T08:21:20Zurn:sha1:c173f660760c2dbd4d593b86c780c9f6f51b8f76
commit_hash:fb14ee5b8cca07451478bfbffcc9a2f0b3d751f5
YQL-20895: Preserve annotation at ExpandSqlSelect2026-02-12T10:34:32Zvitya-smirnovvitya-smirnov@yandex-team.com2026-02-12T09:45:28Zurn:sha1:286b6e0d3e4bb8953b980a186898ca5f3e2b3d90
After a `SqlSelect` expansion the column order must be preserved,
and so type annotation required. During an expansion the `ExprNode`
graph is transformed and so at later stages type annotation is lost,
so we need to backup it. The solution is too pass an original `xxxAnn`
`ExprNode` with `xxx` `ExprNode` to every subprocedure.
commit_hash:e2c4d727ca7617d835e0608c3d341cf76e416a30
Intermediate changes2025-10-13T14:01:39Zrobot-pigletrobot-piglet@yandex-team.com2025-10-13T12:50:05Zurn:sha1:0fea63e0ab4a9c4757ebc64da21993f0fc2f8eb1
commit_hash:c106c0b4122e4493aa70f0007e98dff850405f05
Intermediate changes2025-08-13T16:26:32Zrobot-pigletrobot-piglet@yandex-team.com2025-08-13T16:14:34Zurn:sha1:aae2cfe567a3498ec7c2d50a736c816fe57c4a9f
commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972