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

Library import 241120-1113

1 files changed, 97 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/datetime/date_cast.sql b/yql/essentials/tests/sql/suites/datetime/date_cast.sql
new file mode 100644
index 0000000000..0cea9766c7
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/datetime/date_cast.sql
@@ -0,0 +1,97 @@
+/* postgres can not */
+select cast(Yql::Date(AsAtom("1")) as Uint8);
+select cast(Yql::Date(AsAtom("1")) as Uint32);
+select cast(Yql::Date(AsAtom("1")) as Int32);
+select cast(Yql::Date(AsAtom("1")) as Uint64);
+select cast(Yql::Date(AsAtom("1")) as Int64);
+
+select cast(Yql::Datetime(AsAtom("1")) as Uint8);
+select cast(Yql::Datetime(AsAtom("1")) as Uint32);
+select cast(Yql::Datetime(AsAtom("1")) as Int32);
+select cast(Yql::Datetime(AsAtom("1")) as Uint64);
+select cast(Yql::Datetime(AsAtom("1")) as Int64);
+
+select cast(Yql::Timestamp(AsAtom("1")) as Uint8);
+select cast(Yql::Timestamp(AsAtom("1")) as Uint32);
+select cast(Yql::Timestamp(AsAtom("1")) as Int32);
+select cast(Yql::Timestamp(AsAtom("1")) as Uint64);
+select cast(Yql::Timestamp(AsAtom("1")) as Int64);
+
+select cast(Yql::Interval(AsAtom("1")) as Uint8);
+select cast(Yql::Interval(AsAtom("1")) as Uint32);
+select cast(Yql::Interval(AsAtom("1")) as Int32);
+select cast(Yql::Interval(AsAtom("1")) as Uint64);
+select cast(Yql::Interval(AsAtom("1")) as Int64);
+
+select cast(1ut as Date);
+select cast(1u as Date);
+select cast(1 as Date);
+select cast(1ul as Date);
+select cast(1l as Date);
+select cast(-1 as Date);
+select cast(1/1 as Date);
+select cast(-1/1 as Date);
+/* postgres can not */
+select cast(Yql::Date(AsAtom("1")) as Uint8);
+select cast(Yql::Date(AsAtom("1")) as Uint32);
+select cast(Yql::Date(AsAtom("1")) as Int32);
+select cast(Yql::Date(AsAtom("1")) as Uint64);
+select cast(Yql::Date(AsAtom("1")) as Int64);
+
+select cast(Yql::Datetime(AsAtom("1")) as Uint8);
+select cast(Yql::Datetime(AsAtom("1")) as Uint32);
+select cast(Yql::Datetime(AsAtom("1")) as Int32);
+select cast(Yql::Datetime(AsAtom("1")) as Uint64);
+select cast(Yql::Datetime(AsAtom("1")) as Int64);
+
+select cast(Yql::Timestamp(AsAtom("1")) as Uint8);
+select cast(Yql::Timestamp(AsAtom("1")) as Uint32);
+select cast(Yql::Timestamp(AsAtom("1")) as Int32);
+select cast(Yql::Timestamp(AsAtom("1")) as Uint64);
+select cast(Yql::Timestamp(AsAtom("1")) as Int64);
+
+select cast(Yql::Interval(AsAtom("1")) as Uint8);
+select cast(Yql::Interval(AsAtom("1")) as Uint32);
+select cast(Yql::Interval(AsAtom("1")) as Int32);
+select cast(Yql::Interval(AsAtom("1")) as Uint64);
+select cast(Yql::Interval(AsAtom("1")) as Int64);
+
+select cast(1ut as Date);
+select cast(1u as Date);
+select cast(1 as Date);
+select cast(1ul as Date);
+select cast(1l as Date);
+select cast(-1 as Date);
+select cast(1/1 as Date);
+select cast(-1/1 as Date);
+select cast(1/0 as Date);
+
+select cast(1ut as Datetime);
+select cast(1u as Datetime);
+select cast(1 as Datetime);
+select cast(1ul as Datetime);
+select cast(1l as Datetime);
+select cast(-1 as Datetime);
+select cast(1/1 as Datetime);
+select cast(-1/1 as Datetime);
+select cast(1/0 as Datetime);
+
+select cast(1ut as Timestamp);
+select cast(1u as Timestamp);
+select cast(1 as Timestamp);
+select cast(1ul as Timestamp);
+select cast(1l as Timestamp);
+select cast(-1 as Timestamp);
+select cast(1/1 as Timestamp);
+select cast(-1/1 as Timestamp);
+select cast(1/0 as Timestamp);
+
+select cast(1ut as Interval);
+select cast(1u as Interval);
+select cast(-1 as Interval);
+select cast(1ul as Interval);
+select cast(-1l as Interval);
+select cast(-1 as Interval);
+select cast(1/1 as Interval);
+select cast(-1/1 as Interval);
+select cast(1/0 as Interval);