case_many_val.sql 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. /* syntax version 1 */
  2. /* yt can not */
  3. $switch = ($x) -> {
  4. $res = case $x
  5. when 0 then 1
  6. when 1 then 2
  7. when 2 then 3
  8. when 3 then 4
  9. when 4 then 5
  10. when 5 then 6
  11. when 6 then 7
  12. when 7 then 8
  13. when 8 then 9
  14. when 9 then 10
  15. when 10 then 11
  16. when 11 then 12
  17. when 12 then 13
  18. when 13 then 14
  19. when 14 then 15
  20. when 15 then 16
  21. when 16 then 17
  22. when 17 then 18
  23. when 18 then 19
  24. when 19 then 20
  25. when 20 then 21
  26. when 21 then 22
  27. when 22 then 23
  28. when 23 then 24
  29. when 24 then 25
  30. when 25 then 26
  31. when 26 then 27
  32. when 27 then 28
  33. when 28 then 29
  34. when 29 then 30
  35. when 30 then 31
  36. when 31 then 32
  37. when 32 then 33
  38. when 33 then 34
  39. when 34 then 35
  40. when 35 then 36
  41. when 36 then 37
  42. when 37 then 38
  43. when 38 then 39
  44. when 39 then 40
  45. when 40 then 41
  46. when 41 then 42
  47. when 42 then 43
  48. when 43 then 44
  49. when 44 then 45
  50. when 45 then 46
  51. when 46 then 47
  52. when 47 then 48
  53. when 48 then 49
  54. when 49 then 50
  55. when 50 then 51
  56. when 51 then 52
  57. when 52 then 53
  58. when 53 then 54
  59. when 54 then 55
  60. when 55 then 56
  61. when 56 then 57
  62. when 57 then 58
  63. when 58 then 59
  64. when 59 then 60
  65. when 60 then 61
  66. when 61 then 62
  67. when 62 then 63
  68. when 63 then 64
  69. when 64 then 65
  70. when 65 then 66
  71. when 66 then 67
  72. when 67 then 68
  73. when 68 then 69
  74. when 69 then 70
  75. when 70 then 71
  76. when 71 then 72
  77. when 72 then 73
  78. when 73 then 74
  79. when 74 then 75
  80. when 75 then 76
  81. when 76 then 77
  82. when 77 then 78
  83. when 78 then 79
  84. when 79 then 80
  85. when 80 then 81
  86. when 81 then 82
  87. when 82 then 83
  88. when 83 then 84
  89. when 84 then 85
  90. when 85 then 86
  91. when 86 then 87
  92. when 87 then 88
  93. when 88 then 89
  94. when 89 then 90
  95. when 90 then 91
  96. when 91 then 92
  97. when 92 then 93
  98. when 93 then 94
  99. when 94 then 95
  100. when 95 then 96
  101. when 96 then 97
  102. when 97 then 98
  103. when 98 then 99
  104. else 100
  105. end;
  106. return $res;
  107. };
  108. $expected = ListFromRange(1, 101);
  109. select ListMap(ListFromRange(0, 100), $switch) == $expected;