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

Library import 241120-1113

1 files changed, 45 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/bigdate/input_interval64.sql b/yql/essentials/tests/sql/suites/bigdate/input_interval64.sql
new file mode 100644
index 0000000000..47627b6003
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/bigdate/input_interval64.sql
@@ -0,0 +1,45 @@
+select cast("-P106751616DT23H59M59.999999S" as interval64), cast(cast("-P106751616DT23H59M59.999999S" as interval64) as string);
+select cast("P106751616DT23H59M59.999999S" as interval64), cast(cast("P106751616DT23H59M59.999999S" as interval64) as string);
+
+select cast("-P106751616DT23H59M60S" as interval64), cast(cast("-P106751616DT23H59M60S" as interval64) as string);
+select cast("P106751616DT23H59M60S" as interval64), cast(cast("P106751616DT23H59M60S" as interval64) as string);
+
+select cast("P000000000DT00H00M00.000000S" as interval64), cast(cast("P000000000DT00H00M00.000000S" as interval64) as string);
+select cast("PT0S" as interval64), cast(cast("PT0S" as interval64) as string);
+select cast("-PT0S" as interval64), cast(cast("-PT0S" as interval64) as string);
+select cast("PT0.000001S" as interval64), cast(cast("PT0.000001S" as interval64) as string);
+select cast("-PT0.000001S" as interval64), cast(cast("-PT0.000001S" as interval64) as string);
+
+select cast("PT0S" as interval64), cast(cast("PT0S" as interval64) as string);
+select cast("PT0M" as interval64), cast(cast("PT0M" as interval64) as string);
+select cast("PT0H" as interval64), cast(cast("PT0H" as interval64) as string);
+select cast("P0D" as interval64), cast(cast("P0D" as interval64) as string);
+select cast("P0W" as interval64), cast(cast("P0W" as interval64) as string);
+
+select cast("PT999999S" as interval64), cast(cast("PT999999S" as interval64) as string);
+select cast("PT999999M" as interval64), cast(cast("PT999999M" as interval64) as string);
+select cast("PT999999H" as interval64), cast(cast("PT999999H" as interval64) as string);
+
+select cast("P106751616D" as interval64), cast(cast("P106751616D" as interval64) as string);
+select cast("P106751617D" as interval64), cast(cast("P106751617D" as interval64) as string);
+select cast("P15250230W" as interval64), cast(cast("P15250230W" as interval64) as string);
+select cast("P15250231W" as interval64), cast(cast("P15250231W" as interval64) as string);
+
+select cast("PT0000000S" as interval64), cast(cast("PT0000000S" as interval64) as string);
+select cast("PT0000000M" as interval64), cast(cast("PT0000000M" as interval64) as string);
+select cast("PT0000000H" as interval64), cast(cast("PT0000000H" as interval64) as string);
+select cast("P0000000000D" as interval64), cast(cast("P0000000000D" as interval64) as string);
+select cast("P0000000000W" as interval64), cast(cast("P0000000000W" as interval64) as string);
+
+select cast("PT1S" as interval64), cast(cast("PT1S" as interval64) as string);
+select cast("PT1M" as interval64), cast(cast("PT1M" as interval64) as string);
+select cast("PT1H" as interval64), cast(cast("PT1H" as interval64) as string);
+select cast("P1D" as interval64), cast(cast("P1D" as interval64) as string);
+select cast("P1W" as interval64), cast(cast("P1W" as interval64) as string);
+
+select cast("-PT1S" as interval64), cast(cast("-PT1S" as interval64) as string);
+select cast("-PT1M" as interval64), cast(cast("-PT1M" as interval64) as string);
+select cast("-PT1H" as interval64), cast(cast("-PT1H" as interval64) as string);
+select cast("-P1D" as interval64), cast(cast("-P1D" as interval64) as string);
+select cast("-P1W" as interval64), cast(cast("-P1W" as interval64) as string);
+