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