diff options
author | Lena Startseva <lena.startseva@mariadb.com> | 2022-06-09 10:32:51 +0700 |
---|---|---|
committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 17:36:20 +0700 |
commit | 72ba96a48eb3e99a967e0489cc79f378e865e3fd (patch) | |
tree | d68b640bd3b6f71c4c7e13967776a13aa29965a2 /mysql-test/main/sp-security-anchor-type.test | |
parent | 1dd6255ffef901dddcff2191ddf975a2019799d9 (diff) | |
download | mariadb-git-72ba96a48eb3e99a967e0489cc79f378e865e3fd.tar.gz |
MDEV-27691: make working view-protocol
Tests with checking metadata or that cannot be run with
the view-protocol are excluded from --view-protocol.
For tests that do not allow the use of an additional connection,
the util connection is disabled with "--disable_service_connection".
Also cases with bugs for --view-protocol are disabled.
Diffstat (limited to 'mysql-test/main/sp-security-anchor-type.test')
-rw-r--r-- | mysql-test/main/sp-security-anchor-type.test | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/main/sp-security-anchor-type.test b/mysql-test/main/sp-security-anchor-type.test index e61d5e38052..1aefa724f67 100644 --- a/mysql-test/main/sp-security-anchor-type.test +++ b/mysql-test/main/sp-security-anchor-type.test @@ -89,6 +89,7 @@ DROP PROCEDURE p1; --echo # DEFINER root, SQL SECURITY INVOKER --echo # +--disable_service_connection connection default; DELIMITER $$; CREATE PROCEDURE p1() @@ -160,7 +161,7 @@ DROP PROCEDURE p1; --echo # Stored function: Using TYPE OF for with a table that we don't have access to --echo # DEFINER user1, SQL SECURITY DEFAULT --echo # - +--disable_view_protocol CREATE TABLE t1 (a INT); DELIMITER $$; CREATE FUNCTION f1() RETURNS INT @@ -197,7 +198,7 @@ connection conn1; SELECT f1(); DROP FUNCTION f1; DROP TABLE t1; - +--enable_view_protocol --echo # --echo # Stored function: Using TYPE OF for with a table that we don't have access to @@ -269,7 +270,7 @@ INSERT INTO t1 (a) VALUES (10); SELECT * FROM t1; DROP TRIGGER tr1; DROP TABLE t1; - +--enable_service_connection --echo # |