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;