blob: 5921ab25974dee4386ec99dd70a5f6dcd39d9d46 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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
|
