SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
							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;