1
--source include/have_innodb.inc
2
SELECT @@global.innodb_table_locks into @table_locks;
3
SET @@global.innodb_table_locks= OFF;
5
let $select= SELECT t1.i,t2.i FROM t1,t2 WHERE t1.i < half_t1() AND t2.i=t1.i LOCK IN SHARE MODE;
6
let $indext1= CREATE INDEX ixi ON t1 (i);
7
let $indext2= CREATE INDEX ixi ON t2 (i);
8
--source suite/row_lock/include/row_lock_big_tab.inc
9
SET @@global.innodb_table_locks= @table_locks;