From 57929f76138091be8c316830cc2d909e8ca88d82 Mon Sep 17 00:00:00 2001 From: Sachin Date: Sun, 1 Sep 2019 20:05:07 +0530 Subject: 19708 compatibility --- mysql-test/std_data/rpl/19708-compatibility.binlog | Bin 0 -> 1025 bytes .../suite/binlog/r/mdev-19708_compatibility.result | 5 +++++ mysql-test/suite/binlog/t/mdev-19708_compatibility.test | 13 +++++++++++++ 3 files changed, 18 insertions(+) create mode 100644 mysql-test/std_data/rpl/19708-compatibility.binlog create mode 100644 mysql-test/suite/binlog/r/mdev-19708_compatibility.result create mode 100644 mysql-test/suite/binlog/t/mdev-19708_compatibility.test diff --git a/mysql-test/std_data/rpl/19708-compatibility.binlog b/mysql-test/std_data/rpl/19708-compatibility.binlog new file mode 100644 index 00000000000..755edc30e41 Binary files /dev/null and b/mysql-test/std_data/rpl/19708-compatibility.binlog differ diff --git a/mysql-test/suite/binlog/r/mdev-19708_compatibility.result b/mysql-test/suite/binlog/r/mdev-19708_compatibility.result new file mode 100644 index 00000000000..a15e89e9de8 --- /dev/null +++ b/mysql-test/suite/binlog/r/mdev-19708_compatibility.result @@ -0,0 +1,5 @@ +select * from t1 order by a; +a b +1 1 +2 2 +drop table t1; diff --git a/mysql-test/suite/binlog/t/mdev-19708_compatibility.test b/mysql-test/suite/binlog/t/mdev-19708_compatibility.test new file mode 100644 index 00000000000..6d6a85df56f --- /dev/null +++ b/mysql-test/suite/binlog/t/mdev-19708_compatibility.test @@ -0,0 +1,13 @@ +--source include/have_binlog_format_row.inc +--exec $MYSQL_BINLOG $MYSQL_TEST_DIR/std_data/rpl/19708-compatibility.binlog > $MYSQLTEST_VARDIR/tmp/19708.binlog + +# data in binlog +#CREATE TABLE t1(a INT UNSIGNED, b char); +#SET GLOBAL binlog_row_metadata = MINIMAL; +#INSERT INTO t1 VALUES(1, 1); +#SET GLOBAL binlog_row_metadata = FULL; +#INSERT INTO t1 VALUES(2, 2); +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/19708.binlog; +select * from t1 order by a; +drop table t1; +--remove_file $MYSQLTEST_VARDIR/tmp/19708.binlog -- cgit v1.2.1