diff options
author | unknown <ram@mysql.r18.ru> | 2002-10-30 16:02:02 +0400 |
---|---|---|
committer | unknown <ram@mysql.r18.ru> | 2002-10-30 16:02:02 +0400 |
commit | b1de1ef15ee56300d256314a7bf9ff907cee431e (patch) | |
tree | 3546467eb11303f8aee411e6e35db7ff779acd95 /mysql-test | |
parent | e086000f196ac3314e736d1bb8cacccdaff8412f (diff) | |
parent | 155e78f014de1a2e259ae5119f4621fbb210a784 (diff) | |
download | mariadb-git-b1de1ef15ee56300d256314a7bf9ff907cee431e.tar.gz |
Merge rkalimullin@work.mysql.com:/home/bk/mysql-4.1
into mysql.r18.ru:/usr/home/ram/mysql-4.1
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/bdb-deadlock.result | 8 | ||||
-rw-r--r-- | mysql-test/t/bdb-deadlock.test | 11 |
2 files changed, 12 insertions, 7 deletions
diff --git a/mysql-test/r/bdb-deadlock.result b/mysql-test/r/bdb-deadlock.result index 55b3d3ea2a5..74798a34a53 100644 --- a/mysql-test/r/bdb-deadlock.result +++ b/mysql-test/r/bdb-deadlock.result @@ -9,23 +9,23 @@ set autocommit=0; update t2 set x = 1 where id = 0; select x from t1 where id = 0; select x from t2 where id = 0; +commit; Deadlock found when trying to get lock; Try restarting transaction commit; x 1 -commit; select * from t1; -id x -0 1 select * from t2; id x 0 1 commit; -select * from t1; id x 0 1 +select * from t1; select * from t2; id x 0 1 commit; +id x +0 1 drop table t1,t2; diff --git a/mysql-test/t/bdb-deadlock.test b/mysql-test/t/bdb-deadlock.test index b32b50c715b..27fcb5c6149 100644 --- a/mysql-test/t/bdb-deadlock.test +++ b/mysql-test/t/bdb-deadlock.test @@ -30,13 +30,17 @@ select x from t1 where id = 0; connection con1; # This should generate a deadlock as we are trying to access a locked row ---error 1213 +--send select x from t2 where id = 0; -commit; connection con2; -reap; +--error 1213 +commit; + +connection con1; commit; + +connection con2; select * from t1; select * from t2; commit; @@ -45,4 +49,5 @@ connection con1; select * from t1; select * from t2; commit; + drop table t1,t2; |