diff options
| author | atarasov5 <[email protected]> | 2025-08-28 14:59:55 +0300 |
|---|---|---|
| committer | atarasov5 <[email protected]> | 2025-08-28 15:45:33 +0300 |
| commit | 642fe48387994c15621318e16f98eac8d11a301c (patch) | |
| tree | f362d0234fe8e4e263bc5b8ad64b12788a6b7039 /yql/essentials/tests/sql/suites | |
| parent | 81d828c32c8d5477cb2f0ce5da06a1a8d9392ca3 (diff) | |
YQL-20340: Fix getelem comp node
commit_hash:4b93115d4e3d46770946a7a462c7413d6183282f
Diffstat (limited to 'yql/essentials/tests/sql/suites')
8 files changed, 293 insertions, 0 deletions
diff --git a/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged.yql b/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged.yql new file mode 100644 index 00000000000..a41c326b395 --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged.yql @@ -0,0 +1,25 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: ( + 1, + just(2), + NULL, + Nothing(Int32?), + Nothing(pgint4) + ) + |> +]; + +SELECT + x.0, + x.1, + x.2, + x.3, + x.4 +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged_no_cache.yql b/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged_no_cache.yql new file mode 100644 index 00000000000..6854c668c55 --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/nth_no_optional_no_tagged_no_cache.yql @@ -0,0 +1,45 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: ( + 1, + just(2), + NULL, + Nothing(Int32?), + Nothing(pgint4) + ) + |> +]; + +SELECT + x.0, +FROM + AS_TABLE($data) +; + +SELECT + x.1, +FROM + AS_TABLE($data) +; + +SELECT + x.2, +FROM + AS_TABLE($data) +; + +SELECT + x.3, +FROM + AS_TABLE($data) +; + +SELECT + x.4, +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/nth_no_tagged.yql b/yql/essentials/tests/sql/suites/expr/nth_no_tagged.yql new file mode 100644 index 00000000000..3f3137b6f28 --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/nth_no_tagged.yql @@ -0,0 +1,28 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: Just( + ( + 1, + just(2), + NULL, + Nothing(Int32?), + Nothing(pgint4) + ) + ) + |>, + <|x: NULL|> +]; + +SELECT + x.0, + x.1, + x.2, + x.3, + x.4 +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/nth_no_tagged_no_cache.yql b/yql/essentials/tests/sql/suites/expr/nth_no_tagged_no_cache.yql new file mode 100644 index 00000000000..ede2ce839ae --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/nth_no_tagged_no_cache.yql @@ -0,0 +1,48 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: Just( + ( + 1, + just(2), + NULL, + Nothing(Int32?), + Nothing(pgint4) + ) + ) + |>, + <|x: NULL|> +]; + +SELECT + x.0, +FROM + AS_TABLE($data) +; + +SELECT + x.1, +FROM + AS_TABLE($data) +; + +SELECT + x.2, +FROM + AS_TABLE($data) +; + +SELECT + x.3, +FROM + AS_TABLE($data) +; + +SELECT + x.4, +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/tagged_nth.yql b/yql/essentials/tests/sql/suites/expr/tagged_nth.yql new file mode 100644 index 00000000000..ab05dc9b0cb --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/tagged_nth.yql @@ -0,0 +1,28 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: Just( + ( + AsTagged(1, 'A'), + AsTagged(just(2), 'B'), + AsTagged(NULL, 'C'), + AsTagged(Nothing(Int32?), 'D'), + AsTagged(Nothing(pgint4), 'E') + ) + ) + |>, + <|x: NULL|> +]; + +SELECT + x.0, + x.1, + x.2, + x.3, + x.4 +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/tagged_nth_no_cache.yql b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_cache.yql new file mode 100644 index 00000000000..0e7b8185e5d --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_cache.yql @@ -0,0 +1,49 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: Just( + ( + AsTagged(1, 'A'), + AsTagged(just(2), 'B'), + AsTagged(NULL, 'C'), + AsTagged(Nothing(Int32?), 'D'), + AsTagged(Nothing(pgint4), 'E') + ) + ) + |>, + <|x: NULL|> +]; + +SELECT + x.0, +FROM + AS_TABLE($data) +; + +SELECT + x.1, +FROM + AS_TABLE($data) +; + +SELECT + x.2, +FROM + AS_TABLE($data) +; + +SELECT + x.3, +FROM + AS_TABLE($data) +; + +SELECT + x.4, +FROM + AS_TABLE($data) +; + diff --git a/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional.yql b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional.yql new file mode 100644 index 00000000000..678d6b2e44f --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional.yql @@ -0,0 +1,25 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: ( + AsTagged(1, 'A'), + AsTagged(just(2), 'B'), + AsTagged(NULL, 'C'), + AsTagged(Nothing(Int32?), 'D'), + AsTagged(Nothing(pgint4), 'E') + ) + |> +]; + +SELECT + x.0, + x.1, + x.2, + x.3, + x.4 +FROM + AS_TABLE($data) +; diff --git a/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional_no_cache.yql b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional_no_cache.yql new file mode 100644 index 00000000000..cb0e7470e5b --- /dev/null +++ b/yql/essentials/tests/sql/suites/expr/tagged_nth_no_optional_no_cache.yql @@ -0,0 +1,45 @@ +/* postgres can not */ +pragma EmitAggApply; +pragma EmitTableSource; + +$data = [ + <| + x: ( + AsTagged(1, 'A'), + AsTagged(just(2), 'B'), + AsTagged(NULL, 'C'), + AsTagged(Nothing(Int32?), 'D'), + AsTagged(Nothing(pgint4), 'E') + ) + |> +]; + +SELECT + x.0, +FROM + AS_TABLE($data) +; + +SELECT + x.1, +FROM + AS_TABLE($data) +; + +SELECT + x.2, +FROM + AS_TABLE($data) +; + +SELECT + x.3, +FROM + AS_TABLE($data) +; + +SELECT + x.4, +FROM + AS_TABLE($data) +; |