call mtr.add_suppression("option 'thread_stack':");
include/gtid_utils.inc
#### Max values for built-in functions ####
SELECT GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '');
GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '')
0
SELECT GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2));
GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2))
1
SELECT GTID_SUBSET(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
SELECT GTID_SUBSET('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1));
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
SELECT GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '');
GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), '')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775806
SELECT GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2));
GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2))

SELECT GTID_SUBTRACT(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
SELECT GTID_SUBTRACT('', CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1));
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
#### Min values for built-in functions ####
SELECT GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1', '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
SELECT GTID_SUBSET('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
SELECT GTID_SUBSET('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0', '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
SELECT GTID_SUBSET('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
SELECT GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1', '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
SELECT GTID_SUBTRACT('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0-1'.
SELECT GTID_SUBTRACT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0', '');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
SELECT GTID_SUBTRACT('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
#### Functionality of user-defined functions in gtid_utils.inc ####
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');
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')
1
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');
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')
0
SELECT GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
1
SELECT GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
GTID_IS_DISJOINT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:2,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
0
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');
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')
1
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');
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')
0
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');
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')
0
SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5-7');
GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5-7')

SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-7', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5');
GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-7', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3:5
SELECT GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:2:3');
GTID_INTERSECTION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:2:3')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3
SELECT GTID_INTERSECTION('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
GTID_INTERSECTION('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')

SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3
SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3');
GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3
SELECT GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4');
GTID_UNION('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5');
GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3-5')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2:4-5
SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4-5');
GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4-5')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-5
SELECT GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3');
GTID_SYMMETRIC_DIFFERENCE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
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');
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')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
cccccccc-cccc-cccc-cccc-cccccccccccc:1-3
SELECT GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
GTID_SUBTRACT_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,
cccccccc-cccc-cccc-cccc-cccccccccccc:1-3
SELECT GTID_SUBTRACT_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
GTID_SUBTRACT_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')

SELECT GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')

SELECT GTID_SUBTRACT_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
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');
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')
bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
SELECT GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
GTID_INTERSECTION_WITH_UUID('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,cccccccc-cccc-cccc-cccc-cccccccccccc:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')

SELECT GTID_INTERSECTION_WITH_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb');
GTID_INTERSECTION_WITH_UUID('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3', 'bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb')
bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-3
SELECT GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 2), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775806
SELECT GTID_INTERSECTION_WITH_UUID(CONCAT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-', (1 << 63) - 1), 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
ERROR HY000: Malformed GTID set specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9223372036854775807'.
SELECT GTID_COUNT('');
GTID_COUNT('')
0
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1')
1
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
3
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:4-5');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:4-5')
5
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-5');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-5')
4
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4')
3
SELECT GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,');
GTID_COUNT('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3:5-4,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1:3,')
5
SELECT GTID_NEXT_GENERATED('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
1
SELECT GTID_NEXT_GENERATED('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
1
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
2
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
1
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
4
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5:1-3', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
4
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
4
SELECT GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa');
GTID_NEXT_GENERATED('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2-3,11111111-1111-1111-1111-111111111111:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa')
1
SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 0);
GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 0)

SELECT GTID_NEXT_GENERATED_MULTIPLE('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4);
GTID_NEXT_GENERATED_MULTIPLE('bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4)
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
SELECT GTID_NEXT_GENERATED_MULTIPLE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4);
GTID_NEXT_GENERATED_MULTIPLE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 4)
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4
SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:10-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10);
GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:10-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10)
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9:12-16
SELECT GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10);
GTID_NEXT_GENERATED_MULTIPLE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3:5:7:9-11', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', 10)
aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2:4:6:8:12-17
SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
1
SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
1
SELECT GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
1
SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '~aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '');
GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '~aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2', '')
1
SELECT GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3');
GTID_COMPARE('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3')
1
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');
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')
1
SELECT GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2');
GTID_COMPARE('', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:+2', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2')
1
include/gtid_utils_end.inc