summaryrefslogtreecommitdiff
path: root/mysql-test/suite/row_lock/t/innodb_row_lock_view_1.test
blob: d6381e1da5bbba1277d963c048cdf25a90b54897 (plain)
1
2
3
4
5
6
7
8
9
--source include/have_innodb.inc
SELECT @@global.innodb_table_locks into @table_locks;
SET @@global.innodb_table_locks= OFF;
let $engine= InnoDB;
let $select= SELECT t1.i,t2.i FROM t1,t2 WHERE t1.i<125 AND t2.i=t1.i FOR UPDATE;
let $indext1= CREATE INDEX ixi ON t1 (i);
let $indext2= CREATE INDEX ixi ON t2 (i);
--source suite/row_lock/include/row_lock_view.inc
SET @@global.innodb_table_locks= @table_locks;