diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/rpl_row_binary_to_inet4.result')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/rpl_row_binary_to_inet4.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/rpl_row_binary_to_inet4.result b/plugin/type_inet/mysql-test/type_inet/rpl_row_binary_to_inet4.result new file mode 100644 index 00000000000..5921ab25974 --- /dev/null +++ b/plugin/type_inet/mysql-test/type_inet/rpl_row_binary_to_inet4.result @@ -0,0 +1,36 @@ +include/master-slave.inc +[connection master] +# +# Start of 10.10 tests +# +# +# MDEV-23287 The INET4 data type +# MDEV-20844 RBR from binary(16) to inet6 fails with error 171: The event was corrupt, leading to illegal data being read +# +CREATE TABLE t1 (a BINARY(4)); +connection slave; +ALTER TABLE t1 MODIFY a INET4; +connection master; +INSERT INTO t1 VALUES (0x00000000); +INSERT INTO t1 VALUES (0xa0000001); +INSERT INTO t1 VALUES (0xf0000000); +INSERT INTO t1 VALUES (0xff000001); +SELECT CAST(a AS INET4) FROM t1 ORDER BY a; +CAST(a AS INET4) +0.0.0.0 +160.0.0.1 +240.0.0.0 +255.0.0.1 +connection slave; +SELECT * FROM t1 ORDER BY a; +a +0.0.0.0 +160.0.0.1 +240.0.0.0 +255.0.0.1 +connection master; +DROP TABLE t1; +# +# End of 10.10 tests +# +include/rpl_end.inc |