bzr commit into mysql-5.5-bugteam branch (azundris:3229) Bug#14959 Bug#52225 Bug#53409

[Tatiana Azundris Nurnberg]

#At file:///Users/tnurnberg/forest/53409/55-53409/ based on revid:dao-gang.qu@stripped

 3229 Tatiana Azundris Nurnberg	2011-01-06
      Bug#53409: Alter table can't rename a view with special characters
      Bug#14959
      Bug#52225
      
      Add missing test case for regular (non-NDB) server.
      We now try to handle database names with periods etc. correctly in ALTER.
     @ mysql-test/r/rename.result
        test
     @ mysql-test/t/rename.test
        test

    modified:
      mysql-test/r/rename.result
      mysql-test/t/rename.test
=== modified file 'mysql-test/r/rename.result'
--- a/mysql-test/r/rename.result	2010-05-28 05:25:11 +0000
+++ b/mysql-test/r/rename.result	2011-01-06 08:45:32 +0000
@@ -67,3 +67,13 @@ ERROR HY000: 'test.v1' is not BASE TABLE
 drop view v1;
 drop table t1;
 End of 5.0 tests
+#
+# Bug#53409: Alter table can't rename a view with special characters
+# see also: Bug#14959, Bug#52225
+#
+CREATE DATABASE `mysqltest.db`;
+CREATE TABLE `mysqltest.db`.t1 (f1 INT PRIMARY KEY, f2 INT);
+ALTER TABLE `mysqltest.db`.t1 ADD COLUMN f3 int;
+DROP TABLE `mysqltest.db`.t1;
+DROP DATABASE `mysqltest.db`;
+End of 5.5 tests

=== modified file 'mysql-test/t/rename.test'
--- a/mysql-test/t/rename.test	2010-05-28 05:25:11 +0000
+++ b/mysql-test/t/rename.test	2011-01-06 08:45:32 +0000
@@ -93,5 +93,17 @@ drop table t1;
 
 --echo End of 5.0 tests
 
+--echo #
+--echo # Bug#53409: Alter table can't rename a view with special characters
+--echo # see also: Bug#14959, Bug#52225
+--echo #
+CREATE DATABASE `mysqltest.db`;
+CREATE TABLE `mysqltest.db`.t1 (f1 INT PRIMARY KEY, f2 INT);
+ALTER TABLE `mysqltest.db`.t1 ADD COLUMN f3 int;
+DROP TABLE `mysqltest.db`.t1;
+DROP DATABASE `mysqltest.db`;
+
+--echo End of 5.5 tests
+
 --source include/wait_until_count_sessions.inc
 


Attachment: [text/bzr-bundle] bzr/[e-mail]