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

commit_hash:46fdf59714b20cf2b61233a06e58365227d3c8b2

1 files changed, 25 insertions, 0 deletions

diff --git a/yql/essentials/tests/postgresql/cases/insert.sql b/yql/essentials/tests/postgresql/cases/insert.sql
new file mode 100644
index 0000000000..deceb2192b
--- /dev/null
+++ b/yql/essentials/tests/postgresql/cases/insert.sql
@@ -0,0 +1,25 @@
+--
+-- insert with DEFAULT in the target_list
+--
+create table inserttest (col1 int4, col2 int4 NOT NULL, col3 text default 'testing');
+--
+-- TOASTed value test
+--
+insert into inserttest values(30, 50, repeat('x', 10000));
+drop table inserttest;
+create table inserttest (f1 int, f2 int[],
+                         f3 insert_test_type, f4 insert_test_type[]);
+-- also check reverse-listing
+create table inserttest2 (f1 bigint, f2 text);
+drop table inserttest2;
+drop table inserttest;
+create table mlparted2 (b int not null, a int not null);
+create table mlparted5a (a int not null, c text, b int not null);
+create table mlparted5_b (d int, b int, c text, a int);
+-- check that the message shows the appropriate column description in a
+-- situation where the partitioned table is not the primary ModifyTable node
+create table inserttest3 (f1 text default 'foo', f2 text default 'bar', f3 int);
+drop table inserttest3;
+create table donothingbrtrig_test1 (b text, a int);
+create table donothingbrtrig_test2 (c text, b text, a int);
+create table returningwrtest2 (b text, c int, a int);