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