summaryrefslogtreecommitdiff
path: root/mysql-test/main/sp.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2019-09-06 11:53:10 +0200
committerSergei Golubchik <serg@mariadb.org>2019-09-06 11:53:10 +0200
commit244f0e6dd815b388282c15db4fe7f15533f4c8fc (patch)
treeaf138f2b3739a742c0c38173cdc86ec176fc0edd /mysql-test/main/sp.test
parent18af13b88ba580562981a190c25da128a2e9db26 (diff)
parent2842c369851a8afc2a944ce6f4f60fa052f20969 (diff)
downloadmariadb-git-244f0e6dd815b388282c15db4fe7f15533f4c8fc.tar.gz
Merge branch '10.3' into 10.4
Diffstat (limited to 'mysql-test/main/sp.test')
-rw-r--r--mysql-test/main/sp.test14
1 files changed, 12 insertions, 2 deletions
diff --git a/mysql-test/main/sp.test b/mysql-test/main/sp.test
index 3e4b3418a2d..9aec4627c2c 100644
--- a/mysql-test/main/sp.test
+++ b/mysql-test/main/sp.test
@@ -14,6 +14,11 @@
# Tests that require --with-geometry go into sp_gis.test
# Tests that require multibyte character sets, which are not always available,
# go into separate files (e.g. sp-ucs2.test)
+
+--source include/default_charset.inc
+set @save_character_set_client=@@character_set_client;
+set @save_userstat=@@global.userstat, @@global.userstat= 0;
+
use test;
# Test tables
@@ -4087,7 +4092,8 @@ call bug6063()|
call bug7088_1()|
call bug7088_2()|
-set character set default|
+set @@character_set_client=@save_character_set_client|
+set @@character_set_results=@save_character_set_client|
show create procedure bug6063|
show create procedure bug7088_1|
@@ -7352,7 +7358,8 @@ DELIMITER ;|
CALL p1();
-SET NAMES default;
+set @@character_set_client=@save_character_set_client;
+set @@character_set_results=@save_character_set_client;
DROP PROCEDURE p1;
#
@@ -8228,6 +8235,7 @@ drop procedure p;
#
# Bug#43962 "Packets out of order" calling a SHOW TABLE STATUS
#
+
DELIMITER //;
CREATE DEFINER = 'root'@'localhost' PROCEDURE p1()
NOT DETERMINISTIC
@@ -9057,6 +9065,7 @@ DROP PROCEDURE p1;
--echo # End of 5.5 test
#MDEV-17610
+FLUSH USER_STATISTICS;
CREATE PROCEDURE sp() ALTER TABLE non_existing_table OPTIMIZE PARTITION p0;
CALL sp;
SELECT 1;
@@ -10341,6 +10350,7 @@ call p4();
drop procedure p4;
drop table t1;
set @@sql_mode=@save_sql_mode;
+set @@global.userstat= @save_userstat;
--echo #
--echo # MDEV-17363 Compressed columns cannot be restored from dump