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;