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/t/ndb_insert.test | |
| 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/t/ndb_insert.test')
| -rw-r--r-- | mysql-test/t/ndb_insert.test | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/mysql-test/t/ndb_insert.test b/mysql-test/t/ndb_insert.test index a448e413f1d..1a8103924a4 100644 --- a/mysql-test/t/ndb_insert.test +++ b/mysql-test/t/ndb_insert.test @@ -443,13 +443,20 @@ begin; # # Insert duplicate rows, inside transaction -# +# since failing inserts rollbacks whole transaction +# all select count (except second) return same value +# +SELECT COUNT(*) FROM t1; +INSERT INTO t1 VALUES +(2001,2001,2001),(2002,2002,2002),(2003,2003,2003),(2004,2004,2004),(2005,2005,2005); +SELECT COUNT(*) FROM t1; --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); - +SELECT COUNT(*) FROM t1; commit; +SELECT COUNT(*) FROM t1; # # Insert duplicate rows using "insert .. select" |