Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 169 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/blocks/date_not_equals.sql b/yql/essentials/tests/sql/suites/blocks/date_not_equals.sql
new file mode 100644
index 0000000000..098dbd0d58
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/blocks/date_not_equals.sql
@@ -0,0 +1,169 @@
+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;