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

Library import 241120-1113

1 files changed, 47 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql b/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql
new file mode 100644
index 0000000000..84b60de923
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql
@@ -0,0 +1,47 @@
+/* postgres can not */
+select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint8);
+select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint32);
+select cast(Yql::TzDate(AsAtom("1,UTC")) as Int32);
+select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint64);
+select cast(Yql::TzDate(AsAtom("1,UTC")) as Int64);
+
+select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint8);
+select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint32);
+select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Int32);
+select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint64);
+select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Int64);
+
+select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint8);
+select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint32);
+select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int32);
+select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint64);
+select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int64);
+
+select cast(1ut as TzDate);
+select cast(1u as TzDate);
+select cast(1 as TzDate);
+select cast(1ul as TzDate);
+select cast(1l as TzDate);
+select cast(-1 as TzDate);
+select cast(1/1 as TzDate);
+select cast(-1/1 as TzDate);
+
+select cast(1ut as TzDatetime);
+select cast(1u as TzDatetime);
+select cast(1 as TzDatetime);
+select cast(1ul as TzDatetime);
+select cast(1l as TzDatetime);
+select cast(-1 as TzDatetime);
+select cast(1/1 as TzDatetime);
+select cast(-1/1 as TzDatetime);
+select cast(1/0 as TzDatetime);
+
+select cast(1ut as TzTimestamp);
+select cast(1u as TzTimestamp);
+select cast(1 as TzTimestamp);
+select cast(1ul as TzTimestamp);
+select cast(1l as TzTimestamp);
+select cast(-1 as TzTimestamp);
+select cast(1/1 as TzTimestamp);
+select cast(-1/1 as TzTimestamp);
+select cast(1/0 as TzTimestamp);