From a54adfc3ab4d6fcb20570202d33495e2b6ffd613 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 7 Feb 2004 02:22:12 +0400 Subject: fixed bug #2592 mysqldump doesn't quote "tricky" names correctly mysql-test/r/mysqldump.result: added test for bug #2592 mysqldump doesn't quote "tricky" names correctly please note, output's still looking wrong because of bug #2593 it will be fixed when fix for bug #2593 will be pushed mysql-test/t/mysqldump.test: added test for bug #2592 mysqldump doesn't quote "tricky" names correctly sql/sql_lex.cc: fixed processing of multibyte quoted variables --- mysql-test/r/mysqldump.result | 18 ++++++++++++++++++ mysql-test/t/mysqldump.test | 8 ++++++++ 2 files changed, 26 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index f51caee39d6..651a33ac1db 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -123,3 +123,21 @@ UNLOCK TABLES; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; DROP TABLE t1; +create table ```a` (i int); +DROP TABLE IF EXISTS ```a`; +CREATE TABLE ``a` ( + `i` int(11) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + + +/*!40000 ALTER TABLE ```a` DISABLE KEYS */; +LOCK TABLES ```a` WRITE; +UNLOCK TABLES; +/*!40000 ALTER TABLE ```a` ENABLE KEYS */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; + +drop table ```a`; diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index 93b0dd4a75d..e6115b61bbf 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -53,3 +53,11 @@ CREATE TABLE t1 (a VARCHAR(255)) DEFAULT CHARSET koi8r; INSERT INTO t1 VALUES (_koi8r x'C1C2C3C4C5'); --exec $MYSQL_DUMP --skip-comments test t1 DROP TABLE t1; + +# +# Bug #2592 +# + +create table ```a` (i int); +--exec $MYSQL_DUMP --skip-comments test +drop table ```a`; \ No newline at end of file -- cgit v1.2.1 From aaa35925ac66b00eb1fcee5e4bcc9c05472f6950 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 10 Feb 2004 18:44:27 +0400 Subject: added skiped newline to the end of file mysql-test/t/mysqldump.test mysql-test/t/mysqldump.test: added skiped newline to the end of file --- mysql-test/t/mysqldump.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test') diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index e6115b61bbf..eca83ce77d8 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -60,4 +60,4 @@ DROP TABLE t1; create table ```a` (i int); --exec $MYSQL_DUMP --skip-comments test -drop table ```a`; \ No newline at end of file +drop table ```a`; -- cgit v1.2.1 From e4f3eb79be9dc5da27097f73e9477d9318373105 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 10 Feb 2004 19:29:28 +0400 Subject: correcting mysql-test/r/mysqldump.result after merge mysql-test/r/mysqldump.result: correcting result after merge --- mysql-test/r/mysqldump.result | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index 37a604258d9..fd9e2a1f42b 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -180,6 +180,11 @@ UNLOCK TABLES; DROP TABLE t1; create table ```a` (i int); + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT, CHARACTER_SET_CLIENT=utf8 */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */; DROP TABLE IF EXISTS ```a`; CREATE TABLE ``a` ( `i` int(11) default NULL -- cgit v1.2.1