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/original/cases/delete.sql b/yql/essentials/tests/postgresql/original/cases/delete.sql
new file mode 100644
index 0000000000..d8cb99e93c
--- /dev/null
+++ b/yql/essentials/tests/postgresql/original/cases/delete.sql
@@ -0,0 +1,25 @@
+CREATE TABLE delete_test (
+    id SERIAL PRIMARY KEY,
+    a INT,
+    b text
+);
+
+INSERT INTO delete_test (a) VALUES (10);
+INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000));
+INSERT INTO delete_test (a) VALUES (100);
+
+-- allow an alias to be specified for DELETE's target table
+DELETE FROM delete_test AS dt WHERE dt.a > 75;
+
+-- if an alias is specified, don't allow the original table name
+-- to be referenced
+DELETE FROM delete_test dt WHERE delete_test.a > 25;
+
+SELECT id, a, char_length(b) FROM delete_test;
+
+-- delete a row with a TOASTed value
+DELETE FROM delete_test WHERE a > 25;
+
+SELECT id, a, char_length(b) FROM delete_test;
+
+DROP TABLE delete_test;