summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysqlcheck.test
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-10-30 12:51:57 +0400
committerunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-10-30 12:51:57 +0400
commit2611e8ec0c3abac191100ab5c8527ff21ba99d81 (patch)
tree92a047d7a9abf8a421ab94c284c154a9cc0a887e /mysql-test/t/mysqlcheck.test
parent432d42e70c3b65b16604cb4acb212e3f628d9df5 (diff)
downloadmariadb-git-2611e8ec0c3abac191100ab5c8527ff21ba99d81.tar.gz
Fix for bug #30654: mysqlcheck fails during upgrade of tables whose
names include backticks or blank Problem: mysqlcheck doesn't escape backtick characters in the table names. Fix: escape them. client/mysqlcheck.c: Fix for bug #30654: mysqlcheck fails during upgrade of tables whose names include backticks or blank - escape backtick characters in the table names. mysql-test/r/mysqlcheck.result: Fix for bug #30654: mysqlcheck fails during upgrade of tables whose names include backticks or blank - test result. mysql-test/t/mysqlcheck.test: Fix for bug #30654: mysqlcheck fails during upgrade of tables whose names include backticks or blank - test case.
Diffstat (limited to 'mysql-test/t/mysqlcheck.test')
-rw-r--r--mysql-test/t/mysqlcheck.test11
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/mysqlcheck.test b/mysql-test/t/mysqlcheck.test
index f4e18d4004f..04e7b6b4bdb 100644
--- a/mysql-test/t/mysqlcheck.test
+++ b/mysql-test/t/mysqlcheck.test
@@ -2,7 +2,7 @@
#
--disable_warnings
-DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t1, `t``1`, `t 1`;
drop view if exists v1;
drop database if exists client_test_db;
--enable_warnings
@@ -31,4 +31,13 @@ create view v1 as select * from t1;
drop view v1;
drop table t1;
+#
+# Bug #30654: mysqlcheck fails during upgrade of tables whose names include backticks
+#
+create table `t``1`(a int);
+create table `t 1`(a int);
+--replace_result 'Table is already up to date' OK
+--exec $MYSQL_CHECK --databases test
+drop table `t``1`, `t 1`;
+
--echo End of 5.0 tests