summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authormonty@hundin.mysql.fi <>2002-03-12 11:38:22 +0200
committermonty@hundin.mysql.fi <>2002-03-12 11:38:22 +0200
commita01775c5ebf9d6a8386621f01408514f82bab1da (patch)
treec217663c9f7a4fba0c5a00acb72b3e980954f780 /mysql-test/t
parented8fc0b0c647dbcd86ecc09f8c15ecd82c0e223e (diff)
downloadmariadb-git-a01775c5ebf9d6a8386621f01408514f82bab1da.tar.gz
Added help for --local-infile
Fix for bug on intel where (int32) 1 << 32 == 1, which gave problems when using 32 keys. Allow SET PASSWORD for anonymous user
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/create.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index d45d013c9fb..1a829eec6a3 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -69,3 +69,11 @@ create table t2 (key (b)) select * from t1;
explain select * from t2 where b="world";
select * from t2 where b="world";
drop table t1,t2;
+
+#
+# Test of primary key with 32 index
+#
+
+create table t1 (a int not null, b int, primary key(a), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b));
+show create table t1;
+drop table t1;