aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/bigdate/compare_big_big.sql
blob: d160bcb31a7bba93ae01772e1a253b1012dcacb9 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
pragma warning("disable","4510");
select
  3, Yql::Date32(AsAtom("0")) = Yql::Date32(AsAtom("1")),
  4, Yql::Datetime64(AsAtom("0")) = Yql::Datetime64(AsAtom("1")),
  5, Yql::Timestamp64(AsAtom("0")) = Yql::Timestamp64(AsAtom("1")),
  6, Yql::Interval64(AsAtom("0")) = Yql::Interval64(AsAtom("1")),
  7, Yql::Date32(AsAtom("0")) < Yql::Date32(AsAtom("1")),
  8, Yql::Datetime64(AsAtom("0")) < Yql::Datetime64(AsAtom("1")),
  9, Yql::Timestamp64(AsAtom("0")) < Yql::Timestamp64(AsAtom("1")),
  10, Yql::Interval64(AsAtom("0")) < Yql::Interval64(AsAtom("1")),
  11, Yql::Date32(AsAtom("0")) > Yql::Date32(AsAtom("1")),
  12, Yql::Datetime64(AsAtom("0")) > Yql::Datetime64(AsAtom("1")),
  13, Yql::Timestamp64(AsAtom("0")) > Yql::Timestamp64(AsAtom("1")),
  14, Yql::Interval64(AsAtom("0")) > Yql::Interval64(AsAtom("1")),
  15, Yql::Date32(AsAtom("0")) != Yql::Date32(AsAtom("1")),
  16, Yql::Datetime64(AsAtom("0")) != Yql::Datetime64(AsAtom("1")),
  17, Yql::Timestamp64(AsAtom("0")) != Yql::Timestamp64(AsAtom("1")),
  18, Yql::Interval64(AsAtom("0")) != Yql::Interval64(AsAtom("1")),
  19, Yql::Date32(AsAtom("0")) <= Yql::Date32(AsAtom("1")),
  20, Yql::Datetime64(AsAtom("0")) <= Yql::Datetime64(AsAtom("1")),
  21, Yql::Timestamp64(AsAtom("0")) <= Yql::Timestamp64(AsAtom("1")),
  22, Yql::Interval64(AsAtom("0")) <= Yql::Interval64(AsAtom("1")),
  23, Yql::Date32(AsAtom("0")) >= Yql::Date32(AsAtom("1")),
  24, Yql::Datetime64(AsAtom("0")) >= Yql::Datetime64(AsAtom("1")),
  25, Yql::Timestamp64(AsAtom("0")) >= Yql::Timestamp64(AsAtom("1")),
  26, Yql::Interval64(AsAtom("0")) >= Yql::Interval64(AsAtom("1")),