diff options
author | Sergei Golubchik <serg@mariadb.org> | 2018-10-19 20:18:34 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2018-10-19 20:18:41 +0200 |
commit | d851dd619f9e373c453355fd613088488e2c3d5c (patch) | |
tree | 151e3f51cd7bcfbb11d4e26a4107dddc2296de0d /mysql-test/t/lowercase_fs_off.test | |
parent | e31e697f17f79ffa6913499e7e2d29866f24b475 (diff) | |
download | mariadb-git-d851dd619f9e373c453355fd613088488e2c3d5c.tar.gz |
MDEV-13912 mysql_upgrade: case (in)sensitivity for stored procedures
mysql_upgrade used to convert all columns of mysql.db to
utf8_general_ci and then back to utf8_bin. In two separate ALTER's.
This failed if UNIQUE indexes in mysql.db contained entries
that differ only in the letter case.
Diffstat (limited to 'mysql-test/t/lowercase_fs_off.test')
-rw-r--r-- | mysql-test/t/lowercase_fs_off.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_fs_off.test b/mysql-test/t/lowercase_fs_off.test index 1be0351f9bc..8729efde02c 100644 --- a/mysql-test/t/lowercase_fs_off.test +++ b/mysql-test/t/lowercase_fs_off.test @@ -102,3 +102,13 @@ CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET new.a= 1; RENAME TABLE t1 TO T1; ALTER TABLE T1 RENAME t1; DROP TABLE t1; + +# +# MDEV-13912 mysql_upgrade: case (in)sensitivity for stored procedures +# +create database TEST; +create procedure TEST.pr() begin end; +create procedure test.pr() begin end; +--exec $MYSQL_UPGRADE --force 2>&1 +drop procedure test.pr; +drop database TEST; |