diff options
| author | unknown <tomas@poseidon.(none)> | 2004-09-14 15:51:57 +0000 |
|---|---|---|
| committer | unknown <tomas@poseidon.(none)> | 2004-09-14 15:51:57 +0000 |
| commit | 0deb4c41925d58aa34cb4cb66dd09f49c2e645cb (patch) | |
| tree | dd939ce4092e1e57248c9505d4690d87c44ce621 /mysql-test/r/ndb_insert.result | |
| parent | b51118aaa0a51a606aaee1e481859234319ac8b0 (diff) | |
| download | mariadb-git-0deb4c41925d58aa34cb4cb66dd09f49c2e645cb.tar.gz | |
Added testcase for select count() during transaction with failures
added fix for keeping "records" up to date when execute() fails
mysql-test/r/ndb_insert.result:
Added testcase for select count() during transaction with failures
mysql-test/t/ndb_insert.test:
Added testcase for select count() during transaction with failures
sql/ha_ndbcluster.cc:
added fix for keeping "records" up to date when execute() fails
sql/ha_ndbcluster.h:
added fix for keeping "records" up to date when execute() fails
Diffstat (limited to 'mysql-test/r/ndb_insert.result')
| -rw-r--r-- | mysql-test/r/ndb_insert.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_insert.result b/mysql-test/r/ndb_insert.result index 87f27518ea3..2944230deef 100644 --- a/mysql-test/r/ndb_insert.result +++ b/mysql-test/r/ndb_insert.result @@ -421,11 +421,25 @@ INSERT INTO t1 VALUES (6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10); ERROR 23000: Duplicate entry '10' for key 1 begin; +SELECT COUNT(*) FROM t1; +COUNT(*) +2000 +INSERT INTO t1 VALUES +(2001,2001,2001),(2002,2002,2002),(2003,2003,2003),(2004,2004,2004),(2005,2005,2005); +SELECT COUNT(*) FROM t1; +COUNT(*) +2005 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 +SELECT COUNT(*) FROM t1; +COUNT(*) +2000 commit; +SELECT COUNT(*) FROM t1; +COUNT(*) +2000 insert into t1 select * from t1 where b < 10 order by pk1; ERROR 23000: Duplicate entry '9' for key 1 DROP TABLE t1; |