ydb/yql/essentials/tests/sql/minirun/part2, 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

Push Any in EquiJoin tree

2026-07-06T16:08:27Z

#### Push Any in EquiJoin tree ✎ - Introduces logic to push "Any" hints through EquiJoin tree structures to optimize join operations - Adds support for all join types (Inner, Left, Right, Full, Semi, etc.) when pushing Any hints - Moves PruneKeys functionality to the leaves of EquiJoin tree and enhances its behavior - Implements new optimization passes that improve pruning and hint propagation in join operations - Updates test suite with comprehensive test cases covering various join types and key shapes - Refactors existing code by moving EquiJoin-related optimizations into a dedicated flow step Autodescription by Yandex Code Assistant commit_hash:fda17ab32277b4da545c8df1393eaeb8a7e5c229

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

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-21048: Fix GROUPING SETS aggregation optionality on YqlSelect

2026-06-22T12:21:21Z

This patch fixes the query . If you remove `PRAGMA YqlSelect`, you'll see that it works on a legacy translation. It is also required to fix PR , because saving a column order makes the bug visible. The `nokey` flag of `YqlAgg` callable was renamed to `as_optional` and also an expansion was fixed by rewriting `MatchType` on `Optional` to `AsOptionalType` to handle `Null` and `pg` types properly. commit_hash:dc435437e87006c79bb93984d65931aaf5901af4

YQL-21152: Support implicit USING at YqlSelect

2026-05-27T11:54:47Z

commit_hash:958a606c2956a1155a487070452acc770455bf66

Check lambda scope in the linear checker

2026-05-26T09:20:50Z

commit_hash:65d1e3053e157375f7a704f1e635467ded5a7ef2

YQL-21046: Support RANGE window on YqlSelect

2026-05-22T15:10:49Z

commit_hash:2cb369cb2091489e28790782fe9e7679d367fbb3