summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-04-04 08:42:30 -0700
committerunknown <jimw@mysql.com>2005-04-04 08:42:30 -0700
commit9176a1f442252187a7c027570d8a843bb6edf549 (patch)
tree521fc32a390727cfd17585de58825e34062c1dd6 /mysql-test
parentee7f73d4533af5b66e2ba431ba33c496c089a5bc (diff)
parent07182f5aca265bb9686209fd608e3ca136cd6f49 (diff)
downloadmariadb-git-9176a1f442252187a7c027570d8a843bb6edf549.tar.gz
Merge bk-internal:/home/bk/mysql-4.1
into mysql.com:/home/jimw/my/mysql-4.1-clean
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/ctype_uca.result4
-rw-r--r--mysql-test/r/drop.result14
-rw-r--r--mysql-test/t/drop.test22
3 files changed, 38 insertions, 2 deletions
diff --git a/mysql-test/r/ctype_uca.result b/mysql-test/r/ctype_uca.result
index dd5a7ebf6a4..c6e803904a3 100644
--- a/mysql-test/r/ctype_uca.result
+++ b/mysql-test/r/ctype_uca.result
@@ -1759,8 +1759,8 @@ P,p
Ƥ,ƥ
Q,q
ĸ
-R,RR,Rr,r,rr,Ŕ,ŕ,Ŗ,ŗ,Ř,ř
-rR
+R,r,Ŕ,ŕ,Ŗ,ŗ,Ř,ř
+RR,Rr,rR,rr
Ʀ
S,s,Ś,ś,Ŝ,ŝ,Ş,ş,Š,š,ſ
SS,Ss,sS,ss,ß
diff --git a/mysql-test/r/drop.result b/mysql-test/r/drop.result
index 223ceb003b3..40dda86b729 100644
--- a/mysql-test/r/drop.result
+++ b/mysql-test/r/drop.result
@@ -24,6 +24,20 @@ n
drop database if exists mysqltest;
affected rows: 1
create database mysqltest;
+use mysqltest;
+drop table table1, table2, table3, table4, table5, table6,
+table7, table8, table9, table10, table11, table12, table13,
+table14, table15, table16, table17, table18, table19, table20,
+table21, table22, table23, table24, table25, table26, table27,
+table28;
+ERROR 42S02: Unknown table 'table1,table2,table3,table4,table5,table6,table7,table8,table9,table10,table11,table12,table13,table14,table15,table16,table17,table18,table19,table20,table21,table22,table23,table'
+drop table table1, table2, table3, table4, table5, table6,
+table7, table8, table9, table10, table11, table12, table13,
+table14, table15, table16, table17, table18, table19, table20,
+table21, table22, table23, table24, table25, table26, table27,
+table28, table29, table30;
+ERROR 42S02: Unknown table 'table1,table2,table3,table4,table5,table6,table7,table8,table9,table10,table11,table12,table13,table14,table15,table16,table17,table18,table19,table20,table21,table22,table23,table'
+use test;
drop database mysqltest;
flush tables with read lock;
create database mysqltest;
diff --git a/mysql-test/t/drop.test b/mysql-test/t/drop.test
index 6f0e5b3f14c..5e123ca0de8 100644
--- a/mysql-test/t/drop.test
+++ b/mysql-test/t/drop.test
@@ -30,6 +30,28 @@ select * from mysqltest.mysqltest;
drop database if exists mysqltest;
--disable_info
create database mysqltest;
+
+#
+# drop many tables - bug#3891
+# we'll do it in mysqltest db, to be able to use longer table names
+# (tableN instead on tN)
+#
+use mysqltest;
+--error 1051
+drop table table1, table2, table3, table4, table5, table6,
+table7, table8, table9, table10, table11, table12, table13,
+table14, table15, table16, table17, table18, table19, table20,
+table21, table22, table23, table24, table25, table26, table27,
+table28;
+
+--error 1051
+drop table table1, table2, table3, table4, table5, table6,
+table7, table8, table9, table10, table11, table12, table13,
+table14, table15, table16, table17, table18, table19, table20,
+table21, table22, table23, table24, table25, table26, table27,
+table28, table29, table30;
+
+use test;
drop database mysqltest;
# test drop/create database and FLUSH TABLES WITH READ LOCK