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/select/data_instance.sql b/yql/essentials/tests/sql/suites/select/data_instance.sql
new file mode 100644
index 0000000000..457d2d110c
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/select/data_instance.sql
@@ -0,0 +1,45 @@
+/* postgres can not */
+select Bool("true");
+select Bool("FalsE");
+select Int8("-128");
+select Int8("127");
+select Uint8("0");
+select Uint8("255");
+select Int16("-32768");
+select Int16("32767");
+select Uint16("0");
+select Uint16("65535");
+select Int32("-2147483648");
+select Int32("2147483647");
+select Uint32("0");
+select Uint32("4294967295");
+select Int64("-9223372036854775808");
+select Int64("9223372036854775807");
+select Uint64("0");
+select Uint64("18446744073709551615");
+select Float("0");
+select Float("1");
+select Float("-1e30");
+select Float("-inf");
+select Float("+inf");
+select Float("nan");
+select Double("0");
+select Double("1");
+select Double("-1e300");
+select Double("-inf");
+select Double("+inf");
+select Double("nan");
+select String("foo\xffbar");
+select Utf8("привет");
+select Yson("<a=1>[3;%false]");
+select Json(@@{"a":1,"b":null}@@);
+select cast(Date("2000-01-01") as string);
+select cast(Datetime("2000-01-01T01:02:03Z") as string);
+select cast(Timestamp("2000-01-01T01:02:03.4Z") as string);
+select cast(Interval("P1DT12H") as string);
+select TZDATE("2010-07-01,Europe/Moscow");
+select TZDATE("2010-07-01,America/Los_Angeles");
+select TZDATETIME("2010-07-01T00:00:00,Europe/Moscow");
+select TZTIMESTAMP("2010-07-01T00:00:00,America/Los_Angeles");
+select TZTIMESTAMP("2010-07-01T12:00:00.123456,Europe/Moscow");
+select Uuid('550e8400-e29b-41d4-a716-446655440000');