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;