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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
|
RESET MASTER;
include/gtid_utils.inc
include/gtid_step_reset.inc
SET SESSION GTID_NEXT='MASTER_UUID:1';
CREATE TABLE t1( i INT) engine=INNODB;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1
SET SESSION GTID_NEXT='MASTER_UUID:2';
INSERT INTO t1 VALUES (12);
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-2
SET SESSION GTID_NEXT='MASTER_UUID:3';
INSERT INTO t1 SELECT * FROM t1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-3
SET SESSION GTID_NEXT='MASTER_UUID:4';
UPDATE t1 SET i=13 WHERE i=12;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-4
SET SESSION GTID_NEXT='MASTER_UUID:5';
DELETE FROM t1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-5
SET SESSION GTID_NEXT='MASTER_UUID:6';
ALTER TABLE t1 ADD COLUMN other_column INT;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-6
SET SESSION GTID_NEXT='MASTER_UUID:7';
CREATE INDEX t_index ON t1(i);
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-7
SET SESSION GTID_NEXT='MASTER_UUID:8';
DROP INDEX t_index ON t1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-8
SET SESSION GTID_NEXT='MASTER_UUID:9';
RENAME TABLE t1 TO t2;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-9
SET SESSION GTID_NEXT='MASTER_UUID:10';
DROP TABLE t2;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-10
SET SESSION GTID_NEXT='MASTER_UUID:11';
CREATE TEMPORARY TABLE t1(i INT);
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-11
SET SESSION GTID_NEXT='MASTER_UUID:12';
DROP TEMPORARY TABLE t1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-12
SET SESSION GTID_NEXT='MASTER_UUID:13';
CREATE VIEW v1 as SELECT 1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-13
SET SESSION GTID_NEXT='MASTER_UUID:14';
DROP VIEW v1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-14
SET SESSION GTID_NEXT='MASTER_UUID:15';
CREATE USER user1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-15
SET SESSION GTID_NEXT='MASTER_UUID:16';
ALTER USER user1 IDENTIFIED BY 'passwd';
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-16
SET SESSION GTID_NEXT='MASTER_UUID:17';
GRANT ALL ON *.* TO user1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-17
SET SESSION GTID_NEXT='MASTER_UUID:18';
REVOKE ALL PRIVILEGES ON *.* FROM user1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-18
SET SESSION GTID_NEXT='MASTER_UUID:19';
DROP USER user1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-19
SET SESSION GTID_NEXT='MASTER_UUID:20';
CREATE DATABASE db1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-20
SET SESSION GTID_NEXT='MASTER_UUID:21';
ALTER DATABASE db1 DEFAULT CHARACTER SET utf8;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-21
SET SESSION GTID_NEXT='MASTER_UUID:22';
DROP DATABASE db1;
include/gtid_step_assert.inc [count=1, only_count=0]
FLUSH LOGS;
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-22
#
# Bug #21459999 "ASSERTION FAILURE WHEN PREVIOUSLY UNUSED TIME
# ZONE IS USED WITH GTID + NO BINLOG"
CREATE TABLE t1(dt DATETIME) engine=INNODB;
SET SESSION GTID_NEXT='MASTER_UUID:23';
# Below statement caused assertion failure.
INSERT INTO t1 VALUES (CONVERT_TZ('2015-07-01 01:00:00', 'UTC', 'No-such-time-zone'));
SET SESSION GTID_NEXT='AUTOMATIC';
DROP TABLE t1;
include/gtid_utils_end.inc
|
