summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites
Commit message (Collapse)AuthorAgeFilesLines
* YQL-21292 fixed switching of cycle detector & better diagsvvvv3 days1-0/+25
| | | | commit_hash:1a546dc230518eb6846155c77db762e4d83281d5
* YQL-16277: Implement type annotation for SqlCombineimunkin4 days8-2/+81
| | | | commit_hash:7d19863b9dbf9c332d5f8793e47891793fc9091e
* YQL-16277: Allow using expressions in equi predicates for COMBINE commandimunkin6 days4-1/+29
| | | | commit_hash:3d559c0475767547557bc9401ecd54bb6c531ee0
* YQL-21246: Propagate ExtractMembers over TableSourceimunkin12 days1-0/+8
| | | | commit_hash:048f5c5f1cf2f507a91c2f4cdb24aec0cc71a004
* YQL-20855: Support NULL as a type namevitya-smirnov12 days1-2/+1
| | | | commit_hash:e420d2d62e3a77af79abbec946f1008c1fa359c6
* YQL-21152: Support implicit USING at YqlSelectvitya-smirnov13 days16-1/+68
| | | | commit_hash:958a606c2956a1155a487070452acc770455bf66
* Check lambda scope in the linear checkervvvv14 days4-0/+18
| | | | commit_hash:65d1e3053e157375f7a704f1e635467ded5a7ef2
* YQL-21046: Support RANGE window on YqlSelectvitya-smirnov2026-05-223-48/+80
| | | | commit_hash:2cb369cb2091489e28790782fe9e7679d367fbb3
* YQL-20234: Support Percentile agg phasesvitya-smirnov2026-05-1815-33/+978
| | | | commit_hash:617264515b5da826be1327cb91b7fc6f6801a835
* YQL-16277: Implement frontend for COMBINE commandimunkin2026-05-132-0/+27
| | | | commit_hash:5a7847c000c3e5ec4cadf6880184d3eebb26d3b1
* YQL-20234: Support RandomValue agg phasesvitya-smirnov2026-05-138-0/+478
| | | | commit_hash:934d9bd00af5903f26796cf610789aaa4a7bf39c
* YQL-21228 fix nulled == over variantsvvvv2026-05-121-0/+3
| | | | commit_hash:72d0f5c9f96875682a71eb11e67783a723112cce
* YQL-21210 new lang vervvvv2026-05-078-13/+8
| | | | commit_hash:23ab69eb08e7c8f74df14dfc43e6109479b8dd15
* YQL-19813: Udf implementationatarasov52026-05-072-2/+4
| | | | commit_hash:183e3a952a021c4701c20d6677800f245239d822
* YQL-21136: Fix AvgIf(Interval64) result typevitya-smirnov2026-05-062-0/+79
| | | | commit_hash:13889e43b6156f11945dcee2ab2b59cdb056ce49
* YQL-20234: Support Corr and Cov agg phasesvitya-smirnov2026-05-0612-0/+656
| | | | commit_hash:cb540d095291ddee3bb60c2d3addee54d23daa1c
* Intermediate changesrobot-piglet2026-05-053-0/+134
| | | | commit_hash:a876b0522ba7aa9c9d4af22e749605f0a57343c2
* YQL-20928: Fix RIGHT JOIN for YqlSelectvitya-smirnov2026-04-309-12/+50
| | | | | | | | | | 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-301-0/+12
| | | | commit_hash:c998ba15db7c4e5137f44904de85755aa7322e8e
* YQL-20928: Support SELECT DISTINCT for YqlSelectvitya-smirnov2026-04-302-5/+23
| | | | commit_hash:af4c180548bf1699ec6afb335167a4220418386c
* YQL-19813: Pass runtime settings to minikql + YT + minirunatarasov52026-04-294-0/+15
| | | | commit_hash:054395f57e37951159c1184eae2e6d4bc81245f8
* YQL-21048: Support Grouping function at YqlSelectvitya-smirnov2026-04-281-0/+20
| | | | | | 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-2824-17/+245
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-231-0/+2
| | | | commit_hash:a201cbc3a08b7bad471d4d6a15f3dfc3f63d989b
* YQL-21034: Convert integers to Uint64 at ListSampleNmariibykova2026-04-205-56/+47
| | | | commit_hash:f508795113ebbfadfb1bc05529f4af46ae7837d2
* Pushdown/fuse Filter + CalcOverWindowaneporada2026-04-206-0/+129
| | | | commit_hash:198ce0c7875d77fab8082382d915bf1261775f68
* YQL-21046: Support window aggregation over YqlSelectvitya-smirnov2026-04-2019-0/+430
| | | | | | | | | 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-173-0/+39
| | | | commit_hash:820e0aec8856d51711fb71caa225cd7d6d89e7a0
* YQL-21165 fixvvvv2026-04-151-1/+1
| | | | commit_hash:ea278625098c2a9c0ad3bfbab7b981d3cc556020
* Intermediate changesrobot-piglet2026-04-1562-62/+0
| | | | commit_hash:9bdeca950e4ca97e07b2da163f014c101189c60b
* YQL-21031: Range decimalatarasov52026-04-1426-6/+347
| | | | commit_hash:836406699a568f3d53cbd91256d586d37bf8f4a9
* YQL-21027: Fix pg value serializationatarasov52026-04-134-4/+8
| | | | commit_hash:9ee085f14c8ce1d9c66c3b1008f71570ea975bf8
* YQL-20873: Range PG supportatarasov52026-04-13120-0/+2048
| | | | commit_hash:9e799ea42a2692eb96ebc792b48e46dd060c182b
* YQL-20773 PositionOf & WithIssuevvvv2026-04-018-0/+29
| | | | commit_hash:fd9981b64488aca88d19a45aa956d80eab220cb8
* YQL-21026: Fix IS DISTINCT from pg and nullatarasov52026-04-013-0/+58
| | | | commit_hash:fb14ee5b8cca07451478bfbffcc9a2f0b3d751f5
* YQL-20234: Fix partial aggregation for Histogram and TopFreqvitya-smirnov2026-03-318-0/+480
| | | | | | `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-3013-0/+308
| | | | | | | | | | | | | | | | | | 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-3016-0/+960
| | | | | | | | | | | | 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-2324-0/+1896
| | | | commit_hash:52386c60ce66e769fe972c72eed82ace0d34242b
* YQL-21068: Fix duplicated preaggregate exprvitya-smirnov2026-03-201-0/+11
| | | | | | | | | | | | 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-21044: Do not use ctx for window funcatarasov52026-03-164-0/+92
| | | | | | | | Оставил `WinCtx` который навешивается на весь стрим внутри партиции. Убрал ctx которые были внутри лямбды Проблема была в том, что сначала инициализировался `pg::sum`, потом он умирал из `WinCtx` внутри `Chain1Map`, потом начиналась новая итерация `Chain1Map` которая снова пыталась обратиться к этому контексту commit_hash:79e5dfa52508aa50c714c21ffb25f8808e1f5362
* Intermediate changesrobot-piglet2026-03-1242-71/+71
| | | | commit_hash:9b0e35dc56f168bc956399baa45cc42a892392ca
* YQL-20998: Remove EmitReadsForExistsvitya-smirnov2026-03-058-14/+1
| | | | | | | Removed a check and usages of `EmitReadsForExists` from the `yql/essentials`. There are a lot of YQLs code recanonized because sometimes an extra block with return was emitted and sometimes is not, but the YQLs is equivalent. commit_hash:a4ec2a575177eff4063da017b4d9ee96e06f3740
* YQL-20969: Derive TSqlTranslation settingsvitya-smirnov2026-03-054-0/+32
| | | | | | This is a step forward to a cleaner `TSqlTranslation`. Now local settings are derived to children and less mutable state is used. commit_hash:17fcb6ad7669e3f3906beeae355df940bbfe5d28
* YQL-21007 new lang vervvvv2026-03-045-5/+7
| | | | commit_hash:f9d592aaafd658d9c44bb4f7299a527c22593569
* YQL-13448: Move to 2026.01 langveratarasov52026-03-0452-52/+52
| | | | commit_hash:2a06f3cce5a5f3c0855906fcfc44690a8af0a609
* YQL-20437,YQL-20999 fixesvvvv2026-03-042-0/+5
| | | | commit_hash:6544bfe8edc1e65a4e7a9e02b37d465b0d4b4ae6
* Intermediate changesrobot-piglet2026-03-033-3/+2
| | | | commit_hash:ee3eb618828d61c8a676898641ff080a749a6b96
* YQL-20904: Support UNION at YqlSelect subqueryvitya-smirnov2026-03-024-0/+25
| | | | | | | | A partial implementation, that accepts only subqueries, matching `select_kind (UNION/EXCEPT/INTERSECT select_kind)*`, so parenthesis are not supported yet and will be added later. Parenthesis support was postponed as they are not used in the TPC-DS benchmark. commit_hash:008ad8857000d1f69e8e8979fa83ab803318a1ae
* Revert YQL-10829: Improve unknown builtin error at JOIN ONvitya-smirnov2026-03-021-1/+1
| | | | | | This patch triggered a lot of QPlayer failures: https://nda.ya.ru/t/BcVGwg9S7VgzFA. This is because https://nda.ya.ru/t/Mh2NOU6z7VgzPH. commit_hash:a2c5f968b0751d785d42db238e59c96499edb417
generated by cgit v1.3 (git 2.53.0) at 2026-06-09 00:17:35 +0000