summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/sql2yql
Commit message (Collapse)AuthorAgeFilesLines
* NormalizeDependsOn pipeline stageziganshinmr2025-07-303-0/+53
| | | | commit_hash:a563966e2448de9828c0786f9ba9939b55fc21fd
* YQL-20216 position aware csse nodesvvvv2025-07-282-0/+22
| | | | commit_hash:78445e1b3b0bb001e0d08b36fd4d31bcd9e37eb4
* YQL-19200: Return persistable expression from FLATTEN BY clauselambda-delta2025-07-255-0/+100
| | | | | Return persistable expression from FLATTEN BY clause commit_hash:8b19ad7f7ddf436c2741f9aa1c5402732fc31f06
* YQL-20230: Handle singular types in DoConvertScalaratarasov52025-07-232-0/+78
| | | | commit_hash:c22dc757dcd7996bac8fb892184281503a2ab003
* YQL-20205 added struct type validationvvvv2025-07-232-0/+16
| | | | | init commit_hash:beef3d18a5b85dc793380a01249358243137df70
* YQL-20197: fix FilterOverAggregate when predicate uses all fieldslucius2025-07-222-0/+34
| | | | | Оказалось что пушдаун предиката через Aggregate не работал когда в предикате используются все поля из Aggregate. Чиню commit_hash:c2e8cab88a0adb496464b9dac52807fcc95f433d
* YQL-19896: allow optional side in SingleInputPredicatePushdownOverEquiJoin ↵lucius2025-07-212-0/+187
| | | | | | | | | | | | | | | in some cases Разрешаем пушить на необязательную сторону предикат, который использует только ключевые колонки с обязательной стороны джоина. 1) рассматриваемый предикат зависит только 1 стороны и это обязательная сторона джоина 2) предикат зависит только от ключевых колонок джоина 3) все соответствующие по ключу джоина колонки в обязательном  и необязательном инпутах должны полностью совпадать по типу В этих случаях мы пушим предикат не только на обязательную, но и на необязательную сторону commit_hash:1404e877fdd271dbe8342478a20b99b6f99a4fda
* Intermediate changesrobot-piglet2025-07-172-0/+23
| | | | commit_hash:50d34a5b1e277a0ff5dce83a9cf485e2c0d1a471
* Fix 'Member over renaming FlatMap' optimizeraneporada2025-07-152-0/+17
| | | | commit_hash:589383be883e0948cdf7db8928c5842d60c5c628
* YQL-20171: Fix aggregation joining keyvitya-smirnov2025-07-152-0/+56
| | | | | | | | | | | | | | | | There was a bug with a aggregation deduplication by a column at the translator. For a single column the system joining all aggregations using the generic key. The generic key was just a column name without source name what leads to collision when aggregating multiple different sources with same column names. This patch fixes the generic key by adding a data source name there. Also tests are added. commit_hash:1c0a9da512f68c58d2830e096de76b769b733cb2
* YQL-17269: Fix UNION/EXCEPT/INTERSECT precedencevitya-smirnov2025-07-131-5/+5
| | | | | | | There was a mistake, because actually EXCEPT has the same precedence as UNION. INTERSECT has higher precedence than. commit_hash:20375ef498861c6704571161fa3c4eebf54e895c
* YQL-20125 fixvvvv2025-07-112-0/+60
| | | | commit_hash:f51c77dc72df30e1a870e784f99b1e8148e6cedb
* YQL-20121 fixvvvv2025-07-102-0/+48
| | | | commit_hash:f5827e9ccc7926e7d8a7ed8040c3d3427b8ef592
* YQL-19896 allow onlyKeys=true in FilterPushdownOverJoinOptionalSidelucius2025-07-102-0/+40
| | | | | Сейчас FilterPushdownOverJoinOptionalSide не работает если в предикате используются только колонки из ключа джоина — причин так делать нет, исправляю (под флагом временно чтобы канонизировать тесты ydb) commit_hash:93aa956e4460d95e9e8592595de5e8a77027786b
* YQL-20167 canonized short key contentvvvv2025-07-104-0/+110
| | | | commit_hash:0cc244f5272c4bc099db5bf8fb56566a11391158
* YQL-20170 fixvvvv2025-07-092-0/+28
| | | | commit_hash:2c408c6ee755878a488f1591510d196d1bf5fba1
* YQL-17269: Support UNION/INTERSECT/EXCEPT combinationsvitya-smirnov2025-07-096-0/+404
| | | | | | | | | | | | Introduce `UNION` and `INTERSECT/EXCEPT` grammar rules for precedence. Rewrote `Build` procedure into `BuildStmt`, `BuildUnion`, `BuildIntersection`. Added tests, modify format. It took a lot of time trying to adapt the existing `Build` procedure. The I noticed that the logic for `union` and `intersection` is different, since `union` groups arguments into bundles, but `intersection` is a strictly binary operation. commit_hash:70008ae3c2603364b6dfbeeb189fdc7f5237433d
* Fix pruneKeys over flatMapmpereskokova2025-07-082-0/+40
| | | | commit_hash:cff54a61ed3e2bccb0914d089c0e3d1f33931449
* YQL-19536: Block ifpresentatarasov52025-07-0810-0/+260
| | | | commit_hash:15146ac1817e0abc0483b2c138207daf3b63fdd5
* YQL-20153 params fixesvvvv2025-07-043-0/+38
| | | | commit_hash:6a71bff1ad52eddd1b8c7d516f0810f0decf401e
* YQL-20085: fix FilterPushdownOverJoinOptionalSidelucius2025-07-043-0/+135
| | | | | | | | | | | | | | Тут чинятся 2 проблемы: 1) Rename settings во вложенных джоинах после преобразования не позволяли применить пропушенный предикат, что-нибудь типа "Unknown table name:… Failed to parse labels of struct…" 2) Если до пушдауна типизатор вывел distinct у джоина, а мы его заменили на union all, то типизатор не мог доказать что distinct сохранился и падал. Типизатор править не стали, решили через KeepUniqueDistinct. Обе проблемы немного по-разному проявляются и чинятся в двух случаях: 1) Делаем пушдаун в инпут из последнего джоина (верхний/корневой в дереве) — исходный джоин заменяется на union all из двух джоинов 2) Пушдаун в инпут НЕ из последнего джоина (НЕ верхний/корневой в дереве) — union all появляется внутри "исходного" джоина commit_hash:cc7cfbb973bc7dcabba202ab9a637c3b9f1cb5dd
* YQL-20126 fixvvvv2025-07-042-0/+16
| | | | commit_hash:9a7d4b30d4dd2a5d2fa2d9bd9e34c5153196d288
* Do not generate empty Or in ExtractCommonPredicatesFromLogicalOpsaneporada2025-06-262-0/+22
| | | | commit_hash:7a57d8950e16c8237574833f4289a25ed54226bf
* YQL-17269: support PositionalUnionAll for INTERSECT and EXCEPTkndrvt2025-06-235-0/+368
| | | | commit_hash:4c68311d9e875b6643dd49aae1c385aace4ca978
* YQL-17269: support INTERSECT and EXCEPT without PositionalUnionAllkndrvt2025-06-2010-10/+447
| | | | commit_hash:632e24794e8bcf6ef0502b7e8c031e964d28d36a
* DropAnyOverDistinctEquiJoinInput optimizerziganshinmr2025-06-192-0/+255
| | | | commit_hash:f3a7045b9ba62617929a3d5ad882c9dd2702f2eb
* Add PruneKeys in YT optmpereskokova2025-06-181-0/+7
| | | | commit_hash:b12d341458bb39ffb6b4a4d7a99c3ef25a417ca5
* YQL-20079 drop optimizervvvv2025-06-162-0/+20
| | | | commit_hash:c94ae2e1918d822a6a01192bc2e42d668cf16b4d
* Intermediate changesrobot-piglet2025-06-161-0/+1
| | | | commit_hash:6e56cbea6a1c12b4f9e6b065eedf177763a329d2
* YQL-20054: Fix pg typesatarasov52025-06-062-0/+24
| | | | commit_hash:b0bb9ec1e8b00c8383d182b073073d6eaf04ab2f
* Fix block coalesce for multioptionalatarasov52025-06-062-0/+24
| | | | commit_hash:a9766abf73088d74351c34d5136a3eeb7191ac04
* Save distinct constraint for PruneKeysmpereskokova2025-06-032-0/+58
| | | | commit_hash:c571530f0a74edc44a65da0388e8e4c543121044
* YQL-17269: add DISTINCT to UNIONkndrvt2025-05-272-0/+20
| | | | commit_hash:d002e9690bd7cbd1874fdbfe454c9f7a00256839
* YQL-19974 fixed handling error type in UnionAllvvvv2025-05-202-0/+25
| | | | commit_hash:9aaecf82f8c99c7576eedbfc43572a8722ea774d
* YQL-19945 track stack frames for evaluationvvvv2025-05-152-0/+23
| | | | | init commit_hash:6e66d6ead6f0f91a4a60c3ed283dd7800638124a
* YQL-19929 explicit frames for issue scopes (need to recanonize some warnings)vvvv2025-05-082-0/+28
| | | | | xfail тесты udf тоже требуют переканонизации commit_hash:ce4ba148ea6f57536e6b674b4f2f8b7a36737bbb
* Fix FilterPushDownJoinOverJoinOptionalSide parent join is a Cross join aka ↵deniskhalikov2025-05-052-0/+55
| | | | | | TPCDS49 commit_hash:4f17c967af68dec9e71fc475a9e08cc5a10f7b7f
* ANSI SqlIn peephole fixesziganshinmr2025-04-302-0/+27
| | | | commit_hash:0b9dce1e145a3841b5c1a63d7feb3868d3d25b06
* Primitives for case insensitive simple pattern matchzverevgeny2025-04-252-0/+63
| | | | commit_hash:5f4bdb090c2f60459073e3e95ccd39ec58b95232
* Intermediate changesrobot-piglet2025-04-242-0/+57
| | | | commit_hash:b561940fa34bb32aa7a67fa8522fb39ffe55d141
* Intermediate changesrobot-piglet2025-04-241-1/+0
| | | | commit_hash:dc3193604b8e3f1c1a2e012318f542b2497d7638
* YQL-19845 CurrentLanguageVersion funcvvvv2025-04-222-4/+5
| | | | commit_hash:2af511a18740c931b471dc1f2ff36a8b4ce573a8
* YQL-19864 sql flag + test with explicit flag & by versionvvvv2025-04-173-0/+48
| | | | commit_hash:902cfa0c1b574c1addb5df96a4b38c792ae82258
* Add pruneKeys in EquiJoinmpereskokova2025-04-173-3/+261
| | | | commit_hash:24b52143fbef864df48f3359b14f9e0294f367f5
* YQL-19808 Union typecheck fixedvvvv2025-04-112-0/+19
| | | | commit_hash:ae4906152eff58ea40b78325ebbfe04c5685e991
* YQL-19790 allow distinct over keysvvvv2025-04-102-0/+27
| | | | commit_hash:5f778a5600a05b527c9ff0b07dcf55e207782165
* Fix keeping aggregate columns in case of distinct aggregation over windowziganshinmr2025-04-082-0/+31
| | | | commit_hash:6aa8a8297542455d107d7debbfaac3f30f48d885
* Fix DISTINCT over window over joinziganshinmr2025-04-012-0/+36
| | | | commit_hash:d7101ec6fbc95dde360e2a18ac52159dd4535764
* YQL-18303: Adjust implicit cast rules between Datetime typesimunkin2025-03-205-0/+252
| | | | | Follows up 16a38d1b1de0cc97c5cbf97176331ea6691e23be commit_hash:4d702692f7441dc95f2874f80f6618043b73c816
* YQL-19739 better errors for initial parameters validationvvvv2025-03-192-0/+18
| | | | commit_hash:67d1188f3d667d7c3355c17d9a1adefe2adb2a6e
generated by cgit v1.3 (git 2.53.0) at 2026-07-24 09:25:18 +0000