1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/main/partition_binlog_stmt.test b/mysql-test/main/partition_binlog_stmt.test
new file mode 100644
index 00000000000..cc57222dc3c
--- /dev/null
+++ b/mysql-test/main/partition_binlog_stmt.test
@@ -0,0 +1,27 @@
+--source include/have_partition.inc
+--source include/have_binlog_format_statement.inc
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+--echo #
+--echo # Bug#51851: Server with SBR locks mutex twice on LOAD DATA into
+--echo #            partitioned MyISAM table
+--write_file $MYSQLTEST_VARDIR/tmp/init_file.txt
+abcd
+EOF
+
+CREATE TABLE t1
+(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ name TINYBLOB NOT NULL,
+ modified TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ INDEX namelocs (name(255))) ENGINE = MyISAM
+PARTITION BY HASH(id) PARTITIONS 2;
+
+--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
+eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/tmp/init_file.txt'
+INTO TABLE t1 (name);
+
+--remove_file $MYSQLTEST_VARDIR/tmp/init_file.txt
+DROP TABLE t1;