summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authormonty@donna.mysql.fi <>2001-05-09 23:02:36 +0300
committermonty@donna.mysql.fi <>2001-05-09 23:02:36 +0300
commit965cd30f8779bc28a3c7181c64f8880b04b334d7 (patch)
tree288f7cc7d0ca91ae340b7a568971bb02d8eb798d /mysql-test/t/innodb.test
parent33fa6e04cc0ec389d07cf0aa59db59c8d67c41eb (diff)
downloadmariadb-git-965cd30f8779bc28a3c7181c64f8880b04b334d7.tar.gz
Applied patches for BDB tables
Fixes to InnoDB to compile on Windows Fix for temporary InnoDB tables Fixed bug in REPLACE() Fixed sub char keys for InnoDB
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r--mysql-test/t/innodb.test20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index 60e29ca33c4..cef53ce8165 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -456,3 +456,23 @@ commit;
select id,id3 from t1;
UNLOCK TABLES;
DROP TABLE t1;
+
+#
+# Test prefix key
+#
+--error 1089
+create table t1 (a char(20), unique (a(5))) type=innodb;
+create table t1 (a char(20), index (a(5))) type=innodb;
+show create table t1;
+drop table t1;
+
+#
+# Test using temporary table and auto_increment
+#
+
+create temporary table t1 (a int not null auto_increment, primary key(a)) type=innodb;
+insert into t1 values (NULL),(NULL),(NULL);
+delete from t1 where a=3;
+insert into t1 values (NULL);
+select * from t1;
+drop table t1;