Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 686cf76645
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
sql
/
suites
/
bigdate
/
arithmetic.sql

arithmetic.sql 6.4 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 
  1. $date32_min = unwrap(cast(-53375809 as date32));
    2. 

  2. $date32_max = unwrap(cast(53375807 as date32));
    3. 

  3. $datetime64_min = unwrap(cast(-4611669897600 as datetime64));
    4. 

  4. $datetime64_max = unwrap(cast(4611669811199 as datetime64));
    5. 

  5. $timestamp64_min = unwrap(cast(-4611669897600000000 as timestamp64));
    6. 

  6. $timestamp64_max = unwrap(cast(4611669811199999999 as timestamp64));
    7. 

  7. $interval64_min = unwrap(cast(-9223339708799999999 as interval64));
    8. 

  8. $interval64_max = unwrap(cast(9223339708799999999 as interval64));
    9. 

  9. $interval64_plus1 = unwrap(cast(1 as interval64));
    10. 

  10. $interval64_minus1 = unwrap(cast(-1 as interval64));
    11. 

  11. $interval64_zero = unwrap(cast(0 as interval64));
    12. 

  12. 

  13. $date_max_value = 49673l;
    14. 

  14. $date_max = unwrap(cast($date_max_value - 1 as date));
    15. 

  15. $datetime_max = unwrap(cast($date_max_value*86400 - 1 as datetime));
    16. 

  16. $timestamp_max = unwrap(cast($date_max_value*86400*1000000 - 1 as timestamp));
    17. 

  17. $interval_min = unwrap(cast(-$date_max_value*86400*1000000 + 1 as interval));
    18. 

  18. $interval_max = unwrap(cast($date_max_value*86400*1000000 - 1 as interval));
    19. 

  19. $interval_plus1 = unwrap(cast(1 as interval));
    20. 

  20. $interval_minus1 = unwrap(cast(-1 as interval));
    21. 

  21. 

  22. $i64_max = 9223372036854775807l;
    23. 

  23. $ui64_max = 18446744073709551615ul;
    24. 

  24. 

  25. select 1, $date32_min - $date32_max, $date32_max - $date32_min
    26. 

  26. , $date32_min - $datetime64_max, $date32_max - $datetime64_min
    27. 

  27. , $date32_min - $timestamp64_max, $date32_max - $timestamp64_min
    28. 

  28. , 2, $date32_min - $date_max
    29. 

  29. , $date32_min - $datetime_max
    30. 

  30. , $date32_min - $timestamp_max
    31. 

  31. , 3, $date32_min - $interval64_minus1, $date32_max - $interval64_minus1
    32. 

  32. , $date32_min - $interval64_plus1, $date32_max - $interval64_plus1
    33. 

  33. , $date32_min + $interval64_minus1, $date32_max + $interval64_minus1
    34. 

  34. , $date32_min + $interval64_plus1, $date32_max + $interval64_plus1
    35. 

  35. , 4, $date32_min - $interval_minus1, $date32_max - $interval_minus1
    36. 

  36. , $date32_min - $interval_plus1, $date32_max - $interval_plus1
    37. 

  37. , $date32_min + $interval_minus1, $date32_max + $interval_minus1
    38. 

  38. , $date32_min + $interval_plus1, $date32_max + $interval_plus1;
    39. 

  39. 

  40. select 1, $datetime64_min - $date32_max, $datetime64_max - $date32_min
    41. 

  41. , $datetime64_min - $datetime64_max, $datetime64_max - $datetime64_min
    42. 

  42. , $datetime64_min - $timestamp64_max, $datetime64_max - $timestamp64_min
    43. 

  43. , 2, $datetime64_min - $date_max
    44. 

  44. , $datetime64_min - $datetime_max
    45. 

  45. , $datetime64_min - $timestamp_max
    46. 

  46. , 3, $datetime64_min - $interval64_minus1, $datetime64_max - $interval64_minus1
    47. 

  47. , $datetime64_min - $interval64_plus1, $datetime64_max - $interval64_plus1
    48. 

  48. , $datetime64_min + $interval64_minus1, $datetime64_max + $interval64_minus1
    49. 

  49. , $datetime64_min + $interval64_plus1, $datetime64_max + $interval64_plus1
    50. 

  50. , 4, $datetime64_min - $interval_minus1, $datetime64_max - $interval_minus1
    51. 

  51. , $datetime64_min - $interval_plus1, $datetime64_max - $interval_plus1
    52. 

  52. , $datetime64_min + $interval_minus1, $datetime64_max + $interval_minus1
    53. 

  53. , $datetime64_min + $interval_plus1, $datetime64_max + $interval_plus1;
    54. 

  54. 

  55. select 1, $timestamp64_min - $date32_max, $timestamp64_max - $date32_min
    56. 

  56. , $timestamp64_min - $datetime64_max, $timestamp64_max - $datetime64_min
    57. 

  57. , $timestamp64_min - $timestamp64_max, $timestamp64_max - $timestamp64_min
    58. 

  58. , 2, $timestamp64_min - $date_max
    59. 

  59. , $timestamp64_min - $datetime_max
    60. 

  60. , $timestamp64_min - $timestamp_max
    61. 

  61. , 3, $timestamp64_min - $interval64_minus1, $timestamp64_max - $interval64_minus1
    62. 

  62. , $timestamp64_min - $interval64_plus1, $timestamp64_max - $interval64_plus1
    63. 

  63. , $timestamp64_min + $interval64_minus1, $timestamp64_max + $interval64_minus1
    64. 

  64. , $timestamp64_min + $interval64_plus1, $timestamp64_max + $interval64_plus1
    65. 

  65. , 4, $timestamp64_min - $interval_minus1, $timestamp64_max - $interval_minus1
    66. 

  66. , $timestamp64_min - $interval_plus1, $timestamp64_max - $interval_plus1
    67. 

  67. , $timestamp64_min + $interval_minus1, $timestamp64_max + $interval_minus1
    68. 

  68. , $timestamp64_min + $interval_plus1, $timestamp64_max + $interval_plus1;
    69. 

  69. 

  70. select 1, $date_max - $date32_min, $date_max - $datetime64_min, $date_max - $timestamp64_min
    71. 

  71. , $date_max - $date32_max, $date_max - $datetime64_max, $date_max - $timestamp64_max
    72. 

  72. , $date_max - $interval64_minus1, $date_max + $interval64_minus1
    73. 

  73. , $date_max - $interval64_plus1, $date_max + $interval64_plus1
    74. 

  74. , 2, $datetime_max - $date32_min, $datetime_max - $datetime64_min, $datetime_max - $timestamp64_min
    75. 

  75. , $datetime_max - $date32_max, $datetime_max - $datetime64_max, $datetime_max - $timestamp64_max
    76. 

  76. , $datetime_max - $interval64_minus1, $datetime_max + $interval64_minus1
    77. 

  77. , $datetime_max - $interval64_plus1, $datetime_max + $interval64_plus1
    78. 

  78. , 3, $timestamp_max - $date32_min, $timestamp_max - $datetime64_min, $timestamp_max - $timestamp64_min
    79. 

  79. , $timestamp_max - $date32_max, $timestamp_max - $datetime64_max, $timestamp_max - $timestamp64_max
    80. 

  80. , $timestamp_max - $interval64_minus1, $timestamp_max + $interval64_minus1
    81. 

  81. , $timestamp_max - $interval64_plus1, $timestamp_max + $interval64_plus1;
    82. 

  82. 

  83. select 1, $interval_min - $interval64_min, $interval_min + $interval64_min
    84. 

  84. , $interval_min - $interval64_max, $interval_min + $interval64_max
    85. 

  85. , $interval_max - $interval64_max, $interval_max + $interval64_max
    86. 

  86. , $interval_max - $interval64_min, $interval_max + $interval64_min
    87. 

  87. , 2, $interval64_max - $interval64_min, $interval64_min - $interval64_max
    88. 

  88. , $interval64_max + $interval64_min, $interval64_max + $interval64_max
    89. 

  89. , $interval64_min - $interval64_min, $interval64_max - $interval64_max;
    90. 

  90. 

  91. select 0, -$interval64_max, -$interval64_min, -$interval64_zero
    92. 

  92. , 1, $interval64_max*0, 0*$interval64_max
    93. 

  93. , 2, $interval64_max*1, 1*$interval64_max, $interval64_max*(-1), (-1)*$interval64_max
    94. 

  94. , 3, $interval64_min*1, 1*$interval64_min, $interval64_min*(-1), (-1)*$interval64_min
    95. 

  95. , 4, $interval64_plus1*cast($interval64_max as int64), $interval64_minus1*cast($interval64_min as int64)
    96. 

  96. , 5, $interval64_max*$ui64_max, $i64_max*$interval64_max, $interval64_min*$ui64_max, $i64_max*$interval64_min
    97. 

  97. , 6, $interval64_zero*$ui64_max, $ui64_max*$interval64_zero, $interval64_zero*$i64_max, $i64_max*$interval64_zero
    98. 

  98. , 7, $interval64_max/0, $interval64_min/0, $interval64_max/1, $interval64_min/1, $interval64_max/(-1), $interval64_min/(-1)
    99. 

  99. , 8, $interval64_zero/$ui64_max, $interval64_zero/$i64_max, $interval64_plus1/$ui64_max, $interval64_plus1/$i64_max, $interval64_minus1/$ui64_max, $interval64_minus1/$i64_max
    100. 

  100. , 9, $interval64_max/cast($interval64_max as int64), $interval64_min/cast($interval64_min as int64)
    101. 

  101. , 10, abs($interval64_max), abs($interval64_min), abs($interval64_zero)
    102. 

  102. , 11, cast(4294967296l as interval64) * 4294967296l, 4294967296ul * cast(4294967296l as interval64)
    103. 

  103. ;
    104.