blob: a917a6830b0b7d1373490eada1a9c46a4b698922 (
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
|
include/master-slave.inc
[connection master]
#
# Start of 10.5 tests
#
#
# MDEV-4958 Adding datatype UUID
#
CREATE TABLE t1 (a UUID);
connection slave;
ALTER TABLE t1 MODIFY a BINARY(16);
connection master;
INSERT INTO t1 VALUES ('00000000-0000-0000-0000-000000000000');
INSERT INTO t1 VALUES ('00000000-0000-0000-0000-000000000001');
INSERT INTO t1 VALUES ('ffffffff-ffff-ffff-ffff-fffffffffffe');
INSERT INTO t1 VALUES ('ffffffff-ffff-ffff-ffff-ffffffffffff');
SELECT a FROM t1 ORDER BY a;
a
00000000-0000-0000-0000-000000000000
00000000-0000-0000-0000-000000000001
ffffffff-ffff-ffff-ffff-fffffffffffe
ffffffff-ffff-ffff-ffff-ffffffffffff
connection slave;
SELECT HEX(a) FROM t1 ORDER BY a;
HEX(a)
00000000000000000000000000000000
00000000000000000000000000000001
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFE
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
connection master;
DROP TABLE t1;
#
# End of 10.5 tests
#
include/rpl_end.inc
|
