diff options
author | monty@donna.mysql.fi <> | 2001-05-09 23:02:36 +0300 |
---|---|---|
committer | monty@donna.mysql.fi <> | 2001-05-09 23:02:36 +0300 |
commit | 965cd30f8779bc28a3c7181c64f8880b04b334d7 (patch) | |
tree | 288f7cc7d0ca91ae340b7a568971bb02d8eb798d /mysql-test/t/innodb.test | |
parent | 33fa6e04cc0ec389d07cf0aa59db59c8d67c41eb (diff) | |
download | mariadb-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.test | 20 |
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; |