diff options
| author | monty@mysql.com <> | 2004-10-20 11:24:08 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-10-20 11:24:08 +0300 |
| commit | 1f8b3d0f22070d450226ef4f6e0e31c8ef8cd401 (patch) | |
| tree | 5012e0497271e138067e54c110bf06958ba1f520 /mysql-test/r/innodb-lock.result | |
| parent | c01c8f99ea16fb2029efade30b8bf18ae314c03a (diff) | |
| download | mariadb-git-1f8b3d0f22070d450226ef4f6e0e31c8ef8cd401.tar.gz | |
Code cleanups (done during review of new code)
Rename innodb_table_locks_old_behavior -> innodb_table_locks
Set innodb_table_locks to off by default to get same behaviour as in MySQL 4.0.20
(This means that Innodb ignore table locks by default, which makes it easier to combine MyISAM and InnoDB to simulate a transaction)
Diffstat (limited to 'mysql-test/r/innodb-lock.result')
| -rw-r--r-- | mysql-test/r/innodb-lock.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/innodb-lock.result b/mysql-test/r/innodb-lock.result index cf00adb30ae..f87f221ea66 100644 --- a/mysql-test/r/innodb-lock.result +++ b/mysql-test/r/innodb-lock.result @@ -1,4 +1,30 @@ drop table if exists t1; +select @@innodb_table_locks; +@@innodb_table_locks +0 +set @@innodb_table_locks=1; +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; +id x +0 0 +set autocommit=0; +lock table t1 write; +update t1 set x=1 where id = 0; +select * from t1; +id x +0 1 +commit; +update t1 set x=2 where id = 0; +commit; +unlock tables; +select * from t1; +id x +0 2 +commit; +drop table t1; +set @@innodb_table_locks=0; create table t1 (id integer, x integer) engine=INNODB; insert into t1 values(0, 0); set autocommit=0; |