diff options
Diffstat (limited to 'mysql-test/r/innodb-deadlock.result')
| -rw-r--r-- | mysql-test/r/innodb-deadlock.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/innodb-deadlock.result b/mysql-test/r/innodb-deadlock.result index e1b3e38b243..2ca82101fb4 100644 --- a/mysql-test/r/innodb-deadlock.result +++ b/mysql-test/r/innodb-deadlock.result @@ -1,5 +1,5 @@ drop table if exists t1,t2; -create table t1 (id integer, x integer) type=INNODB; +create table t1 (id integer, x integer) engine=INNODB; insert into t1 values(0, 0); set autocommit=0; SELECT * from t1 where id = 0 FOR UPDATE; @@ -18,8 +18,8 @@ id x 0 2 commit; drop table t1; -create table t1 (id integer, x integer) type=INNODB; -create table t2 (b integer, a integer) type=INNODB; +create table t1 (id integer, x integer) engine=INNODB; +create table t2 (b integer, a integer) engine=INNODB; insert into t1 values(0, 0), (300, 300); insert into t2 values(0, 10), (1, 20), (2, 30); commit; @@ -54,8 +54,8 @@ id x 300 300 commit; drop table t1, t2; -create table t1 (id integer, x integer) type=INNODB; -create table t2 (b integer, a integer) type=INNODB; +create table t1 (id integer, x integer) engine=INNODB; +create table t2 (b integer, a integer) engine=INNODB; insert into t1 values(0, 0), (300, 300); insert into t2 values(0, 0), (1, 20), (2, 30); commit; |