ydb/yql/essentials/tests/sql/suites/blocks, branch main

YQL-21315: Block variant item implementation

2026-07-17T15:57:11Z

BlockVariantItem implementation commit_hash:f35a597dee3dc67ebc5be599ed9d379d7ad57802

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-21315: Implement block guess

2026-06-26T09:00:47Z

#### Implement BlockGuess functionality for variant type extraction ✎ - Introduces BlockGuess functionality to extract specific alternatives from variant types, supporting both tuple and struct variants - Adds type annotation and runtime implementation for BlockGuess operations with proper validation and error handling - Implements peephole optimization support for BlockGuess operations to improve query execution plans - Includes comprehensive unit tests and SQL format validation for various BlockGuess scenarios - Updates runtime version to 79 to enable new BlockGuess features and ensures backward compatibility Autodescription by Yandex Code Assistant commit_hash:e8f7fc2859cc1986ee0d5fba8b3e25bbf9ba4c41

YQL-21246: Propagate ExtractMembers over TableSource

2026-05-27T17:24:27Z

commit_hash:048f5c5f1cf2f507a91c2f4cdb24aec0cc71a004

Intermediate changes

2025-08-13T16:26:32Z

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

YQL-20230: Handle singular types in DoConvertScalar

2025-07-23T14:06:19Z

commit_hash:c22dc757dcd7996bac8fb892184281503a2ab003

YQL-20167 canonized short key content

2025-07-10T08:53:04Z

commit_hash:0cc244f5272c4bc099db5bf8fb56566a11391158

YQL-19536: Block ifpresent

2025-07-08T05:39:34Z

commit_hash:15146ac1817e0abc0483b2c138207daf3b63fdd5