diff options
Diffstat (limited to 'mysql-test/t/replace.test')
-rw-r--r-- | mysql-test/t/replace.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/replace.test b/mysql-test/t/replace.test index 100941108c8..e9e01615a62 100644 --- a/mysql-test/t/replace.test +++ b/mysql-test/t/replace.test @@ -20,3 +20,17 @@ replace into t1 (gesuchnr,benutzer_id) values (1,1); alter table t1 type=heap; replace into t1 (gesuchnr,benutzer_id) values (1,1); drop table t1; + +# +# Test when using replace on a key that has used up it's whole range +# + +create table t1 (a tinyint not null auto_increment primary key, b char(20)); +insert into t1 values (126,"first"),(0,"last"); +--error 1062 +insert into t1 values (0,"error"); +--error 1062 +replace into t1 values (0,"error"); +replace into t1 values (126,"first updated"); +select * from t1; +drop table t1; |