summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql
Commit message (Collapse)AuthorAgeFilesLines
* YQL-21292 fixed switching of cycle detector & better diagsvvvv3 days11-1997/+1899
| | | | commit_hash:1a546dc230518eb6846155c77db762e4d83281d5
* YQL-16277: Implement type annotation for SqlCombineimunkin4 days14-9/+214
| | | | commit_hash:7d19863b9dbf9c332d5f8793e47891793fc9091e
* Watermarks: YQL: Fix table hintsvokayndzop4 days1-3/+3
| | | | commit_hash:feaa364ef3d3f71bfa70a7d64e2cc6e3854d79a5
* YQL-16277: Allow using expressions in equi predicates for COMBINE commandimunkin6 days7-8/+84
| | | | commit_hash:3d559c0475767547557bc9401ecd54bb6c531ee0
* hybrid rank callable placeholder KIKIMR-25488gvit6 days6-0/+85
| | | | commit_hash:eabe9b632535a58658e2ffa4220cd5782df5b2da
* YQL-21246: Propagate ExtractMembers over TableSourceimunkin12 days5-6/+59
| | | | commit_hash:048f5c5f1cf2f507a91c2f4cdb24aec0cc71a004
* YQL-20855: Support NULL as a type namevitya-smirnov13 days4-12/+11
| | | | commit_hash:e420d2d62e3a77af79abbec946f1008c1fa359c6
* YQL-21152: Support implicit USING at YqlSelectvitya-smirnov13 days35-1/+568
| | | | commit_hash:958a606c2956a1155a487070452acc770455bf66
* Check lambda scope in the linear checkervvvv14 days13-24/+103
| | | | commit_hash:65d1e3053e157375f7a704f1e635467ded5a7ef2
* YQL-21046: Support RANGE window on YqlSelectvitya-smirnov2026-05-2221-288/+671
| | | | commit_hash:2cb369cb2091489e28790782fe9e7679d367fbb3
* Intermediate changesrobot-piglet2026-05-1965-14886/+14987
| | | | commit_hash:5e471728023b5404426daed232c4b00dbba8026c
* YQL-20234: Support Percentile agg phasesvitya-smirnov2026-05-1840-84/+3081
| | | | commit_hash:617264515b5da826be1327cb91b7fc6f6801a835
* YQL-16277: Implement frontend for COMBINE commandimunkin2026-05-134-0/+71
| | | | commit_hash:5a7847c000c3e5ec4cadf6880184d3eebb26d3b1
* YQL-20234: Support RandomValue agg phasesvitya-smirnov2026-05-1319-0/+1478
| | | | commit_hash:934d9bd00af5903f26796cf610789aaa4a7bf39c
* YQL-21228 fix nulled == over variantsvvvv2026-05-124-0/+34
| | | | commit_hash:72d0f5c9f96875682a71eb11e67783a723112cce
* Enable window new pipeline by defaultatarasov52026-05-0811-1164/+1164
| | | | | | | Canonize more tests Canonize -F "*window*" -F "*tpcds*" tests Enable window new pipeline by default commit_hash:6b5900972f1d065c6956e7ee03e734a80e0c6fa5
* YQL-21210 new lang vervvvv2026-05-079-22/+17
| | | | commit_hash:23ab69eb08e7c8f74df14dfc43e6109479b8dd15
* YQL-19813: Udf implementationatarasov52026-05-075-11/+13
| | | | commit_hash:183e3a952a021c4701c20d6677800f245239d822
* YQL-21136: Fix AvgIf(Interval64) result typevitya-smirnov2026-05-066-0/+287
| | | | commit_hash:13889e43b6156f11945dcee2ab2b59cdb056ce49
* YQL-20234: Support Corr and Cov agg phasesvitya-smirnov2026-05-0625-0/+1994
| | | | commit_hash:cb540d095291ddee3bb60c2d3addee54d23daa1c
* Intermediate changesrobot-piglet2026-05-055-0/+278
| | | | commit_hash:a876b0522ba7aa9c9d4af22e749605f0a57343c2
* YQL-20928: Fix RIGHT JOIN for YqlSelectvitya-smirnov2026-04-3020-20/+391
| | | | | | | | | | 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-304-0/+47
| | | | commit_hash:c998ba15db7c4e5137f44904de85755aa7322e8e
* YQL-20928: Support SELECT DISTINCT for YqlSelectvitya-smirnov2026-04-307-18/+80
| | | | commit_hash:af4c180548bf1699ec6afb335167a4220418386c
* YQL-19813: Pass runtime settings to minikql + YT + minirunatarasov52026-04-298-3/+52
| | | | commit_hash:054395f57e37951159c1184eae2e6d4bc81245f8
* YQL-21048: Support Grouping function at YqlSelectvitya-smirnov2026-04-284-0/+66
| | | | | | 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-2857-31/+1322
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-2313-76/+36
| | | | commit_hash:a201cbc3a08b7bad471d4d6a15f3dfc3f63d989b
* Enable ExpandLMapOrShuffleByKeysViaBlock by defaultimunkin2026-04-218-39/+39
| | | | commit_hash:3eed51d012b7cde52449ebd225789e18b8ebd678
* YQL-21034: Convert integers to Uint64 at ListSampleNmariibykova2026-04-2011-147/+139
| | | | commit_hash:f508795113ebbfadfb1bc05529f4af46ae7837d2
* Pushdown/fuse Filter + CalcOverWindowaneporada2026-04-2019-0/+581
| | | | commit_hash:198ce0c7875d77fab8082382d915bf1261775f68
* YQL-21046: Support window aggregation over YqlSelectvitya-smirnov2026-04-2040-0/+1217
| | | | | | | | | 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-176-0/+89
| | | | commit_hash:820e0aec8856d51711fb71caa225cd7d6d89e7a0
* YQL-21165 fixvvvv2026-04-154-11/+13
| | | | commit_hash:ea278625098c2a9c0ad3bfbab7b981d3cc556020
* Intermediate changesrobot-piglet2026-04-15136-455/+331
| | | | commit_hash:9bdeca950e4ca97e07b2da163f014c101189c60b
* YQL-21031: Range decimalatarasov52026-04-1448-12/+913
| | | | commit_hash:836406699a568f3d53cbd91256d586d37bf8f4a9
* YQL-21027: Fix pg value serializationatarasov52026-04-1310-10/+61
| | | | commit_hash:9ee085f14c8ce1d9c66c3b1008f71570ea975bf8
* YQL-20873: Range PG supportatarasov52026-04-13191-2/+5427
| | | | commit_hash:9e799ea42a2692eb96ebc792b48e46dd060c182b
* Secure tmp foldersziganshinmr2026-04-081-6/+6
| | | | | Add support for automated allocation of secure TmpFolder on YT clusters for each user commit_hash:2d06fc7616f65d9814c7a5ca33a4da582fb5b016
* YQL-20773 PositionOf & WithIssuevvvv2026-04-0115-0/+129
| | | | commit_hash:fd9981b64488aca88d19a45aa956d80eab220cb8
* YQL-21026: Fix IS DISTINCT from pg and nullatarasov52026-04-0110-0/+191
| | | | commit_hash:fb14ee5b8cca07451478bfbffcc9a2f0b3d751f5
* YQL-20234: Fix partial aggregation for Histogram and TopFreqvitya-smirnov2026-03-3119-0/+1482
| | | | | | `Null` are not yet implemented, because it was hard to fix, will do it later. commit_hash:879a892d511a0a2dd7110a728f01f80c260dedbf
* YQL-21048: Support GROUPING SETS for YqlSelectvitya-smirnov2026-03-3035-0/+954
| | | | | | | | | | | | | | | | | | This patch unlocks a subset of `GROUPING SETS`, `ROLLUP` and `CUBE` syntax for `YqlSelect`. The `sql` was easy, but I faced problems at the `core` level. An existing expansion was OK, but type annotation was changed to correctly annotate `GROUP BY` keys as `Optional`. ```haskell notNullKeys groupBy = union [ ( intersection [ groupingSet | groupingSet in groupingSets ] ) | groupingSets in groupBy ] ``` It gives 60/100 (+9) TPC-DS queries. commit_hash:defda3152f10bf16b9e6300294bc23cccfa1329c
* YQL-20234: Fix partial aggregation for Top/Bottomvitya-smirnov2026-03-3036-0/+2964
| | | | | | | | | | | | Fixed agg phases for `Top`, `Bottom`, `TopBy` and `BottomBy`. The `SerializedState` for `Top` and `Bottom` is contains `MaxSize`, so only the `state` argument is required when it `IsOverState`. `Null` are not yet implemented, because it was hard to fix, will do it later. The code is not clean, but to fix it a huge refactoring is needed, including `aggregate.yqls` and `aggregation.cpp`. Also YQLs minirun launch target was introduced, because it is easier to experiment with YQLs directly, rather than tweaking the SQL translator. commit_hash:47af002f70d9be6db61316e64aa866d4bff34cf4
* Intermediate changesrobot-piglet2026-03-2358-0/+6000
| | | | commit_hash:52386c60ce66e769fe972c72eed82ace0d34242b
* YQL-20793 Sql tests, final partvvvv2026-03-231-1/+1
| | | | commit_hash:1b894cda0775421321d11382600be79c3b5bef3d
* YQL-21068: Fix duplicated preaggregate exprvitya-smirnov2026-03-204-0/+48
| | | | | | | | | | | | Here was 2 issues: 1. `Init` return status was ignored and so error suppressed. 2. `PreaggregateExpr` was collected twice. On the first attempt it was replaced with a synthetic column that will be "registered" in a source later, and on a second attempt it was already that synthetic, but not yet registered column and so it's init was failing. commit_hash:4398a075d53d99cbb9b172ebae0a05aff5e2d5a7
* YQL-20793 Sql tests, part 1vvvv2026-03-201-1/+1
| | | | commit_hash:63ea284bd7ade74203421fe2a12318f658f058eb
* YQL-20928: Fix YqlSelect quoted atoms and unsupported messagevitya-smirnov2026-03-191-363/+363
| | | | | | | | | | | | | | This PR "unmutes" some TPC-DS queries. There was 2 defect kinds fixed: 1. Other than ordinary `GROUP BY` variants were actually unsupported, but not checked by an implementation. 2. Just `Q(TString)` was used to make quoted atoms, but it is not generally correct, because it does not wrap the arbitrary content and so `QUOTED_ID`s with spaces made a ill-formed YQLs. The second defect fix gave us +5 successfully compilable queries. commit_hash:10891b4cfc19872c8bb4b0765de2efae26797693
* Cherry pick YQL-20998: Emit Reads only on EXISTSvitya-smirnov2026-03-181-447/+447
| | | | | Return that commit, because the problem, why [Rollback: rXXXXXX](https://nda.ya.ru/t/trCMW4CN7X4Gwb) was initiated was not in that commit, but other problem - see [a comment](https://nda.ya.ru/t/r31wHW2u7X4HUs). commit_hash:bb553ac4b3ab46e326e6fbb8e811d80efdda8aba
generated by cgit v1.3 (git 2.53.0) at 2026-06-09 01:42:34 +0000