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

commit_hash:46fdf59714b20cf2b61233a06e58365227d3c8b2

1 files changed, 24 insertions, 0 deletions

diff --git a/yql/essentials/tests/postgresql/cases/create_misc.sql b/yql/essentials/tests/postgresql/cases/create_misc.sql
new file mode 100644
index 0000000000..566dbff19c
--- /dev/null
+++ b/yql/essentials/tests/postgresql/cases/create_misc.sql
@@ -0,0 +1,24 @@
+--
+-- CREATE_MISC
+--
+-- CLASS POPULATION
+--	(any resemblance to real life is purely coincidental)
+--
+INSERT INTO tenk2 SELECT * FROM tenk1;
+INSERT INTO hobbies_r (name) VALUES ('skywalking');
+INSERT INTO equipment_r (name, hobby) VALUES ('advil', 'posthacking');
+INSERT INTO equipment_r (name, hobby) VALUES ('peet''s coffee', 'posthacking');
+INSERT INTO equipment_r (name, hobby) VALUES ('hightops', 'basketball');
+INSERT INTO equipment_r (name, hobby) VALUES ('guts', 'skywalking');
+--
+-- for internal portal (cursor) tests
+--
+CREATE TABLE iportaltest (
+	i		int4,
+	d		float4,
+	p		polygon
+);
+INSERT INTO iportaltest (i, d, p)
+   VALUES (1, 3.567, '(3.0,1.0),(4.0,2.0)'::polygon);
+INSERT INTO iportaltest (i, d, p)
+   VALUES (2, 89.05, '(4.0,2.0),(3.0,1.0)'::polygon);