Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_utils.result

raw
1 call mtr.add_suppression("option 'thread_stack':");
2 include/gtid_utils.inc
3 #### NULL values for built-in functions ####
4 SELECT GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', NULL);
5 GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', NULL)
6 NULL
7 SELECT GTID_SUBSET(NULL, 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
8 GTID_SUBSET(NULL, 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
9 NULL
10 SELECT GTID_SUBSET(NULL, NULL);
11 GTID_SUBSET(NULL, NULL)
12 NULL
13 SELECT GTID_SUBSET(MID(1,NULL),MID(1,NULL));
14 GTID_SUBSET(MID(1,NULL),MID(1,NULL))
15 NULL
16 SELECT GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', NULL);
17 GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', NULL)
18 NULL
19 SELECT GTID_SUBTRACT(NULL, 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
20 GTID_SUBTRACT(NULL, 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
21 NULL
22 SELECT GTID_SUBTRACT(NULL, NULL);
23 GTID_SUBTRACT(NULL, NULL)
24 NULL
25 SELECT GTID_SUBTRACT(MID(1,NULL),MID(1,NULL));
26 GTID_SUBTRACT(MID(1,NULL),MID(1,NULL))
27 NULL
28 #### Max values for built-in functions ####
29 SELECT GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '');
30 GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '')
31 0
32 SELECT GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2));
33 GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2))
34 1
35 SELECT GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), '');
36 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
37 SELECT GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1));
38 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
39 SELECT GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '');
40 GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '')
41 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775806
42 SELECT GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2));
43 GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2))
44
45 SELECT GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), '');
46 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
47 SELECT GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1));
48 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
49 #### Min values for built-in functions ####
50 SELECT GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1', '');
51 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
52 SELECT GTID_SUBSET('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1');
53 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
54 SELECT GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0', '');
55 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
56 SELECT GTID_SUBSET('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0');
57 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
58 SELECT GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1', '');
59 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
60 SELECT GTID_SUBTRACT('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1');
61 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
62 SELECT GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0', '');
63 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
64 SELECT GTID_SUBTRACT('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0');
65 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
66 #### Functionality of user-defined functions in gtid_utils.inc ####
67 SELECT GTID_IS_EQUAL('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:3:2:1', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
68 GTID_IS_EQUAL('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:3:2:1', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
69 1
70 SELECT GTID_IS_EQUAL('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:3:2:1', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
71 GTID_IS_EQUAL('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:3:2:1', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
72 0
73 SELECT GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
74 GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
75 1
76 SELECT GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
77 GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
78 0
79 SELECT GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1');
80 GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1')
81 1
82 SELECT GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1');
83 GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1')
84 0
85 SELECT GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1');
86 GTID_IS_DISJOINT_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1')
87 0
88 SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5-7');
89 GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5-7')
90
91 SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-7', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5');
92 GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-7', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5')
93 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3:5
94 SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:2:3');
95 GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:2:3')
96 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3
97 SELECT GTID_INTERSECTION('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
98 GTID_INTERSECTION('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
99
100 SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
101 GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
102 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3
103 SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
104 GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
105 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3
106 SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4');
107 GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4')
108 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
109 SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5');
110 GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5')
111 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2:4-5
112 SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4-5');
113 GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4-5')
114 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-5
115 SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
116 GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
117 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
118 bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
119 SELECT GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
120 GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
121 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
122 cccccccc-cccc-cccc-cccc-cccccccccccc:1-3
123 SELECT GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
124 GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
125 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
126 cccccccc-cccc-cccc-cccc-cccccccccccc:1-3
127 SELECT GTID_SUBTRACT_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
128 GTID_SUBTRACT_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
129
130 SELECT GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
131 GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
132
133 SELECT GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
134 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
135 SELECT GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
136 GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
137 bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
138 SELECT GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
139 GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
140
141 SELECT GTID_INTERSECTION_WITH_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
142 GTID_INTERSECTION_WITH_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
143 bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
144 SELECT GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
145 GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
146 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775806
147 SELECT GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
148 ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
149 SELECT GTID_COUNT('');
150 GTID_COUNT('')
151 0
152 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
153 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
154 1
155 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
156 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
157 3
158 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:4-5');
159 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:4-5')
160 5
161 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-5');
162 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-5')
163 4
164 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4');
165 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4')
166 3
167 SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,');
168 GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,')
169 5
170 SELECT GTID_NEXT_GENERATED('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
171 GTID_NEXT_GENERATED('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
172 1
173 SELECT GTID_NEXT_GENERATED('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
174 GTID_NEXT_GENERATED('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
175 1
176 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
177 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
178 2
179 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
180 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
181 1
182 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
183 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
184 4
185 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
186 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
187 4
188 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
189 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
190 4
191 SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
192 GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
193 1
194 SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 0);
195 GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 0)
196
197 SELECT GTID_NEXT_GENERATED_MULTIPLE('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4);
198 GTID_NEXT_GENERATED_MULTIPLE('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4)
199 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
200 SELECT GTID_NEXT_GENERATED_MULTIPLE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4);
201 GTID_NEXT_GENERATED_MULTIPLE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4)
202 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
203 SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:10-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10);
204 GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:10-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10)
205 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9:12-16
206 SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10);
207 GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10)
208 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:12-17
209 SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
210 GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
211 1
212 SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
213 GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
214 1
215 SELECT GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
216 GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
217 1
218 SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '~aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '');
219 GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '~aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '')
220 1
221 SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
222 GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
223 1
224 SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-5');
225 GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-5')
226 1
227 SELECT GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
228 GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
229 1
230 include/gtid_utils_end.inc