Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 169 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/blocks/date_less.sql b/yql/essentials/tests/sql/suites/blocks/date_less.sql
new file mode 100644
index 0000000000..7145452b86
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/blocks/date_less.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;