Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_schema.test

raw
1 --source connect.inc
2
3 --enable_connect_log
4
5 --echo # Create a schema on one mysqld, verify creation also on the other.
6 --connection mysqld1
7 CREATE SCHEMA s;
8 SHOW CREATE SCHEMA s;
9
10 --connection mysqld2
11 SHOW CREATE SCHEMA s;
12
13 --echo # Set schema read only on one mysqld, verify read only also on the other.
14 ALTER SCHEMA s READ ONLY = 1;
15 SHOW CREATE SCHEMA s;
16
17 --connection mysqld1
18 SHOW CREATE SCHEMA s;
19
20 --echo # Verify that writes (table creation) fail on both mysqlds.
21 --error ER_SCHEMA_READ_ONLY
22 CREATE TABLE s.t(i int);
23
24 --connection mysqld2
25 --error ER_SCHEMA_READ_ONLY
26 CREATE TABLE s.t(i int);
27
28 --echo # Verify that writes (table inserts) fail on both mysqlds.
29 ALTER SCHEMA s READ ONLY = 0;
30 CREATE TABLE s.t(i int) ENGINE NDB;
31 ALTER SCHEMA s READ ONLY = 1;
32 --error ER_SCHEMA_READ_ONLY
33 INSERT INTO s.t VALUES (1);
34
35 --connection mysqld1
36 --error ER_SCHEMA_READ_ONLY
37 INSERT INTO s.t VALUES (1);
38
39 --echo # Cleanup.
40 ALTER SCHEMA s READ ONLY = 0;
41 DROP SCHEMA s;
42
43 --disable_connect_log