2 files changed, 15 insertions, 2 deletions
diff --git a/mysql-test/r/ndb_blob.result b/mysql-test/r/ndb_blob.result
index 1f2cf33f57d..156c2d570a4 100644
--- a/mysql-test/r/ndb_blob.result
+++ b/mysql-test/r/ndb_blob.result
@@ -414,6 +414,7 @@ a	b	c	d
 9	b9	999	dd9
 drop table t1;
 drop database test2;
+set autocommit=0;
 create table t1 (
 a int not null primary key,
 b tinytext
@@ -422,9 +423,13 @@ insert into t1 values(1, 'x');
 update t1 set b = 'y';
 select * from t1;
 a	b
-1	x
+1	y
 delete from t1;
+select * from t1;
+a	b
+commit;
 drop table t1;
+set autocommit=0;
 create table t1 (
 a int not null primary key,
 b text not null
@@ -433,6 +438,7 @@ insert into t1 values(1, '');
 select * from t1;
 a	b
 1	
+commit;
 drop table t1;
 set autocommit=1;
 use test;
@@ -454,6 +460,7 @@ select * from t1 order by a;
 a	b
 1	AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
 2	BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
+set autocommit=1;
 alter table t1 engine=myisam;
 select * from t1 order by a;
 a	b
diff --git a/mysql-test/t/ndb_blob.test b/mysql-test/t/ndb_blob.test
index ba5f089b17b..06ecbc66d97 100644
--- a/mysql-test/t/ndb_blob.test
+++ b/mysql-test/t/ndb_blob.test
@@ -337,8 +337,9 @@ select * from t1 order by a;
 drop table t1;
 drop database test2;
 
-# -- bug-5252 tinytext crashes --
+# -- bug-5252 tinytext crashes plus no-commit result --
 
+set autocommit=0;
 create table t1 (
   a int not null primary key,
   b tinytext
@@ -348,10 +349,13 @@ insert into t1 values(1, 'x');
 update t1 set b = 'y';
 select * from t1;
 delete from t1;
+select * from t1;
+commit;
 drop table t1;
 
 # -- bug-5013 insert empty string to text --
 
+set autocommit=0;
 create table t1 (
   a int not null primary key,
   b text not null
@@ -359,6 +363,7 @@ create table t1 (
 
 insert into t1 values(1, '');
 select * from t1;
+commit;
 drop table t1;
 
 # -- bug #5349 --
@@ -380,6 +385,7 @@ alter table t1 engine=ndb;
 select * from t1 order by a;
 
 # -- bug #5872 --
+set autocommit=1;
 alter table t1 engine=myisam;
 select * from t1 order by a;
 drop table t1;