diff options
| author | unknown <magnus@neptunus.(none)> | 2004-09-07 12:45:19 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-09-07 12:45:19 +0200 |
| commit | 235c5035b5d894c40a9f0d8cd23d17541eb8cd6a (patch) | |
| tree | cb83bc12d9b0f3db6e3a29c62d6a44ca4270758d /mysql-test/r/ndb_insert.result | |
| parent | af46c9c3b63b6a6cc4753588dc1e793b48802a14 (diff) | |
| download | mariadb-git-235c5035b5d894c40a9f0d8cd23d17541eb8cd6a.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/ndb_insert.result')
| -rw-r--r-- | mysql-test/r/ndb_insert.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_insert.result b/mysql-test/r/ndb_insert.result index 93f46c85499..87f27518ea3 100644 --- a/mysql-test/r/ndb_insert.result +++ b/mysql-test/r/ndb_insert.result @@ -416,4 +416,16 @@ INSERT INTO t1 VALUES SELECT COUNT(*) FROM t1; COUNT(*) 2000 +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); +ERROR 23000: Duplicate entry '10' for key 1 +begin; +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); +ERROR 23000: Duplicate entry '10' for key 1 +commit; +insert into t1 select * from t1 where b < 10 order by pk1; +ERROR 23000: Duplicate entry '9' for key 1 DROP TABLE t1; |