USE plato; pragma yt.DisableOptimizers="OutHorizontalJoin,HorizontalJoin,MultiHorizontalJoin,FuseMultiOutsWithOuterMaps"; SELECT Date("2000-01-01") < na, Date("2000-01-01") < naz, Date("2000-01-01") < nd, Date("2000-01-01") < ndz, Date("2000-01-01") < nt, Date("2000-01-01") < ntz, Date("2000-01-01") < wa, Date("2000-01-01") < wd, Date("2000-01-01") < wt, Date("2000-01-01") < waz, Date("2000-01-01") < wdz, Date("2000-01-01") < wtz, TzDate("2000-01-01,Europe/Moscow") < na, TzDate("2000-01-01,Europe/Moscow") < naz, TzDate("2000-01-01,Europe/Moscow") < nd, TzDate("2000-01-01,Europe/Moscow") < ndz, TzDate("2000-01-01,Europe/Moscow") < nt, TzDate("2000-01-01,Europe/Moscow") < ntz, TzDate("2000-01-01,Europe/Moscow") < wa, TzDate("2000-01-01,Europe/Moscow") < wd, TzDate("2000-01-01,Europe/Moscow") < wt, TzDate("2000-01-01,Europe/Moscow") < waz, TzDate("2000-01-01,Europe/Moscow") < wdz, TzDate("2000-01-01,Europe/Moscow") < wtz, Datetime("2000-01-01T03:04:05Z") < na, Datetime("2000-01-01T03:04:05Z") < naz, Datetime("2000-01-01T03:04:05Z") < nd, Datetime("2000-01-01T03:04:05Z") < ndz, Datetime("2000-01-01T03:04:05Z") < nt, Datetime("2000-01-01T03:04:05Z") < ntz, Datetime("2000-01-01T03:04:05Z") < wa, Datetime("2000-01-01T03:04:05Z") < wd, Datetime("2000-01-01T03:04:05Z") < wt, Datetime("2000-01-01T03:04:05Z") < waz, Datetime("2000-01-01T03:04:05Z") < wdz, Datetime("2000-01-01T03:04:05Z") < wtz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < na, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < naz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < nd, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < ndz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < nt, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < ntz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < wa, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < wd, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < wt, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < waz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < wdz, TzDatetime("2000-01-01T03:04:05,Europe/Moscow") < wtz, Timestamp("2000-01-01T03:04:05.678912Z") < na, Timestamp("2000-01-01T03:04:05.678912Z") < naz, Timestamp("2000-01-01T03:04:05.678912Z") < nd, Timestamp("2000-01-01T03:04:05.678912Z") < ndz, Timestamp("2000-01-01T03:04:05.678912Z") < nt, Timestamp("2000-01-01T03:04:05.678912Z") < ntz, Timestamp("2000-01-01T03:04:05.678912Z") < wa, Timestamp("2000-01-01T03:04:05.678912Z") < wd, Timestamp("2000-01-01T03:04:05.678912Z") < wt, Timestamp("2000-01-01T03:04:05.678912Z") < waz, Timestamp("2000-01-01T03:04:05.678912Z") < wdz, Timestamp("2000-01-01T03:04:05.678912Z") < wtz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < na, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < naz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < nd, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < ndz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < nt, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < ntz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < wa, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < wd, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < wt, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < waz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < wdz, TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") < wtz FROM Dates; SELECT Date32("1900-01-01") < na, Date32("1900-01-01") < naz, Date32("1900-01-01") < nd, Date32("1900-01-01") < ndz, Date32("1900-01-01") < nt, Date32("1900-01-01") < ntz, Date32("1900-01-01") < wa, Date32("1900-01-01") < wd, Date32("1900-01-01") < wt, Date32("1900-01-01") < waz, Date32("1900-01-01") < wdz, Date32("1900-01-01") < wtz, Datetime64("1900-01-01T03:04:05Z") < na, Datetime64("1900-01-01T03:04:05Z") < naz, Datetime64("1900-01-01T03:04:05Z") < nd, Datetime64("1900-01-01T03:04:05Z") < ndz, Datetime64("1900-01-01T03:04:05Z") < nt, Datetime64("1900-01-01T03:04:05Z") < ntz, Datetime64("1900-01-01T03:04:05Z") < wa, Datetime64("1900-01-01T03:04:05Z") < wd, Datetime64("1900-01-01T03:04:05Z") < wt, Datetime64("1900-01-01T03:04:05Z") < waz, Datetime64("1900-01-01T03:04:05Z") < wdz, Datetime64("1900-01-01T03:04:05Z") < wtz, Timestamp64("1900-01-01T03:04:05.678912Z") < na, Timestamp64("1900-01-01T03:04:05.678912Z") < naz, Timestamp64("1900-01-01T03:04:05.678912Z") < nd, Timestamp64("1900-01-01T03:04:05.678912Z") < ndz, Timestamp64("1900-01-01T03:04:05.678912Z") < nt, Timestamp64("1900-01-01T03:04:05.678912Z") < ntz, Timestamp64("1900-01-01T03:04:05.678912Z") < wa, Timestamp64("1900-01-01T03:04:05.678912Z") < wd, Timestamp64("1900-01-01T03:04:05.678912Z") < wt, Timestamp64("1900-01-01T03:04:05.678912Z") < waz, Timestamp64("1900-01-01T03:04:05.678912Z") < wdz, Timestamp64("1900-01-01T03:04:05.678912Z") < wtz, TzDate32("1900-01-01,Europe/Moscow") < na, TzDate32("1900-01-01,Europe/Moscow") < naz, TzDate32("1900-01-01,Europe/Moscow") < nd, TzDate32("1900-01-01,Europe/Moscow") < ndz, TzDate32("1900-01-01,Europe/Moscow") < nt, TzDate32("1900-01-01,Europe/Moscow") < ntz, TzDate32("1900-01-01,Europe/Moscow") < wa, TzDate32("1900-01-01,Europe/Moscow") < wd, TzDate32("1900-01-01,Europe/Moscow") < wt, TzDate32("1900-01-01,Europe/Moscow") < waz, TzDate32("1900-01-01,Europe/Moscow") < wdz, TzDate32("1900-01-01,Europe/Moscow") < wtz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < na, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < naz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < nd, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < ndz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < nt, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < ntz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < wa, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < wd, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < wt, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < waz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < wdz, TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") < wtz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < na, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < naz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < nd, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < ndz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < nt, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < ntz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < wa, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < wd, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < wt, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < waz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < wdz, TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") < wtz, Interval("P1D") < ni, Interval("P1D") < wi, Interval64("P1D") < ni, Interval64("P1D") < wi, FROM Dates; SELECT na < Date("2000-01-01"), naz < Date("2000-01-01"), nd < Date("2000-01-01"), ndz < Date("2000-01-01"), nt < Date("2000-01-01"), ntz < Date("2000-01-01"), wa < Date("2000-01-01"), wd < Date("2000-01-01"), wt < Date("2000-01-01"), waz < Date("2000-01-01"), wdz < Date("2000-01-01"), wtz < Date("2000-01-01"), na < TzDate("2000-01-01,Europe/Moscow"), naz < TzDate("2000-01-01,Europe/Moscow"), nd < TzDate("2000-01-01,Europe/Moscow"), ndz < TzDate("2000-01-01,Europe/Moscow"), nt < TzDate("2000-01-01,Europe/Moscow"), ntz < TzDate("2000-01-01,Europe/Moscow"), wa < TzDate("2000-01-01,Europe/Moscow"), wd < TzDate("2000-01-01,Europe/Moscow"), wt < TzDate("2000-01-01,Europe/Moscow"), waz < TzDate("2000-01-01,Europe/Moscow"), wdz < TzDate("2000-01-01,Europe/Moscow"), wtz < TzDate("2000-01-01,Europe/Moscow"), na < Datetime("2000-01-01T03:04:05Z"), naz < Datetime("2000-01-01T03:04:05Z"), nd < Datetime("2000-01-01T03:04:05Z"), ndz < Datetime("2000-01-01T03:04:05Z"), nt < Datetime("2000-01-01T03:04:05Z"), ntz < Datetime("2000-01-01T03:04:05Z"), wa < Datetime("2000-01-01T03:04:05Z"), wd < Datetime("2000-01-01T03:04:05Z"), wt < Datetime("2000-01-01T03:04:05Z"), waz < Datetime("2000-01-01T03:04:05Z"), wdz < Datetime("2000-01-01T03:04:05Z"), wtz < Datetime("2000-01-01T03:04:05Z"), na < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), naz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), nd < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), ndz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), nt < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), ntz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), wa < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), wd < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), wt < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), waz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), wdz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), wtz < TzDatetime("2000-01-01T03:04:05,Europe/Moscow"), na < Timestamp("2000-01-01T03:04:05.678912Z"), naz < Timestamp("2000-01-01T03:04:05.678912Z"), nd < Timestamp("2000-01-01T03:04:05.678912Z"), ndz < Timestamp("2000-01-01T03:04:05.678912Z"), nt < Timestamp("2000-01-01T03:04:05.678912Z"), ntz < Timestamp("2000-01-01T03:04:05.678912Z"), wa < Timestamp("2000-01-01T03:04:05.678912Z"), wd < Timestamp("2000-01-01T03:04:05.678912Z"), wt < Timestamp("2000-01-01T03:04:05.678912Z"), waz < Timestamp("2000-01-01T03:04:05.678912Z"), wdz < Timestamp("2000-01-01T03:04:05.678912Z"), wtz < Timestamp("2000-01-01T03:04:05.678912Z"), na < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), naz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), nd < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), ndz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), nt < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), ntz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), wa < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), wd < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), wt < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), waz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), wdz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"), wtz < TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") FROM Dates; SELECT na < Date32("1900-01-01"), naz < Date32("1900-01-01"), nd < Date32("1900-01-01"), ndz < Date32("1900-01-01"), nt < Date32("1900-01-01"), ntz < Date32("1900-01-01"), wa < Date32("1900-01-01"), wd < Date32("1900-01-01"), wt < Date32("1900-01-01"), waz < Date32("1900-01-01"), wdz < Date32("1900-01-01"), wtz < Date32("1900-01-01"), na < Datetime64("1900-01-01T03:04:05Z"), naz < Datetime64("1900-01-01T03:04:05Z"), nd < Datetime64("1900-01-01T03:04:05Z"), ndz < Datetime64("1900-01-01T03:04:05Z"), nt < Datetime64("1900-01-01T03:04:05Z"), ntz < Datetime64("1900-01-01T03:04:05Z"), wa < Datetime64("1900-01-01T03:04:05Z"), wd < Datetime64("1900-01-01T03:04:05Z"), wt < Datetime64("1900-01-01T03:04:05Z"), waz < Datetime64("1900-01-01T03:04:05Z"), wdz < Datetime64("1900-01-01T03:04:05Z"), wtz < Datetime64("1900-01-01T03:04:05Z"), na < Timestamp64("1900-01-01T03:04:05.678912Z"), naz < Timestamp64("1900-01-01T03:04:05.678912Z"), nd < Timestamp64("1900-01-01T03:04:05.678912Z"), ndz < Timestamp64("1900-01-01T03:04:05.678912Z"), nt < Timestamp64("1900-01-01T03:04:05.678912Z"), ntz < Timestamp64("1900-01-01T03:04:05.678912Z"), wa < Timestamp64("1900-01-01T03:04:05.678912Z"), wd < Timestamp64("1900-01-01T03:04:05.678912Z"), wt < Timestamp64("1900-01-01T03:04:05.678912Z"), waz < Timestamp64("1900-01-01T03:04:05.678912Z"), wdz < Timestamp64("1900-01-01T03:04:05.678912Z"), wtz < Timestamp64("1900-01-01T03:04:05.678912Z"), na < TzDate32("1900-01-01,Europe/Moscow"), naz < TzDate32("1900-01-01,Europe/Moscow"), nd < TzDate32("1900-01-01,Europe/Moscow"), ndz < TzDate32("1900-01-01,Europe/Moscow"), nt < TzDate32("1900-01-01,Europe/Moscow"), ntz < TzDate32("1900-01-01,Europe/Moscow"), wa < TzDate32("1900-01-01,Europe/Moscow"), wd < TzDate32("1900-01-01,Europe/Moscow"), wt < TzDate32("1900-01-01,Europe/Moscow"), waz < TzDate32("1900-01-01,Europe/Moscow"), wdz < TzDate32("1900-01-01,Europe/Moscow"), wtz < TzDate32("1900-01-01,Europe/Moscow"), na < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), naz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), nd < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), ndz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), nt < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), ntz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), wa < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), wd < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), wt < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), waz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), wdz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), wtz < TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"), na < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), naz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), nd < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), ndz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), nt < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), ntz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), wa < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), wd < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), wt < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), waz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), wdz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), wtz < TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"), ni < Interval("P1D"), wi < Interval("P1D"), ni < Interval64("P1D"), wi < Interval64("P1D"), FROM Dates;