summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb_bug46000.test
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@sun.com>2009-11-05 17:23:50 +0400
committerSergey Vojtovich <svoj@sun.com>2009-11-05 17:23:50 +0400
commit345c79edf75f7be1a837b7a842120caa1cbfc7ff (patch)
treec5ca4c41c9f993d1d1999dd59bdbaf2107a9e335 /mysql-test/t/innodb_bug46000.test
parentced8719400333994131aac1662e95590c78271b7 (diff)
downloadmariadb-git-345c79edf75f7be1a837b7a842120caa1cbfc7ff.tar.gz
Updates for test cases from innodb-zip-ss6129.
Diffstat (limited to 'mysql-test/t/innodb_bug46000.test')
-rw-r--r--mysql-test/t/innodb_bug46000.test12
1 files changed, 5 insertions, 7 deletions
diff --git a/mysql-test/t/innodb_bug46000.test b/mysql-test/t/innodb_bug46000.test
index 80c18c58ef0..5a3c666326e 100644
--- a/mysql-test/t/innodb_bug46000.test
+++ b/mysql-test/t/innodb_bug46000.test
@@ -7,24 +7,22 @@
# This 'create table' operation should fail because of
# using the reserve name as its index name.
---error ER_CANT_CREATE_TABLE
+--error ER_WRONG_NAME_FOR_INDEX
create table bug46000(`id` int,key `GEN_CLUST_INDEX`(`id`))engine=innodb;
# Mixed upper/lower case of the reserved key words
---error ER_CANT_CREATE_TABLE
+--error ER_WRONG_NAME_FOR_INDEX
create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb;
-show errors;
+show warnings;
create table bug46000(id int) engine=innodb;
# This 'create index' operation should fail.
---replace_regex /'[^']*test.#sql-[0-9a-f_]*'/'#sql-temporary'/
---error ER_CANT_CREATE_TABLE
+--error ER_WRONG_NAME_FOR_INDEX
create index GEN_CLUST_INDEX on bug46000(id);
---replace_regex /'[^']*test.#sql-[0-9a-f_]*'/'#sql-temporary'/
-show errors;
+show warnings;
# This 'create index' operation should succeed, no
# temp table left from last failed create index