aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql
Commit message (Collapse)AuthorAgeFilesLines
* YQL-20125 fixvvvv5 days4-0/+113
| | | | commit_hash:f51c77dc72df30e1a870e784f99b1e8148e6cedb
* YQL-20121 fixvvvv6 days4-0/+66
| | | | commit_hash:f5827e9ccc7926e7d8a7ed8040c3d3427b8ef592
* YQL-19896 allow onlyKeys=true in FilterPushdownOverJoinOptionalSidelucius7 days4-0/+77
| | | | | Сейчас FilterPushdownOverJoinOptionalSide не работает если в предикате используются только колонки из ключа джоина — причин так делать нет, исправляю (под флагом временно чтобы канонизировать тесты ydb) commit_hash:93aa956e4460d95e9e8592595de5e8a77027786b
* YQL-20167 canonized short key contentvvvv7 days10-0/+208
| | | | commit_hash:0cc244f5272c4bc099db5bf8fb56566a11391158
* YQL-20170 fixvvvv7 days5-0/+55
| | | | commit_hash:2c408c6ee755878a488f1591510d196d1bf5fba1
* YQL-17269: Support UNION/INTERSECT/EXCEPT combinationsvitya-smirnov7 days17-0/+532
| | | | | | | | | | | | 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
* YQL-20080: flow -> stream rewriteatarasov58 days1-3/+3
| | | | | | | | В этом пре переписал ноды `Wide{Top,TopSort,Sort}Blocks` с flow на stream реализацию. Я разбил пр на два коммита: первый, это просто двигаю классы вверх вниз. Второй - сами изменения. [Прогон тестов](https://nda.ya.ru/t/P9kfAmHr7GFmgy с понижением Runtime версии commit_hash:0813a74aaa904b12846692c0e7504334170ea6db
* Fix pruneKeys over flatMapmpereskokova8 days4-0/+69
| | | | commit_hash:cff54a61ed3e2bccb0914d089c0e3d1f33931449
* YQL-19536: Block ifpresentatarasov59 days25-0/+557
| | | | commit_hash:15146ac1817e0abc0483b2c138207daf3b63fdd5
* YQL-20153 params fixesvvvv12 days11-0/+84
| | | | commit_hash:6a71bff1ad52eddd1b8c7d516f0810f0decf401e
* YQL-20085: fix FilterPushdownOverJoinOptionalSidelucius13 days7-0/+267
| | | | | | | | | | | | | | Тут чинятся 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 fixvvvv13 days4-0/+32
| | | | commit_hash:9a7d4b30d4dd2a5d2fa2d9bd9e34c5153196d288
* Do not generate empty Or in ExtractCommonPredicatesFromLogicalOpsaneporada2025-06-264-0/+41
| | | | commit_hash:7a57d8950e16c8237574833f4289a25ed54226bf
* YQL-17269: coherent EXCEPT DISTINCT behaviour with PostgreSQLkndrvt2025-06-243-21/+21
| | | | commit_hash:612ca36961d59bab6ffd93ee882f538b3e0d7bda
* YQL-17269: support PositionalUnionAll for INTERSECT and EXCEPTkndrvt2025-06-2312-0/+744
| | | | commit_hash:4c68311d9e875b6643dd49aae1c385aace4ca978
* YQL-17269: support INTERSECT and EXCEPT without PositionalUnionAllkndrvt2025-06-2026-10/+885
| | | | commit_hash:632e24794e8bcf6ef0502b7e8c031e964d28d36a
* DropAnyOverDistinctEquiJoinInput optimizerziganshinmr2025-06-194-0/+387
| | | | commit_hash:f3a7045b9ba62617929a3d5ad882c9dd2702f2eb
* Add PruneKeys in YT optmpereskokova2025-06-181-0/+7
| | | | commit_hash:b12d341458bb39ffb6b4a4d7a99c3ef25a417ca5
* YQL-20073 type diff for TryConvertvvvv2025-06-171-3/+3
| | | | | | | better convert error test for reproducing commit_hash:c20630a1f03ea1eed119778895b19087143f4400
* YQL-20079 drop optimizervvvv2025-06-164-0/+38
| | | | commit_hash:c94ae2e1918d822a6a01192bc2e42d668cf16b4d
* Intermediate changesrobot-piglet2025-06-161-4/+0
| | | | commit_hash:18e311c0ad94b55003cb5a6c0487a16830fac5cd
* Intermediate changesrobot-piglet2025-06-161-0/+1
| | | | commit_hash:6e56cbea6a1c12b4f9e6b065eedf177763a329d2
* Improve OptimizeSubsetFieldsForNodeWithMultiUsage for Optionalsaneporada2025-06-091-6/+6
| | | | commit_hash:44ab80a72c410e6d0afbb4a8cb818ce01426115e
* YQL-20054: Fix pg typesatarasov52025-06-064-0/+53
| | | | commit_hash:b0bb9ec1e8b00c8383d182b073073d6eaf04ab2f
* Fix block coalesce for multioptionalatarasov52025-06-064-0/+52
| | | | commit_hash:a9766abf73088d74351c34d5136a3eeb7191ac04
* Save distinct constraint for PruneKeysmpereskokova2025-06-034-0/+94
| | | | commit_hash:c571530f0a74edc44a65da0388e8e4c543121044
* YQL-17269: add DISTINCT to UNIONkndrvt2025-05-274-0/+41
| | | | commit_hash:d002e9690bd7cbd1874fdbfe454c9f7a00256839
* YQL-19974 fixed handling error type in UnionAllvvvv2025-05-204-0/+46
| | | | commit_hash:9aaecf82f8c99c7576eedbfc43572a8722ea774d
* YQL-19945 track stack frames for evaluationvvvv2025-05-154-0/+33
| | | | | init commit_hash:6e66d6ead6f0f91a4a60c3ed283dd7800638124a
* YQL-19929 explicit frames for issue scopes (need to recanonize some warnings)vvvv2025-05-0833-134/+177
| | | | | xfail тесты udf тоже требуют переканонизации commit_hash:ce4ba148ea6f57536e6b674b4f2f8b7a36737bbb
* Fix FilterPushDownJoinOverJoinOptionalSide parent join is a Cross join aka ↵deniskhalikov2025-05-054-0/+112
| | | | | | TPCDS49 commit_hash:4f17c967af68dec9e71fc475a9e08cc5a10f7b7f
* ANSI SqlIn peephole fixesziganshinmr2025-04-304-0/+51
| | | | commit_hash:0b9dce1e145a3841b5c1a63d7feb3868d3d25b06
* YQL-19901: Fix TestBit for string argumentimunkin2025-04-251-3/+3
| | | | commit_hash:8ca44c4f80502be7e9c4c970f05b64ad9b50b13f
* Primitives for case insensitive simple pattern matchzverevgeny2025-04-257-0/+140
| | | | commit_hash:5f4bdb090c2f60459073e3e95ccd39ec58b95232
* Intermediate changesrobot-piglet2025-04-244-0/+116
| | | | commit_hash:b561940fa34bb32aa7a67fa8522fb39ffe55d141
* Intermediate changesrobot-piglet2025-04-242-2/+0
| | | | commit_hash:dc3193604b8e3f1c1a2e012318f542b2497d7638
* Enable FilterNullMembersOverJust by defaultaneporada2025-04-242-6/+6
| | | | commit_hash:a97752fe47c21a472a780e6b2097cd7c20c63766
* Enable MemberNthOverFlatMap by defaultaneporada2025-04-222-6/+6
| | | | commit_hash:5117342b91cba57f7c45d262b1c95aea6a65061a
* YQL-19845 CurrentLanguageVersion funcvvvv2025-04-224-11/+13
| | | | commit_hash:2af511a18740c931b471dc1f2ff36a8b4ce573a8
* YQL-19864 sql flag + test with explicit flag & by versionvvvv2025-04-179-4/+96
| | | | commit_hash:902cfa0c1b574c1addb5df96a4b38c792ae82258
* Add pruneKeys in EquiJoinmpereskokova2025-04-177-9/+334
| | | | commit_hash:24b52143fbef864df48f3359b14f9e0294f367f5
* YQL-19808 Union typecheck fixedvvvv2025-04-114-0/+25
| | | | commit_hash:ae4906152eff58ea40b78325ebbfe04c5685e991
* YQL-19790 allow distinct over keysvvvv2025-04-104-0/+45
| | | | commit_hash:5f778a5600a05b527c9ff0b07dcf55e207782165
* Fix keeping aggregate columns in case of distinct aggregation over windowziganshinmr2025-04-084-0/+63
| | | | commit_hash:6aa8a8297542455d107d7debbfaac3f30f48d885
* Fix DISTINCT over window over joinziganshinmr2025-04-014-0/+68
| | | | commit_hash:d7101ec6fbc95dde360e2a18ac52159dd4535764
* YQL-19645: Optimize block coalesceatarasov52025-03-271-1/+1
| | | | commit_hash:b9c6d56b79b71389a1198d54c6ce6c2022420182
* YQL-18303: Adjust implicit cast rules between Datetime typesimunkin2025-03-2012-0/+493
| | | | | Follows up 16a38d1b1de0cc97c5cbf97176331ea6691e23be commit_hash:4d702692f7441dc95f2874f80f6618043b73c816
* YQL-19739 better errors for initial parameters validationvvvv2025-03-194-0/+23
| | | | commit_hash:67d1188f3d667d7c3355c17d9a1adefe2adb2a6e
* Introduce PruneKeys Callablesmpereskokova2025-03-194-0/+162
| | | | commit_hash:ca25a6ece5ae902c4b93846f69bc33b6336a669c
* Intermediate changesrobot-piglet2025-03-191-0/+1
| | | | commit_hash:50f35111dfe21322f7d24f449ffb9d644521d601