diff options
| author | Alexander Smirnov <alex@ydb.tech> | 2024-11-23 21:12:15 +0000 |
|---|---|---|
| committer | Alexander Smirnov <alex@ydb.tech> | 2024-11-23 21:12:15 +0000 |
| commit | 94a340fff420b50bea5bb806a5892d03b91036f1 (patch) | |
| tree | 7e069e905f29f9ae99d7e2a28baf864b8123648f /yql/essentials/tests/sql/suites/insert | |
| parent | 398fb410adba8fede893681a5e67a809f02d0750 (diff) | |
| parent | 8b9f13e29dea8f76f11579aae5344ac571d5e604 (diff) | |
| download | ydb-94a340fff420b50bea5bb806a5892d03b91036f1.tar.gz | |
Merge branch 'rightlib' into mergelibs-241123-2111
Diffstat (limited to 'yql/essentials/tests/sql/suites/insert')
19 files changed, 50 insertions, 0 deletions
diff --git a/yql/essentials/tests/sql/suites/insert/append-proto_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_proto_fail.cfg index 6d87958c65..6d87958c65 100644 --- a/yql/essentials/tests/sql/suites/insert/append-proto_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/append_proto_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql b/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql new file mode 100644 index 0000000000..437e165a80 --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/append_proto_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Table "Output" has udf remappers, append is not allowed*/ +insert into plato.Output +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/append-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_view_fail.cfg index db398a8d2f..db398a8d2f 100644 --- a/yql/essentials/tests/sql/suites/insert/append-view_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/append_view_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/append_view_fail.sql b/yql/essentials/tests/sql/suites/insert/append_view_fail.sql new file mode 100644 index 0000000000..3a9f61a60c --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/append_view_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Modification of "Output" view is not supported*/ +insert into plato.Output +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/append-with_read_udf_fail.cfg b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.cfg index 1d043c6420..1d043c6420 100644 --- a/yql/essentials/tests/sql/suites/insert/append-with_read_udf_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql new file mode 100644 index 0000000000..437e165a80 --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/append_with_read_udf_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Table "Output" has udf remappers, append is not allowed*/ +insert into plato.Output +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql b/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql index aa2f928459..a58b0d5d89 100644 --- a/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql +++ b/yql/essentials/tests/sql/suites/insert/fail_read_view_after_modify.sql @@ -1,5 +1,6 @@ /* postgres can not */ /* syntax version 1 */ +/* custom error:Table "Output" cannot have any view after replacing its content*/ insert into plato.Output with truncate select * from plato.Input; diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-nonstrict_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.cfg index 1f376d1f93..1f376d1f93 100644 --- a/yql/essentials/tests/sql/suites/insert/keepmeta-nonstrict_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql new file mode 100644 index 0000000000..4ca22363d6 --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_nonstrict_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Table "Output" has non-strict schema, truncate with keep meta is not allowed*/ +insert into plato.Output with (truncate, keepmeta) +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-proto_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.cfg index 6d87958c65..6d87958c65 100644 --- a/yql/essentials/tests/sql/suites/insert/keepmeta-proto_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql new file mode 100644 index 0000000000..57967fed0f --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_proto_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Table "Output" has udf remappers, truncate with keep meta is not allowed*/ +insert into plato.Output with (truncate, keepmeta) +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.cfg index db398a8d2f..db398a8d2f 100644 --- a/yql/essentials/tests/sql/suites/insert/keepmeta-view_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql new file mode 100644 index 0000000000..e4cea9e1cd --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_view_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Modification of "Output" view is not supported*/ +insert into plato.Output with (truncate, keepmeta) +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta-with_read_udf_fail.cfg b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.cfg index 1d043c6420..1d043c6420 100644 --- a/yql/essentials/tests/sql/suites/insert/keepmeta-with_read_udf_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql new file mode 100644 index 0000000000..57967fed0f --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/keepmeta_with_read_udf_fail.sql @@ -0,0 +1,6 @@ +/* postgres can not */ +/* multirun can not */ +/* custom error:Table "Output" has udf remappers, truncate with keep meta is not allowed*/ +insert into plato.Output with (truncate, keepmeta) +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/override-view_fail.cfg b/yql/essentials/tests/sql/suites/insert/override_view_fail.cfg index db398a8d2f..db398a8d2f 100644 --- a/yql/essentials/tests/sql/suites/insert/override-view_fail.cfg +++ b/yql/essentials/tests/sql/suites/insert/override_view_fail.cfg diff --git a/yql/essentials/tests/sql/suites/insert/override_view_fail.sql b/yql/essentials/tests/sql/suites/insert/override_view_fail.sql new file mode 100644 index 0000000000..9a2e8ed269 --- /dev/null +++ b/yql/essentials/tests/sql/suites/insert/override_view_fail.sql @@ -0,0 +1,5 @@ +/* postgres can not */ +/* custom error:Modification of "Output" view is not supported*/ +insert into plato.Output with truncate +select * from plato.Input; + diff --git a/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql b/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql index acf1795e35..befe8e1209 100644 --- a/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql +++ b/yql/essentials/tests/sql/suites/insert/use_anon_table_before_commit_fail.sql @@ -1,4 +1,5 @@ /* postgres can not */ +/* custom error:Anonymous table "@a" must be materialized. Use COMMIT before reading from it*/ use plato; insert into @a diff --git a/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql b/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql index 5d78422272..fcb33546b6 100644 --- a/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql +++ b/yql/essentials/tests/sql/suites/insert/use_anon_table_without_fill_fail.sql @@ -1,4 +1,5 @@ /* postgres can not */ +/* custom error:Anonymous table "@a" must be materialized. Use COMMIT before reading from it*/ use plato; select * from @a; |