summaryrefslogtreecommitdiff
path: root/mysql-test/t/ndb_lock.test
diff options
context:
space:
mode:
authorunknown <mskold/marty@mysql.com/linux.site>2006-08-15 13:37:39 +0200
committerunknown <mskold/marty@mysql.com/linux.site>2006-08-15 13:37:39 +0200
commit115eb7df2e6b9f81b4659960ca978d7da701df00 (patch)
tree42c3200c2545d7d50a212c9f8d7114c43268e9ec /mysql-test/t/ndb_lock.test
parent492e7b081168f1922ef6409ebba77dbf30638185 (diff)
parent87b7363c5ca7dc0f1165a9460cbfd28b0ff23a61 (diff)
downloadmariadb-git-115eb7df2e6b9f81b4659960ca978d7da701df00.tar.gz
Merge mysql.com:/windows/Linux_space/MySQL/mysql-4.1
into mysql.com:/windows/Linux_space/MySQL/mysql-5.0 mysql-test/r/ndb_lock.result: Auto merged mysql-test/t/ndb_lock.test: Auto merged ndb/include/ndbapi/NdbTransaction.hpp: Merge sql/ha_ndbcluster.cc: Merge sql/ha_ndbcluster.h: Merge
Diffstat (limited to 'mysql-test/t/ndb_lock.test')
-rw-r--r--mysql-test/t/ndb_lock.test15
1 files changed, 13 insertions, 2 deletions
diff --git a/mysql-test/t/ndb_lock.test b/mysql-test/t/ndb_lock.test
index 54214ee72ec..48a8b77dcd7 100644
--- a/mysql-test/t/ndb_lock.test
+++ b/mysql-test/t/ndb_lock.test
@@ -73,7 +73,7 @@ drop table t1;
create table t1 (x integer not null primary key, y varchar(32), z integer, key(z)) engine = ndb;
-insert into t1 values (1,'one',1), (2,'two',2),(3,"three",3);
+insert into t1 values (1,'one',1);
# PK access
connection con1;
@@ -82,12 +82,23 @@ select * from t1 where x = 1 for update;
connection con2;
begin;
-select * from t1 where x = 2 for update;
--error 1205
select * from t1 where x = 1 for update;
rollback;
connection con1;
+rollback;
+insert into t1 values (2,'two',2),(3,"three",3);
+begin;
+select * from t1 where x = 1 for update;
+
+connection con2;
+--error 1205
+select * from t1 where x = 1 for update;
+select * from t1 where x = 2 for update;
+rollback;
+
+connection con1;
commit;
# table scan