Debian Codegraph @

mysql-test/suite/clone/include/remote_basic_replace_across_lts_validate.inc

raw
1 # Validate data
2 SELECT * from t1 ORDER BY col1;
3 INSERT INTO t1 VALUES(40, 'clone row 4');
4 SELECT * from t1 ORDER BY col1;
5
6 # Check MyISAM and CSV table data
7 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
8 SELECT * from t_myisam ORDER BY col1;
9
10 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
11 SELECT * from t_csv ORDER BY col1;
12
13 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
14 SELECT * from non_innodb.t_myisam ORDER BY col1;
15
16 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
17 SELECT * from non_innodb.t_csv ORDER BY col1;
18
19 # Check tables in read only schema
20 --error ER_SCHEMA_READ_ONLY
21 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
22 SELECT * from schema_read_only.t_myisam ORDER BY col1;
23
24 --error ER_SCHEMA_READ_ONLY
25 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
26 SELECT * from schema_read_only.t_csv ORDER BY col1;
27
28 --error ER_SCHEMA_READ_ONLY
29 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
30 SELECT * from schema_read_only.t_innodb ORDER BY col1;
31
32 SHOW CREATE SCHEMA schema_read_only;
33
34 --source include/wait_until_count_sessions.inc
35
36 --connection clone_conn_1
37
38 --echo # Cleanup
39 if (!$clone_remote_replace) {
40 --let restart_parameters="restart:"
41 --source include/restart_mysqld.inc
42 }
43 --connection default
44
45 SELECT * from t1 ORDER BY col1;
46
47 DROP TABLE t1;
48
49 DROP TABLE t_myisam;
50 DROP TABLE t_csv;
51
52 DROP TABLE non_innodb.t_myisam;
53 DROP TABLE non_innodb.t_csv;
54
55 DROP SCHEMA non_innodb;
56
57 ALTER SCHEMA schema_read_only READ ONLY=0;
58 DROP SCHEMA schema_read_only;
59
60 if (!$clone_remote_replace) {
61 --force-rmdir $CLONE_DATADIR
62 }
63
64 --echo # Clean recipient by cloning the cleaned up donor
65 if ($clone_remote_replace) {
66 --connection clone_conn_1
67 --let $clone_err = ER_SCHEMA_READ_ONLY
68 --source ../include/clone_command.inc
69 --let $clone_err = 0
70
71 ALTER SCHEMA schema_read_only READ ONLY=0;
72 --source ../include/clone_command.inc
73 }
74 --source ../include/clone_connection_end.inc