ydb/yql/essentials/tests/sql/minirun/part3, branch main

YQL-21404 implemented syscache, table, func call

2026-07-14T14:57:28Z

#### `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 Autodescription by Yandex Code Assistant commit_hash:e9a32cc848bef7b68b4f57f71a1f5f69e0de9653

YQL-21315: Implement block variant comp node

2026-07-14T09:17:28Z

#### Implement Block Variant Computational Node ✎ - Introduces a new computational node for handling variant types in block operations, supporting both tuple and struct variants - Adds type annotation and runtime support for the new variant node with proper type checking and validation - Implements block-level variant operations that can select specific alternatives from variant types based on index or member name - Includes comprehensive unit tests and integration tests covering both tuple and struct variant scenarios - Updates runtime version to 81 and integrates the new node into the compilation and execution pipeline - Provides SQL syntax support for variant operations through the `Variant` function with appropriate type handling Autodescription by Yandex Code Assistant commit_hash:a07c1a365815a271cdd34958369156fd542fd5cc

YQL-21315: Block way implementation

2026-07-07T13:59:11Z

#### Block Way Implementation ✎ - Implemented the `BlockWay` function to extract variant type information from block inputs, returning either tuple indices or struct member names - Added type annotation support for `BlockWay` operations with proper handling of optional variants and different underlying types - Introduced computation node implementation for `BlockWay` that processes both tuple and struct variants efficiently - Enhanced runtime version handling to support the new `BlockWay` functionality with version 80 - Added comprehensive unit tests covering various scenarios including tuple variants, struct variants, optional variants, and edge cases - Integrated `BlockWay` into the SQL parser and program builder with proper type inference and validation - Added SQL format tests and canonical data for tuple and struct variant scenarios with and without optionality Autodescription by Yandex Code Assistant commit_hash:70a82f5d13a7c1499a9ad88fc5d9b079e352d7ef

YQL-16277: Implement ExpandSqlCombine optimizer

2026-06-29T12:49:32Z

#### Implement SqlCombine optimizer and enhance ListJoinCore type checking ✎ - Introduce ExpandSqlCombine optimizer to handle SQL COMBINE operations, enabling efficient execution of combine operations with proper key handling and sorting - Refactor ListJoinCore type annotation logic to use tuples instead of structs for key types, improving type safety and consistency in multi-key scenarios - Add auxiliary constants for consistent naming of input prefixes and key members in join operations - Update MKQL compiler and type annotation components to support the new SqlCombine expansion and improved type checking - Enhance test coverage with new test cases for various SqlCombine scenarios including single key, multi-key, optional keys, and type mismatches - Adjust existing tests and canonical data to reflect the changes in type handling and naming conventions Autodescription by Yandex Code Assistant commit_hash:376f67bfed851d0e4f7ac354d22220ba4f4737e2

Intermediate changes

2026-06-25T05:59:16Z

commit_hash:da9e5d384dc00d37d939afe28f789f2f608acb0e

Intermediate changes

2026-06-24T21:06:00Z

commit_hash:d17bed0c3f0053f8f24a0e6f3053213ed5fbf423

Intermediate changes

2026-06-24T09:30:49Z

commit_hash:16b28b4a2fa4a98d0bef3efe97d563373903df25

YQL-21152: Support implicit USING at YqlSelect

2026-05-27T11:54:47Z

commit_hash:958a606c2956a1155a487070452acc770455bf66

YQL-21046: Support RANGE window on YqlSelect

2026-05-22T15:10:49Z

commit_hash:2cb369cb2091489e28790782fe9e7679d367fbb3

Intermediate changes

2026-05-19T12:16:12Z

commit_hash:5e471728023b5404426daed232c4b00dbba8026c