diff options
author | unknown <monty@donna.mysql.fi> | 2001-03-08 21:49:15 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.fi> | 2001-03-08 21:49:15 +0200 |
commit | 740465fc5b8ddcac301d8f0e651e5b3a8be8f802 (patch) | |
tree | 03e32a721d028e31fabafbbc929c8e90341c86e2 /mysql-test/t/delayed.test | |
parent | b99a376c5b269217289954bbe2ed2784db9c2a7a (diff) | |
download | mariadb-git-740465fc5b8ddcac301d8f0e651e5b3a8be8f802.tar.gz |
Fixed bug in INSERT DELAYED when INSERT generated an error
Docs/manual.texi:
Splitted INSERT syntax to different sub-sections
mysql-test/r/delayed.result:
Added new test that hanged INSERT DELAYED
mysql-test/t/delayed.test:
Added new test that hanged INSERT DELAYED
scripts/mysqldumpslow.sh:
Fix for new slow query log format
sql/field_conv.cc:
cleanup
Diffstat (limited to 'mysql-test/t/delayed.test')
-rw-r--r-- | mysql-test/t/delayed.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/delayed.test b/mysql-test/t/delayed.test index 15a85a09b8d..4bc1afa7612 100644 --- a/mysql-test/t/delayed.test +++ b/mysql-test/t/delayed.test @@ -15,3 +15,17 @@ insert into t1 set a = 8,tmsp=19711006010203; select * from t1 where tmsp=0; select * from t1 where tmsp=19711006010203; drop table t1; + +# +# Test bug when inserting NULL into an auto_increment field with +# INSERT DELAYED +# + +create table t1 (a int not null auto_increment primary key, b char(10)); +insert delayed into t1 values (1,"b"); +insert delayed into t1 values (null,"c"); +insert delayed into t1 values (3,"d"),(null,"e"); +--error 1136 +insert delayed into t1 values (3,"this will give an","error"); +select * from t1; +drop table t1; |