summaryrefslogtreecommitdiff
path: root/mysql-test/suite/ndb
diff options
context:
space:
mode:
authorunknown <jonas@perch.ndb.mysql.com>2008-02-03 21:24:59 +0100
committerunknown <jonas@perch.ndb.mysql.com>2008-02-03 21:24:59 +0100
commitf01ed1196c06ba0fcd7a6b889a9ccaef5be705b7 (patch)
tree9a66d6b4829fa39f0036a8752584b3a66fb22e62 /mysql-test/suite/ndb
parent6bb77bf6bb73724d22c60bdb5702c0db01ebf3a1 (diff)
downloadmariadb-git-f01ed1196c06ba0fcd7a6b889a9ccaef5be705b7.tar.gz
ndb - bug#33619
make sure to alloc logspace and set bits if doing delete after previous update wo/ touching DD part mysql-test/suite/ndb/r/ndb_dd_basic.result: testcase mysql-test/suite/ndb/t/ndb_dd_basic.test: testcase
Diffstat (limited to 'mysql-test/suite/ndb')
-rw-r--r--mysql-test/suite/ndb/r/ndb_dd_basic.result10
-rw-r--r--mysql-test/suite/ndb/t/ndb_dd_basic.test10
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/ndb/r/ndb_dd_basic.result b/mysql-test/suite/ndb/r/ndb_dd_basic.result
index 2a79fcfb3c8..41e3d10fe5b 100644
--- a/mysql-test/suite/ndb/r/ndb_dd_basic.result
+++ b/mysql-test/suite/ndb/r/ndb_dd_basic.result
@@ -406,6 +406,16 @@ a b c
1 7 7
2 2 2
3 3 3
+DELETE FROM t1;
+INSERT INTO t1 VALUES (3,'1','1');
+BEGIN;
+UPDATE t1 SET b = b + 2 WHERE A = 3;
+DELETE FROM t1 WHERE A = 3;
+INSERT INTO t1 VALUES (3,'0','0');
+COMMIT;
+SELECT * from t1 ORDER BY 1;
+a b c
+3 0 0
DROP TABLE t1;
CREATE TABLE t1 (
a INT NOT NULL PRIMARY KEY,
diff --git a/mysql-test/suite/ndb/t/ndb_dd_basic.test b/mysql-test/suite/ndb/t/ndb_dd_basic.test
index fc35ef03b39..0fb793e2142 100644
--- a/mysql-test/suite/ndb/t/ndb_dd_basic.test
+++ b/mysql-test/suite/ndb/t/ndb_dd_basic.test
@@ -346,6 +346,16 @@ UPDATE t1 SET c = '6' WHERE b = '7';
SELECT * FROM t1 ORDER BY 1;
UPDATE t1 SET c = '7' WHERE c = '6';
SELECT * FROM t1 ORDER BY 1;
+
+DELETE FROM t1;
+INSERT INTO t1 VALUES (3,'1','1');
+BEGIN;
+UPDATE t1 SET b = b + 2 WHERE A = 3;
+DELETE FROM t1 WHERE A = 3;
+INSERT INTO t1 VALUES (3,'0','0');
+COMMIT;
+SELECT * from t1 ORDER BY 1;
+
DROP TABLE t1;
########################