| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169 |
- USE plato;
- pragma yt.DisableOptimizers="OutHorizontalJoin,HorizontalJoin,MultiHorizontalJoin,FuseMultiOutsWithOuterMaps";
- SELECT
- a.na == b.na,
- a.na == b.naz,
- a.na == b.nd,
- a.na == b.ndz,
- a.na == b.nt,
- a.na == b.ntz,
- a.na == b.wa,
- a.na == b.wd,
- a.na == b.wt,
- a.na == b.waz,
- a.na == b.wdz,
- a.na == b.wtz,
- a.naz == b.na,
- a.naz == b.naz,
- a.naz == b.nd,
- a.naz == b.ndz,
- a.naz == b.nt,
- a.naz == b.ntz,
- a.naz == b.wa,
- a.naz == b.wd,
- a.naz == b.wt,
- a.naz == b.waz,
- a.naz == b.wdz,
- a.naz == b.wtz,
- a.nd == b.na,
- a.nd == b.naz,
- a.nd == b.nd,
- a.nd == b.ndz,
- a.nd == b.nt,
- a.nd == b.ntz,
- a.nd == b.wa,
- a.nd == b.wd,
- a.nd == b.wt,
- a.nd == b.waz,
- a.nd == b.wdz,
- a.nd == b.wtz,
- a.ndz == b.na,
- a.ndz == b.naz,
- a.ndz == b.nd,
- a.ndz == b.ndz,
- a.ndz == b.nt,
- a.ndz == b.ntz,
- a.ndz == b.wa,
- a.ndz == b.wd,
- a.ndz == b.wt,
- a.ndz == b.waz,
- a.ndz == b.wdz,
- a.ndz == b.wtz,
- a.nt == b.na,
- a.nt == b.naz,
- a.nt == b.nd,
- a.nt == b.ndz,
- a.nt == b.nt,
- a.nt == b.ntz,
- a.nt == b.wa,
- a.nt == b.wd,
- a.nt == b.wt,
- a.nt == b.waz,
- a.nt == b.wdz,
- a.nt == b.wtz,
- a.ntz == b.na,
- a.ntz == b.naz,
- a.ntz == b.nd,
- a.ntz == b.ndz,
- a.ntz == b.nt,
- a.ntz == b.ntz,
- a.ntz == b.wa,
- a.ntz == b.wd,
- a.ntz == b.wt,
- a.ntz == b.waz,
- a.ntz == b.wdz,
- a.ntz == b.wtz,
- a.ni == b.ni,
- a.ni == b.wi,
- a.wi == b.ni,
- a.wi == b.wi
- FROM Dates as a CROSS JOIN Dates as b;
- SELECT
- a.wa == b.na,
- a.wa == b.naz,
- a.wa == b.nd,
- a.wa == b.ndz,
- a.wa == b.nt,
- a.wa == b.ntz,
- a.wa == b.wa,
- a.wa == b.wd,
- a.wa == b.wt,
- a.wa == b.waz,
- a.wa == b.wdz,
- a.wa == b.wtz,
- a.wd == b.na,
- a.wd == b.naz,
- a.wd == b.nd,
- a.wd == b.ndz,
- a.wd == b.nt,
- a.wd == b.ntz,
- a.wd == b.wa,
- a.wd == b.wd,
- a.wd == b.wt,
- a.wd == b.waz,
- a.wd == b.wdz,
- a.wd == b.wtz,
- a.wt == b.na,
- a.wt == b.naz,
- a.wt == b.nd,
- a.wt == b.ndz,
- a.wt == b.nt,
- a.wt == b.ntz,
- a.wt == b.wa,
- a.wt == b.wd,
- a.wt == b.wt,
- a.wt == b.waz,
- a.wt == b.wdz,
- a.wt == b.wtz,
- a.waz == b.na,
- a.waz == b.naz,
- a.waz == b.nd,
- a.waz == b.ndz,
- a.waz == b.nt,
- a.waz == b.ntz,
- a.waz == b.wa,
- a.waz == b.wd,
- a.waz == b.wt,
- a.waz == b.waz,
- a.waz == b.wdz,
- a.waz == b.wtz,
- a.wdz == b.na,
- a.wdz == b.naz,
- a.wdz == b.nd,
- a.wdz == b.ndz,
- a.wdz == b.nt,
- a.wdz == b.ntz,
- a.wdz == b.wa,
- a.wdz == b.wd,
- a.wdz == b.wt,
- a.wdz == b.waz,
- a.wdz == b.wdz,
- a.wdz == b.wtz,
- a.wtz == b.na,
- a.wtz == b.naz,
- a.wtz == b.nd,
- a.wtz == b.ndz,
- a.wtz == b.nt,
- a.wtz == b.ntz,
- a.wtz == b.wa,
- a.wtz == b.wd,
- a.wtz == b.wt,
- a.wtz == b.waz,
- a.wtz == b.wdz,
- a.wtz == b.wtz
- FROM Dates as a CROSS JOIN Dates as b;
|
