diff options
| author | monty@narttu.mysql.fi <> | 2003-03-18 02:51:16 +0200 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-03-18 02:51:16 +0200 |
| commit | 85de222334f89a95bb60554b537d84c3bdc5a627 (patch) | |
| tree | 56e522f3b2b2b8377449166173697dc2e9f1e7ff /mysql-test/t/innodb.test | |
| parent | d9dfba6e5c68c4aad569856f37cc037cfe02c18f (diff) | |
| download | mariadb-git-85de222334f89a95bb60554b537d84c3bdc5a627.tar.gz | |
Fix of 'halloween bug' with UPDATE of InnoDB tables.
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index a962f120d4e..0362ec69ebf 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -537,3 +537,14 @@ drop table t1; create table t1 (testint int not null default 1) type=innodb; desc t1; drop table t1; + +# +# Check update with conflicting key +# + +CREATE TABLE t1 (a int not null primary key, b int not null, unique (b)) type=innodb; +INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9); +# We need the a < 1000 test here to quard against the halloween problems +UPDATE t1 set a=a+100 where b between 2 and 3 and a < 1000; +SELECT * from t1; +drop table t1; |