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;