summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/aggregate
Commit message (Collapse)AuthorAgeFilesLines
* YQL-21365: Fix TLangVerProxyNode::Clonevitya-smirnov2026-07-032-0/+11
| | | | | | | | | | | #### Fix TLangVerProxyNode::Clone and add related test cases ✎ - Corrected the `Clone` method implementation to properly handle deep copying of inner nodes using `SafeClone`, ensuring correct node duplication behavior. - Introduced new test cases and canonical data to validate the functionality of `GROUP BY ROLLUP` with `NULLIF` and `COUNT(DISTINCT)` expressions. - Added corresponding test configuration and SQL format validation files to support the new test scenario. <a href="https://nda.ya.ru/t/qa0kX64r7DqvtN"><font size="2">Autodescription by Yandex Code Assistant</font></a> commit_hash:2f81ec1dbc9dd24149f8553a87e915809c800a74
* Intermediate changesrobot-piglet2026-06-255-5/+0
| | | | commit_hash:da9e5d384dc00d37d939afe28f789f2f608acb0e
* Intermediate changesrobot-piglet2026-06-2512-12/+0
| | | | commit_hash:d17bed0c3f0053f8f24a0e6f3053213ed5fbf423
* Intermediate changesrobot-piglet2026-06-2412-12/+0
| | | | commit_hash:16b28b4a2fa4a98d0bef3efe97d563373903df25
* YQL-21321 don't check for persistable in agg traits typecheckvvvv2026-06-171-0/+4
| | | | | | | | | | | #### `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
* YQL-21297: Handle Interval64 in aggregate/windowvitya-smirnov2026-06-102-0/+2
| | | | commit_hash:10c8d54083c7064e63989ad9c341711fe84409b4
* YQL-21136: Fix AvgIf(Interval64) result typevitya-smirnov2026-05-061-0/+4
| | | | commit_hash:13889e43b6156f11945dcee2ab2b59cdb056ce49
* 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-20568: Add PRAGMA FailOnNonPersistableFlattenAndAggrExprsvitya-smirnov2026-02-192-0/+22
| | | | | | This is necessary to give users an opportunity to check whether the behavior of a query is changed. commit_hash:e6bfa8c3ee1612c05b124cb798ebf1b95449f88c
* YQL-19673: Realizationmrlolthe1st2025-11-026-0/+17
| | | | commit_hash:68fcce49bf7355e49569a96ff7ad2faa537c563e
* Intermediate changesrobot-piglet2025-10-0310-0/+10
| | | | commit_hash:c3c929f4005b33d2fddb492bbc2c553125d9ad40
* Intermediate changesrobot-piglet2025-08-1321-0/+0
| | | | commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972
* YQL-19200: Return persistable expression from FLATTEN BY clauselambda-delta2025-07-254-0/+12
| | | | | Return persistable expression from FLATTEN BY clause commit_hash:8b19ad7f7ddf436c2741f9aa1c5402732fc31f06
* YQL-20197: fix FilterOverAggregate when predicate uses all fieldslucius2025-07-221-0/+22
| | | | | Оказалось что пушдаун предиката через Aggregate не работал когда в предикате используются все поля из Aggregate. Чиню commit_hash:c2e8cab88a0adb496464b9dac52807fcc95f433d
* YQL-20171: Fix aggregation joining keyvitya-smirnov2025-07-151-0/+10
| | | | | | | | | | | | | | | | 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-20121 fixvvvv2025-07-101-0/+4
| | | | commit_hash:f5827e9ccc7926e7d8a7ed8040c3d3427b8ef592
* YQL-20170 fixvvvv2025-07-092-0/+13
| | | | commit_hash:2c408c6ee755878a488f1591510d196d1bf5fba1
* YQL-19929 explicit frames for issue scopes (need to recanonize some warnings)vvvv2025-05-082-0/+12
| | | | | xfail тесты udf тоже требуют переканонизации commit_hash:ce4ba148ea6f57536e6b674b4f2f8b7a36737bbb
* YQL-19864 sql flag + test with explicit flag & by versionvvvv2025-04-173-0/+8
| | | | commit_hash:902cfa0c1b574c1addb5df96a4b38c792ae82258
* YQL-19790 allow distinct over keysvvvv2025-04-101-0/+4
| | | | commit_hash:5f778a5600a05b527c9ff0b07dcf55e207782165
* MR: aggregation in MEASURESvokayndzop2025-01-291-0/+14
| | | | commit_hash:5357736eed7a221ff5844d4351abe23e65930632
* Intermediate changesrobot-piglet2025-01-241-0/+9
| | | | commit_hash:821873ed79a58bc9db93f62564a7c6aeb50608de
* Intermediate changesrobot-piglet2024-12-272-0/+71
| | | | commit_hash:170e724b371baded6fdcbc5f6b63da52252c1598
* Intermediate changesrobot-piglet2024-12-26294-2172/+0
| | | | commit_hash:d6e69042088451340ac37dd3d928f2cb483a54e9
* Intermediate changesrobot-piglet2024-12-141-1/+1
| | | | commit_hash:477d798c3142fdd3f07c678a8fde0b0a089a086a
* pragma yt.CompactForDistinctorlovorlov2024-12-114-0/+33
| | | | commit_hash:78c474deede40e17d0afc94e3ad796c2ba3f02d7
* Check custom error in xfail tests. Remove canonization from dq/hybrid testsudovichenko-r2024-11-231-2/+1
| | | | | | | | | | | | | | | 1. xfail тесты теперь должны содержать спец комментарий `custom error` с ожидаемым текстом ошибки 2. Все suites для xfail размечены спец. коментариями, некоторые тесты разбиты на несколько 3. Включены тесты с Python и Javascript udf для yt провайдера и переканонизированы (были отключены в github) 4. Для тяжелых xfail тестов аналогично убрана канонизация и включена проверка по спец. коментарию 5. Из dq_file/hybrid тестов убрана канонизация. Осталась только кросс-проверка результатов с yqlrun и блочным режимом 6. В dqrun теперь используется exception_policy вместо fail_policy (для корректной выдачи ошибок в тестах) commit_hash:a92b3835f86b0c01225e81e3f28bb6d11d8d67a3
* Fix filter pushdown over Aggregate with session/hopping windowaneporada2024-11-212-0/+16
| | | | commit_hash:3d4989f7a92e9b330cd4b19f1850cdca544a1d64
* YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> ↵udovichenko-r2024-11-19301-0/+2368
yql/essentials/tests/sql/suites commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00