Debian Codegraph @

mysql-test/suite/clone/r/local_basic.result

raw
1 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2));
2 INSERT INTO t1 VALUES(10, 'clone row 1');
3 INSERT INTO t1 VALUES(20, 'clone row 2');
4 INSERT INTO t1 VALUES(30, 'clone row 3');
5 SELECT * from t1 ORDER BY col1;
6 col1 col2
7 10 clone row 1
8 20 clone row 2
9 30 clone row 3
10 SELECT count(*) FROM mysql.general_log;
11 count(*)
12 0
13 SELECT count(*) FROM mysql.slow_log;
14 count(*)
15 0
16 CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
17 INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
18 SELECT * from t_myisam ORDER BY col1;
19 col1 col2
20 10 myisam not cloned row 1
21 CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
22 INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
23 SELECT * from t_csv ORDER BY col1;
24 col1 col2
25 10 csv not cloned row 1
26 CREATE SCHEMA non_innodb;
27 CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
28 INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
29 INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
30 INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
31 SELECT * from non_innodb.t_myisam ORDER BY col1;
32 col1 col2
33 10 myisam not cloned row 1
34 20 myisam not cloned row 2
35 30 myisam not cloned row 3
36 CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
37 INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1');
38 INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2');
39 INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3');
40 SELECT * from non_innodb.t_csv ORDER BY col1;
41 col1 col2
42 10 csv not cloned row 1
43 20 csv not cloned row 2
44 30 csv not cloned row 3
45 CREATE SCHEMA schema_read_only;
46 CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64))
47 ENGINE=MyISAM;
48 INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1');
49 INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2');
50 INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3');
51 SELECT * from schema_read_only.t_myisam ORDER BY col1;
52 col1 col2
53 10 myisam not cloned row 1
54 20 myisam not cloned row 2
55 30 myisam not cloned row 3
56 CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL)
57 ENGINE=CSV;
58 INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1');
59 INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2');
60 INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3');
61 SELECT * from schema_read_only.t_csv ORDER BY col1;
62 col1 col2
63 10 csv not cloned row 1
64 20 csv not cloned row 2
65 30 csv not cloned row 3
66 CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64))
67 ENGINE=InnoDB;
68 INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1');
69 INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2');
70 INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3');
71 SELECT * from schema_read_only.t_innodb ORDER BY col1;
72 col1 col2
73 10 innodb cloned row 1
74 20 innodb cloned row 2
75 30 innodb cloned row 3
76 ALTER SCHEMA schema_read_only READ ONLY=1;
77 #BEGIN Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
78 SET LOCAL explicit_defaults_for_timestamp = OFF;
79 Warnings:
80 Warning 1287 'explicit_defaults_for_timestamp' is deprecated and will be removed in a future release.
81 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
82 Variable_name Value
83 explicit_defaults_for_timestamp OFF
84 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
85 UNINSTALL PLUGIN clone;
86 SET LOCAL explicit_defaults_for_timestamp = default;
87 #End Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
88 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
89 INSTALL PLUGIN example SONAME 'EXAMPLE_PLUGIN';
90 SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
91 WHERE PLUGIN_NAME LIKE '%clone%';
92 PLUGIN_NAME PLUGIN_STATUS
93 clone ACTIVE
94 SET GLOBAL clone_autotune_concurrency = OFF;
95 SET GLOBAL clone_max_concurrency = 8;
96 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
97 select ID, STATE, ERROR_NO from performance_schema.clone_status;
98 ID STATE ERROR_NO
99 1 Completed 0
100 select ID, STAGE, STATE from performance_schema.clone_progress;
101 ID STAGE STATE
102 1 DROP DATA Completed
103 1 FILE COPY Completed
104 1 PAGE COPY Completed
105 1 REDO COPY Completed
106 1 FILE SYNC Completed
107 1 RESTART Not Started
108 1 RECOVERY Not Started
109 # restart: --datadir=CLONE_DATADIR
110 SELECT * from t1 ORDER BY col1;
111 col1 col2
112 10 clone row 1
113 20 clone row 2
114 30 clone row 3
115 INSERT INTO t1 VALUES(40, 'clone row 4');
116 SELECT * from t1 ORDER BY col1;
117 col1 col2
118 10 clone row 1
119 20 clone row 2
120 30 clone row 3
121 40 clone row 4
122 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
123 SELECT * from t_myisam ORDER BY col1;
124 col1 col2
125 40 myisam not cloned row 4
126 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
127 SELECT * from t_csv ORDER BY col1;
128 col1 col2
129 40 csv not cloned row 4
130 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
131 SELECT * from non_innodb.t_myisam ORDER BY col1;
132 col1 col2
133 40 myisam not cloned row 4
134 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
135 SELECT * from non_innodb.t_csv ORDER BY col1;
136 col1 col2
137 40 csv not cloned row 4
138 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
139 ERROR HY000: Schema 'schema_read_only' is in read only mode.
140 SELECT * from schema_read_only.t_myisam ORDER BY col1;
141 col1 col2
142 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
143 ERROR HY000: Schema 'schema_read_only' is in read only mode.
144 SELECT * from schema_read_only.t_csv ORDER BY col1;
145 col1 col2
146 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
147 ERROR HY000: Schema 'schema_read_only' is in read only mode.
148 SELECT * from schema_read_only.t_innodb ORDER BY col1;
149 col1 col2
150 10 innodb cloned row 1
151 20 innodb cloned row 2
152 30 innodb cloned row 3
153 SHOW CREATE SCHEMA schema_read_only;
154 Database Create Database
155 schema_read_only CREATE DATABASE `schema_read_only` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ /* READ ONLY = 1 */
156 SELECT count(*) FROM mysql.general_log;
157 count(*)
158 0
159 SELECT count(*) FROM mysql.slow_log;
160 count(*)
161 0
162 SET GLOBAL general_log = ON;
163 SET GLOBAL slow_query_log = ON;
164 # restart:
165 SELECT * from t1 ORDER BY col1;
166 col1 col2
167 10 clone row 1
168 20 clone row 2
169 30 clone row 3
170 DROP TABLE t1;
171 DROP TABLE t_myisam;
172 DROP TABLE t_csv;
173 DROP TABLE non_innodb.t_myisam;
174 DROP TABLE non_innodb.t_csv;
175 DROP SCHEMA non_innodb;
176 ALTER SCHEMA schema_read_only READ ONLY=0;
177 DROP SCHEMA schema_read_only;
178 UNINSTALL PLUGIN example;
179 UNINSTALL PLUGIN clone;
180 #
181 # BUG#34828542: P_S.clone_status.gtid_executed does not have enough
182 # column size
183 #
184 # Install Plugin
185 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
186 # Test case set up.
187 SET @gtid_next_saved = @@SESSION.GTID_NEXT;
188 SET @gtid_mode_saved = @@GLOBAL.GTID_MODE;
189 SET @enforce_gtid_consistency_saved = @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
190 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=ON;
191 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
192 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
193 SET @@GLOBAL.GTID_MODE=ON;
194 CREATE PROCEDURE p1()
195 BEGIN
196 DECLARE x INT DEFAULT 0;
197 WHILE x <= 2000 DO
198 SET gtid_next=CONCAT(UUID(),':',4000);
199 COMMIT;
200 SET x = x + 1;
201 END WHILE;
202 END//
203 CALL p1();
204 # Restore GTID settings.
205 SET @@SESSION.GTID_NEXT= @gtid_next_saved;
206 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
207 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
208 SET @@GLOBAL.GTID_MODE= @gtid_mode_saved;
209 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=@enforce_gtid_consistency_saved;
210 # Clone database.
211 SET GLOBAL clone_autotune_concurrency = OFF;
212 SET GLOBAL clone_max_concurrency = 8;
213 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
214 # Restart cloned database
215 # restart: --datadir=CLONE_DATADIR
216 # Check the length of gtid_executed > 4096 after bug fix.
217 SELECT length(gtid_executed) from performance_schema.clone_status;
218 length(gtid_executed)
219 86081
220 # restart:
221 DROP PROCEDURE p1;
222 RESET MASTER;
223 UNINSTALL PLUGIN clone;