diff options
| author | unknown <mskold/marty@mysql.com/linux.site> | 2006-08-08 12:22:23 +0200 |
|---|---|---|
| committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-08-08 12:22:23 +0200 |
| commit | 01543ee274932786f3fa5acfac7f9e79e719eff6 (patch) | |
| tree | 586bd56dc80ccfd177fd2f320d5259632014f54d /mysql-test/t/ndb_lock.test | |
| parent | a1fc9e8848f79377df107193ddb946de178408ad (diff) | |
| download | mariadb-git-01543ee274932786f3fa5acfac7f9e79e719eff6.tar.gz | |
bug #18184 SELECT ... FOR UPDATE does not work..: Added lockTuple call in close_scan
sql/ha_ndbcluster.cc:
bug #18184 SELECT ... FOR UPDATE does not work..: Added lockTuple call in closeScan
mysql-test/r/ndb_lock.result:
bug #18184 SELECT ... FOR UPDATE does not work..: Added lockTuple call in closeScan
mysql-test/t/ndb_lock.test:
bug #18184 SELECT ... FOR UPDATE does not work..: Added lockTuple call in closeScan
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 e8f7c57ac96..3804782b150 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 |