Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 48 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/bigdate/tzstrliterals.sql b/yql/essentials/tests/sql/suites/bigdate/tzstrliterals.sql
new file mode 100644
index 0000000000..72b2433075
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/bigdate/tzstrliterals.sql
@@ -0,0 +1,48 @@
+select 
+    cast(Date32("-144169-01-01") as string),
+    TzDate32("-144169-01-01,UTC"),
+    TzDate32("-144169-01-02,Europe/Moscow"),
+    TzDate32("-144169-01-01,America/Los_Angeles"),
+    cast(Date32("148107-12-31") as string),
+    TzDate32("148107-12-31,UTC"),
+    TzDate32("148108-01-01,Europe/Moscow"),
+    TzDate32("148107-12-31,America/Los_Angeles"),
+    cast(Date32("1-01-01") as string),
+    TzDate32("1-01-01,UTC"),
+    TzDate32("1-01-02,Europe/Moscow"),
+    cast(Date32("-1-12-31") as string),
+    TzDate32("-1-12-31,UTC"),
+    TzDate32("1-01-01,Europe/Moscow");
+
+select 
+    cast(Datetime64("-144169-01-01T00:00:00Z") as string),
+    TzDatetime64("-144169-01-01T00:00:00,UTC"),
+    TzDatetime64("-144169-01-01T02:30:17,Europe/Moscow"),
+    TzDatetime64("-144170-12-31T16:07:02,America/Los_Angeles"),
+    cast(Datetime64("148107-12-31T23:59:59Z") as string),
+    TzDatetime64("148107-12-31T23:59:59,UTC"),
+    TzDatetime64("148108-01-01T02:59:59,Europe/Moscow"),
+    TzDatetime64("148107-12-31T15:59:59,America/Los_Angeles"),
+    cast(Datetime64("1-01-01T00:00:00Z") as string),
+    TzDatetime64("1-01-01T00:00:00,UTC"),
+    TzDatetime64("1-01-01T02:30:17,Europe/Moscow"),
+    cast(Datetime64("-1-12-31T23:59:59Z") as string),
+    TzDatetime64("-1-12-31T23:59:59,UTC"),
+    TzDatetime64("1-01-01T02:30:16,Europe/Moscow");
+    
+select 
+    cast(Timestamp64("-144169-01-01T00:00:00Z") as string),
+    TzTimestamp64("-144169-01-01T00:00:00,UTC"),
+    TzTimestamp64("-144169-01-01T02:30:17,Europe/Moscow"),
+    TzTimestamp64("-144170-12-31T16:07:02,America/Los_Angeles"),
+    cast(Timestamp64("148107-12-31T23:59:59.999999Z") as string),
+    TzTimestamp64("148107-12-31T23:59:59.999999,UTC"),
+    TzTimestamp64("148108-01-01T02:59:59.999999,Europe/Moscow"),
+    TzTimestamp64("148107-12-31T15:59:59.999999,America/Los_Angeles"),
+    cast(Timestamp64("1-01-01T00:00:00Z") as string),
+    TzTimestamp64("1-01-01T00:00:00,UTC"),
+    TzTimestamp64("1-01-01T02:30:17,Europe/Moscow"),
+    cast(Timestamp64("-1-12-31T23:59:59.999999Z") as string),
+    TzTimestamp64("-1-12-31T23:59:59.999999,UTC"),
+    TzTimestamp64("1-01-01T02:30:16.999999,Europe/Moscow");
+