diff options
author | unknown <monty@hundin.mysql.fi> | 2001-11-26 03:52:23 +0200 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2001-11-26 03:52:23 +0200 |
commit | f33fb18677d673f1bcb2d617355ea3e2dbb04f48 (patch) | |
tree | 49cc31d54c5d97d749655befa4714cd9ada479e3 /mysql-test/r/bdb-deadlock.result | |
parent | 00d82156b2f713963edb0cfbf40273eb27c00138 (diff) | |
download | mariadb-git-f33fb18677d673f1bcb2d617355ea3e2dbb04f48.tar.gz |
Patch for SCO
Update test results for MySQL 4.0
extra/resolveip.c:
Fix for SCO
mysql-test/r/backup.result:
Update test results for MySQL 4.0
mysql-test/r/bdb-crash.result:
Update test results for MySQL 4.0
mysql-test/r/bdb-deadlock.result:
Update test results for MySQL 4.0
mysys/mf_casecnv.c:
Patch for SCO
mysys/mf_qsort.c:
Patch for SCO
mysys/my_compress.c:
Patch for SCO
strings/ctype.c:
Patch for SCO
Diffstat (limited to 'mysql-test/r/bdb-deadlock.result')
-rw-r--r-- | mysql-test/r/bdb-deadlock.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/bdb-deadlock.result b/mysql-test/r/bdb-deadlock.result index 89077d16980..55b3d3ea2a5 100644 --- a/mysql-test/r/bdb-deadlock.result +++ b/mysql-test/r/bdb-deadlock.result @@ -1,10 +1,31 @@ +drop table if exists t1,t2; +create table t1 (id integer, x integer) type=BDB; +create table t2 (id integer, x integer) type=BDB; +insert into t1 values(0, 0); +insert into t2 values(0, 0); +set autocommit=0; +update t1 set x = 1 where id = 0; +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; +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 t2; id x 0 1 +commit; +drop table t1,t2; |