diff options
Diffstat (limited to 'mysql-test/t/innodb-replace.test')
| -rw-r--r-- | mysql-test/t/innodb-replace.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/innodb-replace.test b/mysql-test/t/innodb-replace.test new file mode 100644 index 00000000000..e7e96da1443 --- /dev/null +++ b/mysql-test/t/innodb-replace.test @@ -0,0 +1,17 @@ +-- source include/have_innodb.inc +# embedded server ignores 'delayed', so skip this +-- source include/not_embedded.inc + +# +# Bug #1078 +# +create table t1 (c1 char(5) unique not null, c2 int, stamp timestamp) engine=innodb; +select * from t1; +--error 1031 +replace delayed into t1 (c1, c2) values ( "text1","11"),( "text2","12"); +select * from t1; +--error 1031 +replace delayed into t1 (c1, c2) values ( "text1","12"),( "text2","13"),( "text3","14", "a" ),( "text4","15", "b" ); +select * from t1; +drop table t1; + |