Debian Codegraph @

mysql-test/suite/galera/t/MW-416.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --source include/wait_until_ready.inc
5
6 CREATE USER 'userMW416'@'localhost';
7 GRANT SELECT, INSERT, UPDATE ON test.* TO 'userMW416'@'localhost';
8
9 --connect userMW416, localhost, userMW416,, test, $NODE_MYPORT_1
10 --connection userMW416
11
12 # DDL
13
14 --error 1044
15 ALTER DATABASE db CHARACTER SET = utf8;
16 --error 1044
17 ALTER EVENT ev1 RENAME TO ev2;
18 --error 1370
19 ALTER FUNCTION fun1 COMMENT 'foo';
20 #--error 1044,1227
21 #ALTER INSTANCE ROTATE INNODB MASTER KEY;
22 --error 1044,1227,1370
23 ALTER PROCEDURE proc1 COMMENT 'foo';
24 --error 1044,1227
25 ALTER SERVER srv OPTIONS (USER 'sally');
26 --error 1044,1142,1227
27 ALTER TABLE tbl DROP COLUMN col;
28 --error 1044,1142,1227
29 ALTER VIEW vw AS SELECT 1;
30
31 --error 1044,1227
32 CREATE DATABASE db;
33 --error 1044,1227
34 CREATE EVENT ev1 ON SCHEDULE AT CURRENT_TIMESTAMP DO SELECT 1;
35 --error 1044,1227,1370
36 CREATE FUNCTION fun1() RETURNS int RETURN(1);
37 --error 1044,1227,1370
38 CREATE FUNCTION fun1 RETURNS STRING SONAME 'funlib.so';
39 --error 1044,1227,1370
40 CREATE PROCEDURE proc1() BEGIN END;
41 --error 1044,1142,1227
42 CREATE INDEX idx ON tbl(id);
43 --error 1044,1227
44 CREATE SERVER srv FOREIGN DATA WRAPPER 'fdw' OPTIONS (USER 'user');
45 --error 1044,1142,1227
46 CREATE TABLE t (i int);
47 --error 1044,1142,1227
48 CREATE TRIGGER trg BEFORE UPDATE ON t FOR EACH ROW BEGIN END;
49 --error 1044,1142,1227
50 CREATE VIEW vw AS SELECT 1;
51
52 --error 1044,1227
53 DROP DATABASE db;
54 --error 1044,1227
55 DROP EVENT ev;
56 --error 1044,1227,1370
57 DROP FUNCTION fun1;
58 --error 1044,1142,1227
59 DROP INDEX idx ON t0;
60 --error 1044,1227,1370
61 DROP PROCEDURE proc1;
62 --error 1044,1227
63 DROP SERVEr srv;
64 --error 1044,1142,1227
65 DROP TABLE t0;
66 --error 1044,1227,1360
67 DROP TRIGGER trg;
68 --error 1044,1142,1227
69 DROP VIEW vw;
70
71 --error 1044,1142,1227
72 RENAME TABLE t0 TO t1;
73
74 --error 1044,1142,1227
75 TRUNCATE TABLE t0;
76
77 # DCL
78
79 # account management
80 --error 1044,1227,1064
81 ALTER USER myuser PASSWORD EXPIRE;
82 --error 1044,1227
83 CREATE USER myuser IDENTIFIED BY 'pass';
84 --error 1044,1227
85 DROP USER myuser;
86 --error 1044,1045,1227
87 GRANT ALL ON *.* TO 'myuser';
88 --error 1044,1227
89 RENAME USER myuser TO mariauser;
90 --error 1044,1142,1227,1370
91 REVOKE SELECT ON test FROM myuser;
92 --error 1044,1142,1227,1370,1698
93 REVOKE ALL, GRANT OPTION FROM myuser;
94 --error 1044,1142,1227,1370,1698
95 REVOKE PROXY ON myuser FROM myuser;
96
97 # table maintenance
98 --error 1044,1142,1227
99 ANALYZE TABLE db.tbl;
100 --error 1044,1142,1227
101 CHECK TABLE db.tbl;
102 --error 1044,1142,1227
103 CHECKSUM TABLE db.tbl;
104 --error 1044,1142,1227
105 OPTIMIZE TABLE db.tbl;
106 --error 1044,1142,1227
107 REPAIR TABLE db.tbl;
108
109 # plugin and user defined functions
110 --error 1044,1142,1227
111 INSTALL PLUGIN plg SONAME 'plg.so';
112 --error 1044,1142,1227
113 UNINSTALL PLUGIN plg;
114
115 --connection node_1
116 DROP USER 'userMW416'@'localhost';
117 SHOW DATABASES;
118
119 --disconnect userMW416