Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_schema.result

raw
1 # Create a schema on one mysqld, verify creation also on the other.
2 connection mysqld1;
3 CREATE SCHEMA s;
4 SHOW CREATE SCHEMA s;
5 Database Create Database
6 s CREATE DATABASE `s` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
7 connection mysqld2;
8 SHOW CREATE SCHEMA s;
9 Database Create Database
10 s CREATE DATABASE `s` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
11 # Set schema read only on one mysqld, verify read only also on the other.
12 ALTER SCHEMA s READ ONLY = 1;
13 SHOW CREATE SCHEMA s;
14 Database Create Database
15 s CREATE DATABASE `s` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ /* READ ONLY = 1 */
16 connection mysqld1;
17 SHOW CREATE SCHEMA s;
18 Database Create Database
19 s CREATE DATABASE `s` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ /* READ ONLY = 1 */
20 # Verify that writes (table creation) fail on both mysqlds.
21 CREATE TABLE s.t(i int);
22 ERROR HY000: Schema 's' is in read only mode.
23 connection mysqld2;
24 CREATE TABLE s.t(i int);
25 ERROR HY000: Schema 's' is in read only mode.
26 # Verify that writes (table inserts) fail on both mysqlds.
27 ALTER SCHEMA s READ ONLY = 0;
28 CREATE TABLE s.t(i int) ENGINE NDB;
29 ALTER SCHEMA s READ ONLY = 1;
30 INSERT INTO s.t VALUES (1);
31 ERROR HY000: Schema 's' is in read only mode.
32 connection mysqld1;
33 INSERT INTO s.t VALUES (1);
34 ERROR HY000: Schema 's' is in read only mode.
35 # Cleanup.
36 ALTER SCHEMA s READ ONLY = 0;
37 DROP SCHEMA s;