summaryrefslogtreecommitdiff
path: root/mysql-test/r/bdb-deadlock.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2001-11-26 03:52:23 +0200
committerunknown <monty@hundin.mysql.fi>2001-11-26 03:52:23 +0200
commitf33fb18677d673f1bcb2d617355ea3e2dbb04f48 (patch)
tree49cc31d54c5d97d749655befa4714cd9ada479e3 /mysql-test/r/bdb-deadlock.result
parent00d82156b2f713963edb0cfbf40273eb27c00138 (diff)
downloadmariadb-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.result21
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;