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
/
compare_small_big.sql

compare_small_big.sql 4.3 KB
History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 
  1. pragma warning("disable","4510");
    2. 

  2. select
    3. 

  3.   3, Yql::Date(AsAtom("1")) = Yql::Date32(AsAtom("1")),
    4. 

  4.   4, Yql::Date(AsAtom("1")) = Yql::Datetime64(AsAtom("86400")),
    5. 

  5.   5, Yql::Date(AsAtom("1")) = Yql::Timestamp64(AsAtom("86400000000")),
    6. 

  6. 

  7.   7, Yql::Datetime(AsAtom("86400")) = Yql::Date32(AsAtom("1")),
    8. 

  8.   8, Yql::Datetime(AsAtom("86400")) = Yql::Datetime64(AsAtom("86400")),
    9. 

  9.   9, Yql::Datetime(AsAtom("86400")) = Yql::Timestamp64(AsAtom("86400000000")),
    10. 

  10. 

  11.   11, Yql::Timestamp(AsAtom("86400000000")) = Yql::Date32(AsAtom("1")),
    12. 

  12.   12, Yql::Timestamp(AsAtom("86400000000")) = Yql::Datetime64(AsAtom("86400")),
    13. 

  13.   13, Yql::Timestamp(AsAtom("86400000000")) = Yql::Timestamp64(AsAtom("86400000000")),
    14. 

  14. 

  15.   15, Yql::Interval(AsAtom("1")) = Yql::Interval64(AsAtom("1")),
    16. 

  16. 

  17.   17, Yql::Date(AsAtom("1")) < Yql::Date32(AsAtom("1")),
    18. 

  18.   18, Yql::Date(AsAtom("1")) < Yql::Datetime64(AsAtom("86400")),
    19. 

  19.   19, Yql::Date(AsAtom("1")) < Yql::Timestamp64(AsAtom("86400000000")),
    20. 

  20. 

  21.   21, Yql::Datetime(AsAtom("86400")) < Yql::Date32(AsAtom("1")),
    22. 

  22.   22, Yql::Datetime(AsAtom("86400")) < Yql::Datetime64(AsAtom("86400")),
    23. 

  23.   23, Yql::Datetime(AsAtom("86400")) < Yql::Timestamp64(AsAtom("86400000000")),
    24. 

  24. 

  25.   25, Yql::Timestamp(AsAtom("86400000000")) < Yql::Date32(AsAtom("1")),
    26. 

  26.   26, Yql::Timestamp(AsAtom("86400000000")) < Yql::Datetime64(AsAtom("86400")),
    27. 

  27.   27, Yql::Timestamp(AsAtom("86400000000")) < Yql::Timestamp64(AsAtom("86400000000")),
    28. 

  28. 

  29.   29, Yql::Interval(AsAtom("1")) < Yql::Interval64(AsAtom("1")),
    30. 

  30. 

  31.   31, Yql::Date(AsAtom("1")) <= Yql::Date32(AsAtom("1")),
    32. 

  32.   32, Yql::Date(AsAtom("1")) <= Yql::Datetime64(AsAtom("86400")),
    33. 

  33.   33, Yql::Date(AsAtom("1")) <= Yql::Timestamp64(AsAtom("86400000000")),
    34. 

  34. 

  35.   35, Yql::Datetime(AsAtom("86400")) <= Yql::Date32(AsAtom("1")),
    36. 

  36.   36, Yql::Datetime(AsAtom("86400")) <= Yql::Datetime64(AsAtom("86400")),
    37. 

  37.   37, Yql::Datetime(AsAtom("86400")) <= Yql::Timestamp64(AsAtom("86400000000")),
    38. 

  38. 

  39.   39, Yql::Timestamp(AsAtom("86400000000")) <= Yql::Date32(AsAtom("1")),
    40. 

  40.   40, Yql::Timestamp(AsAtom("86400000000")) <= Yql::Datetime64(AsAtom("86400")),
    41. 

  41.   41, Yql::Timestamp(AsAtom("86400000000")) <= Yql::Timestamp64(AsAtom("86400000000")),
    42. 

  42. 

  43.   43, Yql::Interval(AsAtom("1")) <= Yql::Interval64(AsAtom("1")),
    44. 

  44. 

  45.   45, Yql::Date(AsAtom("1")) > Yql::Date32(AsAtom("1")),
    46. 

  46.   46, Yql::Date(AsAtom("1")) > Yql::Datetime64(AsAtom("86400")),
    47. 

  47.   47, Yql::Date(AsAtom("1")) > Yql::Timestamp64(AsAtom("86400000000")),
    48. 

  48. 

  49.   49, Yql::Datetime(AsAtom("86400")) > Yql::Date32(AsAtom("1")),
    50. 

  50.   50, Yql::Datetime(AsAtom("86400")) > Yql::Datetime64(AsAtom("86400")),
    51. 

  51.   51, Yql::Datetime(AsAtom("86400")) > Yql::Timestamp64(AsAtom("86400000000")),
    52. 

  52. 

  53.   53, Yql::Timestamp(AsAtom("86400000000")) > Yql::Date32(AsAtom("1")),
    54. 

  54.   54, Yql::Timestamp(AsAtom("86400000000")) > Yql::Datetime64(AsAtom("86400")),
    55. 

  55.   55, Yql::Timestamp(AsAtom("86400000000")) > Yql::Timestamp64(AsAtom("86400000000")),
    56. 

  56. 

  57.   57, Yql::Interval(AsAtom("1")) > Yql::Interval64(AsAtom("1")),
    58. 

  58. 

  59.   59, Yql::Date(AsAtom("1")) >= Yql::Date32(AsAtom("1")),
    60. 

  60.   60, Yql::Date(AsAtom("1")) >= Yql::Datetime64(AsAtom("86400")),
    61. 

  61.   61, Yql::Date(AsAtom("1")) >= Yql::Timestamp64(AsAtom("86400000000")),
    62. 

  62. 

  63.   63, Yql::Datetime(AsAtom("86400")) >= Yql::Date32(AsAtom("1")),
    64. 

  64.   64, Yql::Datetime(AsAtom("86400")) >= Yql::Datetime64(AsAtom("86400")),
    65. 

  65.   65, Yql::Datetime(AsAtom("86400")) >= Yql::Timestamp64(AsAtom("86400000000")),
    66. 

  66. 

  67.   67, Yql::Timestamp(AsAtom("86400000000")) >= Yql::Date32(AsAtom("1")),
    68. 

  68.   68, Yql::Timestamp(AsAtom("86400000000")) >= Yql::Datetime64(AsAtom("86400")),
    69. 

  69.   69, Yql::Timestamp(AsAtom("86400000000")) >= Yql::Timestamp64(AsAtom("86400000000")),
    70. 

  70. 

  71.   71, Yql::Interval(AsAtom("1")) >= Yql::Interval64(AsAtom("1")),
    72. 

  72. 

  73.   73, Yql::Date(AsAtom("1")) != Yql::Date32(AsAtom("1")),
    74. 

  74.   74, Yql::Date(AsAtom("1")) != Yql::Datetime64(AsAtom("86400")),
    75. 

  75.   75, Yql::Date(AsAtom("1")) != Yql::Timestamp64(AsAtom("86400000000")),
    76. 

  76. 

  77.   77, Yql::Datetime(AsAtom("86400")) != Yql::Date32(AsAtom("1")),
    78. 

  78.   78, Yql::Datetime(AsAtom("86400")) != Yql::Datetime64(AsAtom("86400")),
    79. 

  79.   79, Yql::Datetime(AsAtom("86400")) != Yql::Timestamp64(AsAtom("86400000000")),
    80. 

  80. 

  81.   81, Yql::Timestamp(AsAtom("86400000000")) != Yql::Date32(AsAtom("1")),
    82. 

  82.   82, Yql::Timestamp(AsAtom("86400000000")) != Yql::Datetime64(AsAtom("86400")),
    83. 

  83.   83, Yql::Timestamp(AsAtom("86400000000")) != Yql::Timestamp64(AsAtom("86400000000")),
    84. 

  84. 

  85.   85, Yql::Interval(AsAtom("1")) != Yql::Interval64(AsAtom("1"));
    86.