From 235c5035b5d894c40a9f0d8cd23d17541eb8cd6a Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 7 Sep 2004 12:45:19 +0200 Subject: Fix for INSERT with multiple values and start/end_bulk_insert mysql-test/r/ndb_insert.result: Add tests for duplicate keys in combination with start/end_bulk_insert mysql-test/t/ndb_insert.test: Add tests for duplicate keys in combination with start/end_bulk_insert sql/ha_ndbcluster.cc: Set my_errno if error occurs in end_bulk_insert --- mysql-test/t/ndb_insert.test | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/ndb_insert.test b/mysql-test/t/ndb_insert.test index c55a925dca2..a448e413f1d 100644 --- a/mysql-test/t/ndb_insert.test +++ b/mysql-test/t/ndb_insert.test @@ -429,5 +429,34 @@ INSERT INTO t1 VALUES SELECT COUNT(*) FROM t1; +# +# Insert duplicate rows +# +--error 1062 +INSERT INTO t1 VALUES +(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), +(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); + + + +begin; + +# +# Insert duplicate rows, inside transaction +# +--error 1062 +INSERT INTO t1 VALUES +(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), +(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); + +commit; + +# +# Insert duplicate rows using "insert .. select" + +# +--error 1062 +insert into t1 select * from t1 where b < 10 order by pk1; + DROP TABLE t1; -- cgit v1.2.1