diff options
author | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-06-07 00:39:15 +0700 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2021-06-17 19:30:24 +0200 |
commit | b126c3f3fa2de565ec6737cdfac902cd34d0515b (patch) | |
tree | c68ce2909d80e20eb838612ab25ba526f8179391 /mysql-test/main/ps_ddl.test | |
parent | fc71746a6a75e2b24a50a6c3afb026a667d409c6 (diff) | |
download | mariadb-git-b126c3f3fa2de565ec6737cdfac902cd34d0515b.tar.gz |
MDEV-16708: fixed issue with handling of the directive --enable-prepared-warnings in mysqltest
Diffstat (limited to 'mysql-test/main/ps_ddl.test')
-rw-r--r-- | mysql-test/main/ps_ddl.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/ps_ddl.test b/mysql-test/main/ps_ddl.test index 5a2a0f60a70..8d811ec00c0 100644 --- a/mysql-test/main/ps_ddl.test +++ b/mysql-test/main/ps_ddl.test @@ -63,6 +63,7 @@ drop view if exists v1, v2; TRUNCATE TABLE mysql.general_log; delimiter |; +--enable_prepare_warnings create procedure p_verify_reprepare_count(expected int) begin declare old_reprepare_count int default @reprepare_count; @@ -80,6 +81,7 @@ begin select '' as "SUCCESS"; end if; end| +--disable_prepare_warnings delimiter ;| set @reprepare_count= 0; flush status; @@ -902,14 +904,18 @@ begin return x; end| delimiter ;| +--enable_prepare_warnings create procedure p1(out x int) select max(a) from t1 into x; +--disable_prepare_warnings prepare stmt from "select * from v1"; execute stmt; execute stmt; call p_verify_reprepare_count(0); drop procedure p1; +--enable_prepare_warnings create procedure p1(out x int) select max(a) from t2 into x; +--disable_prepare_warnings --echo # XXX: used to be a bug. The prelocked list was not invalidated --echo # and we kept opening table t1, whereas the procedure --echo # is now referring to table t2 |