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;