YQL-19206 Move contrib/ydb/library/yql/tests/postgresql -> yql/essentials/tests/postgresql

commit_hash:46fdf59714b20cf2b61233a06e58365227d3c8b2

1 files changed, 34 insertions, 0 deletions

diff --git a/yql/essentials/tests/postgresql/initscripts/timetz_tbl.sql b/yql/essentials/tests/postgresql/initscripts/timetz_tbl.sql
new file mode 100644
index 0000000000..08b52e8a41
--- /dev/null
+++ b/yql/essentials/tests/postgresql/initscripts/timetz_tbl.sql
@@ -0,0 +1,34 @@
+CREATE TABLE TIMETZ_TBL (f1 time(2) with time zone);
+
+/*
+originals:
+
+INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('07:07 PST');
+INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT');
+INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT');
+INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT');
+INSERT INTO TIMETZ_TBL VALUES ('2003-03-07 15:36:39 America/New_York');
+INSERT INTO TIMETZ_TBL VALUES ('2003-07-07 15:36:39 America/New_York');
+
+Restore 'em after timezone got supported in literals
+*/
+
+INSERT INTO TIMETZ_TBL VALUES ('00:01-07');
+INSERT INTO TIMETZ_TBL VALUES ('01:00-07');
+INSERT INTO TIMETZ_TBL VALUES ('02:03-07');
+INSERT INTO TIMETZ_TBL VALUES ('07:07-08');
+INSERT INTO TIMETZ_TBL VALUES ('08:08-04');
+INSERT INTO TIMETZ_TBL VALUES ('11:59-07');
+INSERT INTO TIMETZ_TBL VALUES ('12:00-07');
+INSERT INTO TIMETZ_TBL VALUES ('12:01-07');
+INSERT INTO TIMETZ_TBL VALUES ('23:59-07');
+INSERT INTO TIMETZ_TBL VALUES ('23:59:59.99-07');
+INSERT INTO TIMETZ_TBL VALUES ('15:36:39-05');
+INSERT INTO TIMETZ_TBL VALUES ('15:36:39-04');
+