1 --source include/have_partition.inc
2 --source include/have_binlog_format_statement.inc
5 DROP TABLE IF EXISTS t1;
9 --echo # Bug#51851: Server with SBR locks mutex twice on LOAD DATA into
10 --echo # partitioned MyISAM table
11 --write_file init_file.txt
16 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
17 name TINYBLOB NOT NULL,
18 modified TIMESTAMP DEFAULT '0000-00-00 00:00:00',
19 INDEX namelocs (name(255))) ENGINE = MyISAM
20 PARTITION BY HASH(id) PARTITIONS 2;
22 LOAD DATA LOCAL INFILE 'init_file.txt'
25 --remove_file init_file.txt