diff options
author | unknown <mskold/marty@mysql.com/linux.site> | 2006-08-15 13:37:39 +0200 |
---|---|---|
committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-08-15 13:37:39 +0200 |
commit | 115eb7df2e6b9f81b4659960ca978d7da701df00 (patch) | |
tree | 42c3200c2545d7d50a212c9f8d7114c43268e9ec /mysql-test/t/ndb_lock.test | |
parent | 492e7b081168f1922ef6409ebba77dbf30638185 (diff) | |
parent | 87b7363c5ca7dc0f1165a9460cbfd28b0ff23a61 (diff) | |
download | mariadb-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.test | 15 |
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 |