innodb_table_lock_on_full_scan=ON has no effect on a partitioned InnoDB table

--source include/have_innodb.inc

--source include/have_partition.inc

--source include/have_sequence.inc

CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB PARTITION BY HASH (a) PARTITIONS 4;

INSERT INTO t1 SELECT seq, seq FROM seq_1_to_1000;

SET SESSION innodb_table_lock_on_full_scan= ON;

BEGIN;

DELETE FROM t1;

--sleep 0.3

--let $n= `SELECT trx_rows_locked FROM information_schema.INNODB_TRX WHERE trx_mysql_thread_id = CONNECTION_ID()`

ROLLBACK;

if ($n)

{

  --die With innodb_table_lock_on_full_scan=ON a full scan of a partitioned InnoDB table still locks rows one by one ($n rows), no table lock

}

SET SESSION innodb_table_lock_on_full_scan= DEFAULT;

DROP TABLE t1;

mysqltest: At line 14: With innodb_table_lock_on_full_scan=ON a full scan of a partitioned InnoDB table still locks rows one by one (1004 rows), no table lock