diff options
| author | robot-piglet <[email protected]> | 2024-12-27 12:59:19 +0300 |
|---|---|---|
| committer | robot-piglet <[email protected]> | 2024-12-27 13:12:33 +0300 |
| commit | c7a2519eaf60067fe973fc27f3f0c3c7d943bae9 (patch) | |
| tree | 0d59847bdc681d374545fdfd0c7989f2f5a98e29 /yql/essentials/tests/sql/suites/agg_apply | |
| parent | 27df3d52304f343a3e9e87aa36b014a7a442f94e (diff) | |
Intermediate changes
commit_hash:170e724b371baded6fdcbc5f6b63da52252c1598
Diffstat (limited to 'yql/essentials/tests/sql/suites/agg_apply')
18 files changed, 132 insertions, 0 deletions
diff --git a/yql/essentials/tests/sql/suites/agg_apply/avg_decimal.sql b/yql/essentials/tests/sql/suites/agg_apply/avg_decimal.sql new file mode 100644 index 00000000000..96f49ebf5d0 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/avg_decimal.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + avg(key) +FROM (values (Decimal("0.1",10,1)),(Decimal("0.2",10,1)),(Decimal("0.3",10,1))) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/avg_interval.sql b/yql/essentials/tests/sql/suites/agg_apply/avg_interval.sql new file mode 100644 index 00000000000..d87106a9912 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/avg_interval.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + avg(key) +FROM (values (Interval("P1D")),(Interval("P2D")),(Interval("P3D"))) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/avg_numeric.sql b/yql/essentials/tests/sql/suites/agg_apply/avg_numeric.sql new file mode 100644 index 00000000000..8e5ae7410c1 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/avg_numeric.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + avg(key) +FROM (values (1),(2),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/avg_numeric_opt.sql b/yql/essentials/tests/sql/suites/agg_apply/avg_numeric_opt.sql new file mode 100644 index 00000000000..7f1249d119a --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/avg_numeric_opt.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + avg(key) +FROM (values (1),(null),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/avg_state_type.sql b/yql/essentials/tests/sql/suites/agg_apply/avg_state_type.sql new file mode 100644 index 00000000000..67e79977569 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/avg_state_type.sql @@ -0,0 +1,13 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +select +formattype(typeof(avg(null))), +formattype(typeof(avg(1))), +formattype(typeof(avg(decimal("10",10,1)))), +formattype(typeof(avg(interval("P10D")))), +formattype(typeof(avg(just(1)))), +formattype(typeof(avg(just(decimal("10",10,1))))), +formattype(typeof(avg(just(interval("P10D"))))) +from (select 1) group by () with combine
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/count.sql b/yql/essentials/tests/sql/suites/agg_apply/count.sql new file mode 100644 index 00000000000..4d2917715e6 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/count.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + count(*),count(key) +FROM (values (1),(null),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/max.sql b/yql/essentials/tests/sql/suites/agg_apply/max.sql new file mode 100644 index 00000000000..70895a37807 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/max.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + max(key) +FROM (values (1),(2),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/min.sql b/yql/essentials/tests/sql/suites/agg_apply/min.sql new file mode 100644 index 00000000000..60b25ff5c54 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/min.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + min(key) +FROM (values (1),(2),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/opt_sum_divide_by_zero.sql b/yql/essentials/tests/sql/suites/agg_apply/opt_sum_divide_by_zero.sql new file mode 100644 index 00000000000..15236cd2ff9 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/opt_sum_divide_by_zero.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(1/0) +FROM (values (1),(null),(3)) as a(key) diff --git a/yql/essentials/tests/sql/suites/agg_apply/opt_sum_null.sql b/yql/essentials/tests/sql/suites/agg_apply/opt_sum_null.sql new file mode 100644 index 00000000000..c2086f7f5be --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/opt_sum_null.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(null) +FROM (values (1),(null),(3)) as a(key) diff --git a/yql/essentials/tests/sql/suites/agg_apply/some_notnull.sql b/yql/essentials/tests/sql/suites/agg_apply/some_notnull.sql new file mode 100644 index 00000000000..7e3cd4fb3ce --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/some_notnull.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + some(key) +FROM (values (1)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/some_null.sql b/yql/essentials/tests/sql/suites/agg_apply/some_null.sql new file mode 100644 index 00000000000..2bf12e30d91 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/some_null.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + some(key) +FROM (values (null)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_decimal.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_decimal.sql new file mode 100644 index 00000000000..5ba05328dcd --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_decimal.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (CAST("1.51" AS Decimal(10, 3))), (CAST("2.22" AS Decimal(10, 3))), (CAST("3.49" AS Decimal(10, 3)))) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_decimal_null.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_decimal_null.sql new file mode 100644 index 00000000000..75df4277f20 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_decimal_null.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (CAST("1.51" AS Decimal(10, 3))), (null), (CAST("3.49" AS Decimal(10, 3)))) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_double.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_double.sql new file mode 100644 index 00000000000..698e215e5c5 --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_double.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (1.51),(null),(3.49)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_interval.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_interval.sql new file mode 100644 index 00000000000..b08de4bb54e --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_interval.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (cast(1 as Interval)),(null),(cast(3 as Interval))) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_signed.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_signed.sql new file mode 100644 index 00000000000..ab731a9042f --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_signed.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (1),(null),(3)) as a(key)
\ No newline at end of file diff --git a/yql/essentials/tests/sql/suites/agg_apply/sum_unsigned.sql b/yql/essentials/tests/sql/suites/agg_apply/sum_unsigned.sql new file mode 100644 index 00000000000..1fb4103665e --- /dev/null +++ b/yql/essentials/tests/sql/suites/agg_apply/sum_unsigned.sql @@ -0,0 +1,7 @@ +/* syntax version 1 */ +/* postgres can not */ +pragma EmitAggApply; + +SELECT + sum(key) +FROM (values (1u),(null),(3u)) as a(key)
\ No newline at end of file |