summaryrefslogtreecommitdiff
path: root/mysql-test/t/drop.test
diff options
context:
space:
mode:
authorunknown <tsmith@rhel5-ia64-a.mysql.com>2008-03-27 08:20:25 +0100
committerunknown <tsmith@rhel5-ia64-a.mysql.com>2008-03-27 08:20:25 +0100
commit45ebe9953385f48f99058eaedf448bb6ff8caeaa (patch)
tree1cd9471bfb066e2ed5fdc557a5948b95230098ec /mysql-test/t/drop.test
parent27c0540bd8e785499accbd4777bdb5067911cce9 (diff)
parent19afc9d9e75b44c01e254300913b716798c40108 (diff)
downloadmariadb-git-45ebe9953385f48f99058eaedf448bb6ff8caeaa.tar.gz
Merge tsmith@bk-internal.mysql.com:/home/bk/mysql-5.1
into rhel5-ia64-a.mysql.com:/data0/tsmith/build/51 sql/mysqld.cc: Auto merged sql/sql_acl.cc: Auto merged sql/sql_class.cc: Auto merged mysql-test/r/drop.result: SCCS merged mysql-test/t/drop.test: SCCS merged
Diffstat (limited to 'mysql-test/t/drop.test')
-rw-r--r--mysql-test/t/drop.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/drop.test b/mysql-test/t/drop.test
index 7c60c7daf69..2c490b51afc 100644
--- a/mysql-test/t/drop.test
+++ b/mysql-test/t/drop.test
@@ -168,4 +168,19 @@ DROP DATABASE mysql_test;
###########################################################################
--echo
+#
+# Bug#26703: DROP DATABASE fails if database contains a #mysql50# table with backticks
+#
+create database mysqltestbug26703;
+use mysqltestbug26703;
+create table `#mysql50#abc``def` ( id int );
+--error ER_WRONG_TABLE_NAME
+create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
+create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
+create table `#mysql50#aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
+--error ER_WRONG_TABLE_NAME
+create table `#mysql50#aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
+use test;
+drop database mysqltestbug26703;
+
--echo End of 5.1 tests