lds_empty_compare.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. select
  4. Yql::AggrEquals([],[]),
  5. Yql::AggrNotEquals([],[]),
  6. Yql::AggrLess([],[]),
  7. Yql::AggrLessOrEqual([],[]),
  8. Yql::AggrGreater([],[]),
  9. Yql::AggrGreaterOrEqual([],[]),
  10. Yql::AggrEquals({},{}),
  11. Yql::AggrNotEquals({},{}),
  12. [] = [],
  13. [] = ListCreate(Int32),
  14. ListCreate(Int32) = [],
  15. [] = [1],
  16. [1] = [],
  17. [] != [],
  18. [] != ListCreate(Int32),
  19. ListCreate(Int32) != [],
  20. [] != [1],
  21. [1] != [],
  22. [] < [],
  23. [] < ListCreate(Int32),
  24. ListCreate(Int32) < [],
  25. [] < [1],
  26. [1] < [],
  27. [] <= [],
  28. [] <= ListCreate(Int32),
  29. ListCreate(Int32) <= [],
  30. [] <= [1],
  31. [1] <= [],
  32. [] > [],
  33. [] > ListCreate(Int32),
  34. ListCreate(Int32) > [],
  35. [] > [1],
  36. [1] > [],
  37. [] >= [],
  38. [] >= ListCreate(Int32),
  39. ListCreate(Int32) >= [],
  40. [] >= [1],
  41. [1] >= [],
  42. {} = {},
  43. {} = SetCreate(Int32),
  44. SetCreate(Int32) = {},
  45. {} = {1},
  46. {1} = {},
  47. {} != {},
  48. {} != SetCreate(Int32),
  49. SetCreate(Int32) != {},
  50. {} != {1},
  51. {1} != {},