Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 169 insertions, 0 deletions

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