diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/backup.result | 1 | ||||
| -rw-r--r-- | mysql-test/r/bdb-crash.result | 14 | ||||
| -rw-r--r-- | mysql-test/r/bdb-deadlock.result | 21 |
3 files changed, 29 insertions, 7 deletions
diff --git a/mysql-test/r/backup.result b/mysql-test/r/backup.result index ff7d17584bf..43d57d2d4f7 100644 --- a/mysql-test/r/backup.result +++ b/mysql-test/r/backup.result @@ -70,3 +70,4 @@ backup table t1 to '../tmp'; unlock tables; Table Op Msg_type Msg_text test.t1 backup status OK +drop table t1; diff --git a/mysql-test/r/bdb-crash.result b/mysql-test/r/bdb-crash.result index 29d296a2c3f..42c826d55da 100644 --- a/mysql-test/r/bdb-crash.result +++ b/mysql-test/r/bdb-crash.result @@ -1,5 +1,5 @@ -drop table if exists tblChange; -CREATE TABLE tblCharge ( +drop table if exists t1; +CREATE TABLE t1 ( ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment, ServiceID int(10) unsigned DEFAULT '0' NOT NULL, ChargeDate date DEFAULT '0000-00-00' NOT NULL, @@ -16,17 +16,17 @@ KEY ServiceID (ServiceID), KEY ChargeDate (ChargeDate) ) type=BDB; BEGIN; -INSERT INTO tblCharge +INSERT INTO t1 VALUES(NULL,1,'2001-03-01',1,1,1,'New',NULL,NULL,'now'); COMMIT; BEGIN; -UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE +UPDATE t1 SET ChargeAuthorizationMessage = 'blablabla' WHERE ChargeID = 1; COMMIT; -INSERT INTO tblCharge +INSERT INTO t1 VALUES(NULL,1,'2001-03-01',1,1,1,'New',NULL,NULL,'now'); -select * from tblCharge; +select * from t1; ChargeID ServiceID ChargeDate ChargeAmount FedTaxes ProvTaxes ChargeStatus ChargeAuthorizationMessage ChargeComment ChargeTimeStamp 1 1 2001-03-01 1.00 1.00 1.00 New blablabla NULL now 2 1 2001-03-01 1.00 1.00 1.00 New NULL NULL now -drop table tblCharge; +drop table t1; 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; |