summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/sql2yql/canondata
Commit message (Collapse)AuthorAgeFilesLines
* YQL-20631: Support WITH CTE columns and fix UNION column order for YqlSelectvitya-smirnov4 days6-0/+247
| | | | | | | | | | | Implemented a column names specification for a WITH CTE. It requires a column order derivation. It was not working on `YqlSelect` until PR https://nda.ya.ru/t/qOC3TNqn7gAcy6 was merged. Also there was a bug with `UNION` column order inference, which is essential for RECURSIVE queries. There was compatibility problems with `PgSelect` `UNION` positional column order semantics, so it was tweaked in `YqlSelect` mode. commit_hash:c96192270ca6d51eaa0cb39cf59b65c3951ce3fe
* YQL-21048: Fix GROUPING SETS aggregation optionality on YqlSelectvitya-smirnov4 days4-0/+588
| | | | | | | | | | | | This patch fixes the query <https://nda.ya.ru/t/pYH4zpRH7fw6U4>. If you remove `PRAGMA YqlSelect`, you'll see that it works on a legacy translation. It is also required to fix PR <https://nda.ya.ru/t/IZFPoRjS7fw6j8>, 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-21338: Better error messageatarasov55 days8-3/+136
| | | | | | | | | | | | | | #### Better error messages for window frame expressions ✎ - Improved error messaging for RANGE window frames to provide more specific information about unsupported column types and invalid ORDER BY expressions - Removed obsolete error handling for multiple sort columns and simplified the sort traits variant - Enhanced error reporting with detailed type information when RANGE frames are used with non-numeric or complex expressions - Added better handling for error types in ORDER BY expressions with improved diagnostic messages including nested error details - Updated error messages to be more descriptive and actionable, showing the actual column type causing the issue - Added new test cases covering various error scenarios including NULL types, optional types, and invalid expressions <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:1d2301ac75b3ff7bc9ca97213e9005507654e56b
* YQL-20631: Support RECURSIVE WITH CTE on YqlSelectvitya-smirnov7 days8-0/+253
| | | | | | | | | | Implemented a RECURSIVE WITH CTE translation for YqlSelect. It relies on YqlSelf callable. As this callable binds to enclosing YqlSelect, the diagnostic that subquery can't reference an enclosing RECURSIVE WITH CTE was added, it is better, that an existing for pgSQL, where just "table not found" is emitted. The core idea under RECURSIVE handling is that a "not ready" CTE entry is added to a namespace (with a `nullptr` node), so it can be recognized. Checked some interesting test cases and wrote TODOs. commit_hash:65b8646e0615ae070b04822ce7af24245c203bbe
* YQL-20631: Support simple CTEs on YqlSelectvitya-smirnov8 days3-0/+89
| | | | | | | | | | | | | | | | | | | | | | | The first iteration on WITH CTE support. Only simple CTEs are supported. Properties: 1. Redefinition is forbidden. 2. Shadowing is supported. 3. Nested WITH CTEs are supported. Following features are not yet implemented: 1. Column names specification. There is an assertion failure at core because of an absent column order when translating it like for the `PgSelect`. 2. `RECURSIVE` is postponed. There a more sophisticated translation with `YqlSelf` callable is required. Also there was a potential defect because of an empty `Id` result not expected. commit_hash:759676d8a9d369f7eedd9b87f79455b2f8a9fcff
* YQL-21321 don't check for persistable in agg traits typecheckvvvv9 days2-0/+21
| | | | | | | | | | | #### `YQL-21321`: Adjust type checking for aggregate traits ✎ - Replaced persistable type check with computable type check during aggregate trait validation to allow more flexible type handling - Added new test cases to verify the behavior of unused aggregate types and ensure proper error reporting - Updated canonical data and test artifacts to reflect the changes in type checking logic and error messages <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:e14b06e4a135d9aef8ae78a75c3fb23d983365a6
* Use Cons! in translator instead of Nthudovichenko-r10 days1-1047/+1047
| | | | commit_hash:ec28efb62da755bd372bba274c8eaa0f3f5233f3
* YQL-21321 deep error check for EnsurePersistablevvvv10 days2-0/+31
| | | | | | | | | | | | #### Deep error checking for EnsurePersistable ✎ - Replaced shallow error checking with comprehensive error detection in `EnsurePersistable` functions to ensure all type annotation errors are properly identified - Introduced new `HasAnyError` function that performs thorough error traversal to catch nested or indirect type errors - Updated test cases to verify error handling behavior and ensure proper error reporting for incompatible types in SQL operations - Enhanced type annotation validation to provide more reliable persistence checks for expression nodes <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:019e5924e7d6bdfea7fa46be3da3615b17727b76
* Fix PayloadRenameOverWindow in overwrite caseaneporada2026-06-112-0/+49
| | | | commit_hash:867eb4209058a877aa60f86931daddf1e25ac600
* YQL-21297: Handle Interval64 in aggregate/windowvitya-smirnov2026-06-107-0/+251
| | | | commit_hash:10c8d54083c7064e63989ad9c341711fe84409b4
* YQL-20234: Fix agg phases over Null and disallow DISTINCTvitya-smirnov2026-06-0810-89/+75
| | | | | | | - Fixed histogram, (bottom/top)(by)?, topfreq, random_(value/sample) over Null - Disabled DISTINCT with agg phases - Refactored code by phase predicates extraction commit_hash:c82f790224e84e542572d5cd270766e3244b4178
* YQL-21292 fixed switching of cycle detector & better diagsvvvv2026-06-059-1997/+1860
| | | | commit_hash:1a546dc230518eb6846155c77db762e4d83281d5
* YQL-16277: Implement type annotation for SqlCombineimunkin2026-06-046-7/+133
| | | | commit_hash:7d19863b9dbf9c332d5f8793e47891793fc9091e
* Watermarks: YQL: Fix table hintsvokayndzop2026-06-041-3/+3
| | | | commit_hash:feaa364ef3d3f71bfa70a7d64e2cc6e3854d79a5
* YQL-16277: Allow using expressions in equi predicates for COMBINE commandimunkin2026-06-023-7/+55
| | | | commit_hash:3d559c0475767547557bc9401ecd54bb6c531ee0
* hybrid rank callable placeholder KIKIMR-25488gvit2026-06-026-0/+85
| | | | commit_hash:eabe9b632535a58658e2ffa4220cd5782df5b2da
* YQL-21246: Propagate ExtractMembers over TableSourceimunkin2026-05-272-0/+24
| | | | commit_hash:048f5c5f1cf2f507a91c2f4cdb24aec0cc71a004
* YQL-20855: Support NULL as a type namevitya-smirnov2026-05-272-4/+4
| | | | commit_hash:e420d2d62e3a77af79abbec946f1008c1fa359c6
* YQL-21152: Support implicit USING at YqlSelectvitya-smirnov2026-05-2712-0/+402
| | | | commit_hash:958a606c2956a1155a487070452acc770455bf66
* Check lambda scope in the linear checkervvvv2026-05-263-0/+47
| | | | commit_hash:65d1e3053e157375f7a704f1e635467ded5a7ef2
* YQL-21046: Support RANGE window on YqlSelectvitya-smirnov2026-05-224-151/+488
| | | | commit_hash:2cb369cb2091489e28790782fe9e7679d367fbb3
* YQL-20234: Support Percentile agg phasesvitya-smirnov2026-05-1816-27/+1911
| | | | commit_hash:617264515b5da826be1327cb91b7fc6f6801a835
* YQL-16277: Implement frontend for COMBINE commandimunkin2026-05-132-0/+44
| | | | commit_hash:5a7847c000c3e5ec4cadf6880184d3eebb26d3b1
* YQL-20234: Support RandomValue agg phasesvitya-smirnov2026-05-137-0/+944
| | | | commit_hash:934d9bd00af5903f26796cf610789aaa4a7bf39c
* YQL-21228 fix nulled == over variantsvvvv2026-05-122-0/+17
| | | | commit_hash:72d0f5c9f96875682a71eb11e67783a723112cce
* Enable window new pipeline by defaultatarasov52026-05-081-504/+504
| | | | | | | Canonize more tests Canonize -F "*window*" -F "*tpcds*" tests Enable window new pipeline by default commit_hash:6b5900972f1d065c6956e7ee03e734a80e0c6fa5
* YQL-21210 new lang vervvvv2026-05-071-9/+9
| | | | commit_hash:23ab69eb08e7c8f74df14dfc43e6109479b8dd15
* YQL-19813: Udf implementationatarasov52026-05-072-5/+5
| | | | commit_hash:183e3a952a021c4701c20d6677800f245239d822
* YQL-21136: Fix AvgIf(Interval64) result typevitya-smirnov2026-05-063-0/+180
| | | | commit_hash:13889e43b6156f11945dcee2ab2b59cdb056ce49
* YQL-20234: Support Corr and Cov agg phasesvitya-smirnov2026-05-069-0/+1282
| | | | commit_hash:cb540d095291ddee3bb60c2d3addee54d23daa1c
* Intermediate changesrobot-piglet2026-05-052-0/+144
| | | | commit_hash:a876b0522ba7aa9c9d4af22e749605f0a57343c2
* YQL-20928: Fix RIGHT JOIN for YqlSelectvitya-smirnov2026-04-306-8/+271
| | | | | | | | | | Support `FULL JOIN` and fix `RIGHT JOIN` for `YqlSelect`. The problem with `RIGHT JOIN` is that in a situation, when we have `[a, b, c, d, e]` on a stack and are going to "perform" `right`, all of `[a, b, c, d, e]` are marked optional, because the `inputIndex` is equal to stack size. But we must mark only `[a, b, c, d]` as optionals. commit_hash:b78c5bcecba4b736475d3428918c2a3c377373bb
* YQL-21128: create AsOptionalmariibykova2026-04-302-0/+21
| | | | commit_hash:c998ba15db7c4e5137f44904de85755aa7322e8e
* YQL-20928: Support SELECT DISTINCT for YqlSelectvitya-smirnov2026-04-303-8/+38
| | | | commit_hash:af4c180548bf1699ec6afb335167a4220418386c
* YQL-19813: Pass runtime settings to minikql + YT + minirunatarasov52026-04-292-0/+16
| | | | commit_hash:054395f57e37951159c1184eae2e6d4bc81245f8
* YQL-21048: Support Grouping function at YqlSelectvitya-smirnov2026-04-282-0/+32
| | | | | | Now `Grouping` function kindly works, but with some known bug, that will be fixed in the next PR. It gives 4 TPC-DS queries. commit_hash:e891401453cbd9d9d964f673053b856e55ea8b56
* YQL-21046: Support window functions for YqlSelectvitya-smirnov2026-04-2823-14/+769
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch adds support for `RowNumber`, `CumeDist`, `NTile`, `Rank`, `DenseRank`, `PercentRank`, `Lead`, `Lag`, `FirstValue`, `LastValue` and `NthValue`. It gives +3 TPC-DS queries and +5 TPC-DS bugs unlocked. The callable `YqlWin` was introduces, having the following form: ```yqls (YqlWin 'function_name 'window_name '() # options (Void) # type slot ...) # args ``` During the callable type annotation and expansion the same code for implementation functions substitution is used and shared even with a pgSQL. There was an issue with a `listType` for `YqlAgg`, `YqlAggWin` and `YqlWin`, because it was built incorrectly by referencing an atom "row" instead of _that_ argument row. It is fixed with a new "type slot". Now it has 3 states: `(Void)`, which is set by translator just as a stub, `row` that is set by `YqlSetItemWrapper` during the `RebuildLambdaColumns`, so then on the `YqlWin` type annotation it can take this `row` and wrap it to the `listType`, pass to the function and call for a repetition, so in a next stage the `resultType` will be ready. commit_hash:256fc2cb359714a646a308359b340b1715919f5d
* YQL-16594 hide warnings in some casesvvvv2026-04-232-0/+20
| | | | commit_hash:a201cbc3a08b7bad471d4d6a15f3dfc3f63d989b
* YQL-21034: Convert integers to Uint64 at ListSampleNmariibykova2026-04-204-60/+61
| | | | commit_hash:f508795113ebbfadfb1bc05529f4af46ae7837d2
* Pushdown/fuse Filter + CalcOverWindowaneporada2026-04-207-0/+368
| | | | commit_hash:198ce0c7875d77fab8082382d915bf1261775f68
* YQL-21046: Support window aggregation over YqlSelectvitya-smirnov2026-04-2014-0/+605
| | | | | | | | | Introduce `YqlAggWin` callable and adapt `PgWindow` as `YqlWindow`. The `YqlAggWin` is similar to `YqlAgg`, but with window reference (name) included. Moved `PgWindowWrapper` to `SqlWindowWrapper`. It gives +6 TPC-DS test cases. Window functions are not yet supported, because they have separate callables and an extra design is required. commit_hash:ccef4463fd994779da21514dc9f6f596c511bbfe
* YQL-21168: Fix protobuf type config file parsingatarasov52026-04-172-0/+36
| | | | commit_hash:820e0aec8856d51711fb71caa225cd7d6d89e7a0
* YQL-21165 fixvvvv2026-04-152-4/+6
| | | | commit_hash:ea278625098c2a9c0ad3bfbab7b981d3cc556020
* Intermediate changesrobot-piglet2026-04-1563-248/+186
| | | | commit_hash:9bdeca950e4ca97e07b2da163f014c101189c60b
* YQL-21031: Range decimalatarasov52026-04-1417-6/+482
| | | | commit_hash:836406699a568f3d53cbd91256d586d37bf8f4a9
* YQL-21027: Fix pg value serializationatarasov52026-04-134-6/+25
| | | | commit_hash:9ee085f14c8ce1d9c66c3b1008f71570ea975bf8
* YQL-20873: Range PG supportatarasov52026-04-1361-0/+2705
| | | | commit_hash:9e799ea42a2692eb96ebc792b48e46dd060c182b
* YQL-20773 PositionOf & WithIssuevvvv2026-04-015-0/+72
| | | | commit_hash:fd9981b64488aca88d19a45aa956d80eab220cb8
* YQL-21026: Fix IS DISTINCT from pg and nullatarasov52026-04-014-0/+91
| | | | commit_hash:fb14ee5b8cca07451478bfbffcc9a2f0b3d751f5
* YQL-20234: Fix partial aggregation for Histogram and TopFreqvitya-smirnov2026-03-317-0/+946
| | | | | | `Null` are not yet implemented, because it was hard to fix, will do it later. commit_hash:879a892d511a0a2dd7110a728f01f80c260dedbf
generated by cgit v1.3 (git 2.53.0) at 2026-06-26 23:31:48 +0000