From 2611e8ec0c3abac191100ab5c8527ff21ba99d81 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 30 Oct 2007 12:51:57 +0400 Subject: 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. --- mysql-test/t/mysqlcheck.test | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'mysql-test/t/mysqlcheck.test') 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 -- cgit v1.2.1