summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2003-08-22 18:21:23 +0200
committerunknown <serg@serg.mylan>2003-08-22 18:21:23 +0200
commit619c0d89c6a5162ec4e7cf24a61ee5d38e9300bd (patch)
tree52284824971396f6df057ab4248a52496c321c23 /mysql-test/t/innodb.test
parentc1551b4c04a68699872d80b7e1b9e5a969e4ff72 (diff)
downloadmariadb-git-619c0d89c6a5162ec4e7cf24a61ee5d38e9300bd.tar.gz
bug #1078. two innodb+delayed crashes
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r--mysql-test/t/innodb.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index 635a15baa41..cd3a5693535 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -906,3 +906,17 @@ SELECT t2.id, t1.label FROM t2 INNER JOIN
(SELECT t1.id_object as id_object FROM t1 WHERE t1.label LIKE '%test%') AS lbl
ON (t2.id = lbl.id_object) INNER JOIN t1 ON (t2.id = t1.id_object);
drop table t1,t2;
+
+#
+# Bug #1078
+#
+create table t1 (c1 char(5) unique not null, c2 int, stamp timestamp) type=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;
+