MDEV-25444: mysql --binary-mode is not able to replay some mysqlbinlog outputsbb-10.3-25444

Changes on top of Sachin’s patch. Specifically:
 1) Refined the parsing break condition to only change the parser’s
behavior for parsing strings in binary mode (behavior of \0 outside
of strings is unchanged).
 2) Prefixed binary_zero_insert.test with ‘mysql_’ to more clearly
associate the  purpose of the test.
 3) As the input of the test contains binary zeros (0x5c00),
different text editors can visualize this sequence differently, and
Github would not display it at all. Therefore, the input itself was
consolidated into the test and created out of hex sequences to make
it easier to understand what is happening.
 4) Extended test to validate that the rows which correspond to the
INSERTS with 0x5c00 have the correct binary zero data.

Reviewed By:
===========
Andrei Elkin <andrei.elkin@mariadb.com>

1 files changed, 0 insertions, 15 deletions

diff --git a/mysql-test/main/binary_zero_insert.test b/mysql-test/main/binary_zero_insert.test
deleted file mode 100644
index a8769199859..00000000000
--- a/mysql-test/main/binary_zero_insert.test
+++ /dev/null
@@ -1,15 +0,0 @@
-#
-# MDEV-25444 mysql --binary-mode is not able to replay some mysqlbinlog outputs
-#
-# After investigating it turns out to be a issue of mysql client not able to properly
-#  handle  \\\0 <0 in binary>.
-# In this test case we will be pipelining binary_zero_insert.bin into  mysql client.
-# binary_zero_insert.bin contains insert stmt with \\\0
-
-CREATE TABLE `tb` (`id` int(11) NOT NULL AUTO_INCREMENT,`cb` longblob DEFAULT NULL,
-PRIMARY KEY (`id`)) ENGINE=myisam AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-
---exec $MYSQL --binary-mode  test < $MYSQL_TEST_DIR/std_data/binary_zero_insert.bin
-select count(*)=2 from tb;
-
-drop table tb;