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

Library import 241120-1113

1 files changed, 59 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/blocks/compare_dates_floats_bools.sql b/yql/essentials/tests/sql/suites/blocks/compare_dates_floats_bools.sql
new file mode 100644
index 0000000000..5b459bd969
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/blocks/compare_dates_floats_bools.sql
@@ -0,0 +1,59 @@
+use plato;
+
+insert into @tmp
+select
+   1 as key,
+
+   2.0f as fl1,
+   3.0f as fl2,
+
+   2.5  as db1,
+   1.5  as db2,
+   
+   true as b1,
+   false as b2,
+   
+   Date('2023-01-08') as d1,
+   Date('2023-01-05') as d2,
+   
+   Datetime('2023-01-08T00:00:00Z') as dt1,
+   Datetime('2023-01-05T00:00:00Z') as dt2,
+
+   Timestamp('2023-01-08T00:00:00.000000Z') as ts1,
+   Timestamp('2023-01-05T00:00:00.000000Z') as ts2,
+   
+   Interval('PT1M') as i1,
+   Interval('PT1H') as i2,
+;
+commit;
+
+select
+   t.*,
+
+   fl1 > fl2,
+   fl1 > key,
+   fl2 > 2.0,
+   fl2 > db2,
+   
+   db1 > db2,
+   db2 <= key,
+   db1 > fl2,
+   db2 > 1.0f,
+   
+   b1 < b2,
+   b1 == true,
+   false >= b2,
+   
+   d1 < d2,
+   d1 == dt1,
+   ts2 == d2,
+   d1 >= Date('2023-01-01'),
+   ts1 == d1,
+   ts2 >= dt2,
+   Timestamp('2023-01-05T00:00:00.000000Z') <= d2,
+   
+   
+   i1 < i2,
+   i2 > Interval('PT59M'),
+from @tmp as t;   
+