diff options
author | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
---|---|---|
committer | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
commit | 31773f157bf8164364649b5f470f52dece0a4317 (patch) | |
tree | 33d0f7eef45303ab68cf08ab381ce5e5e36c5240 /yql/essentials/tests/sql/suites/case/case_many_val.sql | |
parent | 2c7938962d8689e175574fc1e817c05049f27905 (diff) | |
parent | eff600952d5dfe17942f38f510a8ac2b203bb3a5 (diff) | |
download | ydb-31773f157bf8164364649b5f470f52dece0a4317.tar.gz |
Merge branch 'rightlib' into mergelibs-241120-1113
Diffstat (limited to 'yql/essentials/tests/sql/suites/case/case_many_val.sql')
-rw-r--r-- | yql/essentials/tests/sql/suites/case/case_many_val.sql | 111 |
1 files changed, 111 insertions, 0 deletions
diff --git a/yql/essentials/tests/sql/suites/case/case_many_val.sql b/yql/essentials/tests/sql/suites/case/case_many_val.sql new file mode 100644 index 0000000000..a5b8642925 --- /dev/null +++ b/yql/essentials/tests/sql/suites/case/case_many_val.sql @@ -0,0 +1,111 @@ +/* syntax version 1 */ +/* yt can not */ +$switch = ($x) -> { + $res = case $x + when 0 then 1 + when 1 then 2 + when 2 then 3 + when 3 then 4 + when 4 then 5 + when 5 then 6 + when 6 then 7 + when 7 then 8 + when 8 then 9 + when 9 then 10 + when 10 then 11 + when 11 then 12 + when 12 then 13 + when 13 then 14 + when 14 then 15 + when 15 then 16 + when 16 then 17 + when 17 then 18 + when 18 then 19 + when 19 then 20 + when 20 then 21 + when 21 then 22 + when 22 then 23 + when 23 then 24 + when 24 then 25 + when 25 then 26 + when 26 then 27 + when 27 then 28 + when 28 then 29 + when 29 then 30 + when 30 then 31 + when 31 then 32 + when 32 then 33 + when 33 then 34 + when 34 then 35 + when 35 then 36 + when 36 then 37 + when 37 then 38 + when 38 then 39 + when 39 then 40 + when 40 then 41 + when 41 then 42 + when 42 then 43 + when 43 then 44 + when 44 then 45 + when 45 then 46 + when 46 then 47 + when 47 then 48 + when 48 then 49 + when 49 then 50 + when 50 then 51 + when 51 then 52 + when 52 then 53 + when 53 then 54 + when 54 then 55 + when 55 then 56 + when 56 then 57 + when 57 then 58 + when 58 then 59 + when 59 then 60 + when 60 then 61 + when 61 then 62 + when 62 then 63 + when 63 then 64 + when 64 then 65 + when 65 then 66 + when 66 then 67 + when 67 then 68 + when 68 then 69 + when 69 then 70 + when 70 then 71 + when 71 then 72 + when 72 then 73 + when 73 then 74 + when 74 then 75 + when 75 then 76 + when 76 then 77 + when 77 then 78 + when 78 then 79 + when 79 then 80 + when 80 then 81 + when 81 then 82 + when 82 then 83 + when 83 then 84 + when 84 then 85 + when 85 then 86 + when 86 then 87 + when 87 then 88 + when 88 then 89 + when 89 then 90 + when 90 then 91 + when 91 then 92 + when 92 then 93 + when 93 then 94 + when 94 then 95 + when 95 then 96 + when 96 then 97 + when 97 then 98 + when 98 then 99 + else 100 + end; + return $res; +}; + +$expected = ListFromRange(1, 101); + +select ListMap(ListFromRange(0, 100), $switch) == $expected; |