Debian Codegraph @

mysql-test/suite/galera/r/MW-416.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE USER 'userMW416'@'localhost';
4 GRANT SELECT, INSERT, UPDATE ON test.* TO 'userMW416'@'localhost';
5 connect userMW416, localhost, userMW416,, test, $NODE_MYPORT_1;
6 connection userMW416;
7 ALTER DATABASE db CHARACTER SET = utf8;
8 ERROR 42000: Access denied for user 'userMW416'@'localhost' to database 'db'
9 ALTER EVENT ev1 RENAME TO ev2;
10 ERROR 42000: Access denied for user 'userMW416'@'localhost' to database 'test'
11 ALTER FUNCTION fun1 COMMENT 'foo';
12 ERROR 42000: alter routine command denied to user 'userMW416'@'localhost' for routine 'test.fun1'
13 ALTER PROCEDURE proc1 COMMENT 'foo';
14 Got one of the listed errors
15 ALTER SERVER srv OPTIONS (USER 'sally');
16 Got one of the listed errors
17 ALTER TABLE tbl DROP COLUMN col;
18 Got one of the listed errors
19 ALTER VIEW vw AS SELECT 1;
20 Got one of the listed errors
21 CREATE DATABASE db;
22 Got one of the listed errors
23 CREATE EVENT ev1 ON SCHEDULE AT CURRENT_TIMESTAMP DO SELECT 1;
24 Got one of the listed errors
25 CREATE FUNCTION fun1() RETURNS int RETURN(1);
26 Got one of the listed errors
27 CREATE FUNCTION fun1 RETURNS STRING SONAME 'funlib.so';
28 Got one of the listed errors
29 CREATE PROCEDURE proc1() BEGIN END;
30 Got one of the listed errors
31 CREATE INDEX idx ON tbl(id);
32 Got one of the listed errors
33 CREATE SERVER srv FOREIGN DATA WRAPPER 'fdw' OPTIONS (USER 'user');
34 Got one of the listed errors
35 CREATE TABLE t (i int);
36 Got one of the listed errors
37 CREATE TRIGGER trg BEFORE UPDATE ON t FOR EACH ROW BEGIN END;
38 Got one of the listed errors
39 CREATE VIEW vw AS SELECT 1;
40 Got one of the listed errors
41 DROP DATABASE db;
42 Got one of the listed errors
43 DROP EVENT ev;
44 Got one of the listed errors
45 DROP FUNCTION fun1;
46 Got one of the listed errors
47 DROP INDEX idx ON t0;
48 Got one of the listed errors
49 DROP PROCEDURE proc1;
50 Got one of the listed errors
51 DROP SERVEr srv;
52 Got one of the listed errors
53 DROP TABLE t0;
54 Got one of the listed errors
55 DROP TRIGGER trg;
56 Got one of the listed errors
57 DROP VIEW vw;
58 Got one of the listed errors
59 RENAME TABLE t0 TO t1;
60 Got one of the listed errors
61 TRUNCATE TABLE t0;
62 Got one of the listed errors
63 ALTER USER myuser PASSWORD EXPIRE;
64 Got one of the listed errors
65 CREATE USER myuser IDENTIFIED BY 'pass';
66 Got one of the listed errors
67 DROP USER myuser;
68 Got one of the listed errors
69 GRANT ALL ON *.* TO 'myuser';
70 Got one of the listed errors
71 RENAME USER myuser TO mariauser;
72 Got one of the listed errors
73 REVOKE SELECT ON test FROM myuser;
74 Got one of the listed errors
75 REVOKE ALL, GRANT OPTION FROM myuser;
76 Got one of the listed errors
77 REVOKE PROXY ON myuser FROM myuser;
78 Got one of the listed errors
79 ANALYZE TABLE db.tbl;
80 Got one of the listed errors
81 CHECK TABLE db.tbl;
82 Got one of the listed errors
83 CHECKSUM TABLE db.tbl;
84 Got one of the listed errors
85 OPTIMIZE TABLE db.tbl;
86 Got one of the listed errors
87 REPAIR TABLE db.tbl;
88 Got one of the listed errors
89 INSTALL PLUGIN plg SONAME 'plg.so';
90 Got one of the listed errors
91 UNINSTALL PLUGIN plg;
92 Got one of the listed errors
93 connection node_1;
94 DROP USER 'userMW416'@'localhost';
95 SHOW DATABASES;
96 Database
97 information_schema
98 mtr
99 mysql
100 performance_schema
101 sys
102 test
103 disconnect userMW416;