Debian Codegraph @

mysql-test/suite/rpl/r/rpl_tmp_table_and_DDL.result

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE TEMPORARY TABLE t1 (a INT);
4 CREATE TABLE t2 (a INT, b INT) ENGINE= MyISAM;
5 INSERT INTO t1 VALUES (1);
6 CREATE EVENT e1 ON SCHEDULE EVERY 10 HOUR DO SELECT 1;
7 Warnings:
8 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
9 INSERT INTO t1 VALUES (1);
10 ALTER EVENT e1 ON SCHEDULE EVERY 20 HOUR DO SELECT 1;
11 INSERT INTO t1 VALUES (1);
12 DROP EVENT IF EXISTS e1;
13 INSERT INTO t1 VALUES (1);
14 CREATE PROCEDURE p1() SELECT 1;
15 INSERT INTO t1 VALUES (1);
16 ALTER PROCEDURE p1 SQL SECURITY INVOKER;
17 INSERT INTO t1 VALUES (1);
18 CREATE FUNCTION f1() RETURNS INT RETURN 123;
19 INSERT INTO t1 VALUES (1);
20 ALTER FUNCTION f1 SQL SECURITY INVOKER;
21 INSERT INTO t1 VALUES (1);
22 CREATE DATABASE mysqltest1;
23 INSERT INTO t1 VALUES (1);
24 DROP DATABASE mysqltest1;
25 INSERT INTO t1 VALUES (1);
26 CREATE USER test_1@localhost;
27 INSERT INTO t1 VALUES (1);
28 GRANT SELECT ON t2 TO test_1@localhost;
29 INSERT INTO t1 VALUES (1);
30 GRANT ALL ON f1 TO test_1@localhost;
31 INSERT INTO t1 VALUES (1);
32 GRANT ALL ON p1 TO test_1@localhost;
33 INSERT INTO t1 VALUES (1);
34 GRANT USAGE ON *.* TO test_1@localhost;
35 INSERT INTO t1 VALUES (1);
36 REVOKE ALL PRIVILEGES ON f1 FROM test_1@localhost;
37 INSERT INTO t1 VALUES (1);
38 REVOKE ALL PRIVILEGES ON p1 FROM test_1@localhost;
39 INSERT INTO t1 VALUES (1);
40 REVOKE ALL PRIVILEGES ON t2 FROM test_1@localhost;
41 INSERT INTO t1 VALUES (1);
42 REVOKE USAGE ON *.* FROM test_1@localhost;
43 INSERT INTO t1 VALUES (1);
44 RENAME USER test_1@localhost TO test_2@localhost;
45 INSERT INTO t1 VALUES (1);
46 DROP USER test_2@localhost;
47 INSERT INTO t1 VALUES (1);
48 CREATE PROCEDURE p2()
49 BEGIN
50 # CREATE USER when a temporary table is open.
51 CREATE TEMPORARY TABLE t3 (a INT);
52 CREATE USER test_2@localhost;
53 INSERT INTO t1 VALUES (1);
54 # GRANT select on table to user when a temporary table is open.
55 GRANT SELECT ON t2 TO test_2@localhost;
56 INSERT INTO t1 VALUES (1);
57 # GRANT all on function to user when a temporary table is open.
58 GRANT ALL ON f1 TO test_2@localhost;
59 INSERT INTO t1 VALUES (1);
60 # GRANT all on procedure to user when a temporary table is open.
61 GRANT ALL ON p1 TO test_2@localhost;
62 INSERT INTO t1 VALUES (1);
63 # GRANT usage on *.* to user when a temporary table is open.
64 GRANT USAGE ON *.* TO test_2@localhost;
65 INSERT INTO t1 VALUES (1);
66 # REVOKE ALL PRIVILEGES on function to user when a temporary table is open.
67 REVOKE ALL PRIVILEGES ON f1 FROM test_2@localhost;
68 INSERT INTO t1 VALUES (1);
69 # REVOKE ALL PRIVILEGES on procedure to user when a temporary table is open.
70 REVOKE ALL PRIVILEGES ON p1 FROM test_2@localhost;
71 INSERT INTO t1 VALUES (1);
72 # REVOKE ALL PRIVILEGES on table to user when a temporary table is open.
73 REVOKE ALL PRIVILEGES ON t2 FROM test_2@localhost;
74 INSERT INTO t1 VALUES (1);
75 # REVOKE usage on *.* from user when a temporary table is open.
76 REVOKE USAGE ON *.* FROM test_2@localhost;
77 INSERT INTO t1 VALUES (1);
78 # RENAME USER when a temporary table is open.
79 RENAME USER test_2@localhost TO test_3@localhost;
80 INSERT INTO t1 VALUES (1);
81 # DROP USER when a temporary table is open.
82 DROP USER test_3@localhost;
83 INSERT INTO t1 VALUES (1);
84 DROP TEMPORARY TABLE t3;
85 END |
86 DROP PROCEDURE p1;
87 INSERT INTO t1 VALUES (1);
88 DROP PROCEDURE p2;
89 INSERT INTO t1 VALUES (1);
90 DROP FUNCTION f1;
91 INSERT INTO t1 VALUES (1);
92 DROP TABLE t2;
93 INSERT INTO t1 VALUES (1);
94 DROP TEMPORARY TABLE t1;
95 connection slave;
96 connection master;
97 CREATE TABLE t1 (a CHAR(30));
98 CREATE TEMPORARY TABLE t2 (b CHAR(60));
99 LOCK TABLE t1 WRITE;
100 CREATE FUNCTION f1 () RETURNS TINYINT RETURN 13;
101 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
102 INSERT INTO t2 VALUES ("CREATE FUNCTION f1 with table locked");
103 UNLOCK TABLE;
104 CREATE FUNCTION f2 () RETURNS TINYINT RETURN 13;
105 LOCK TABLE t1 WRITE;
106 ALTER FUNCTION f2 SQL SECURITY INVOKER;
107 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
108 INSERT INTO t2 VALUES ("ALTER FUNCTION f2 with table locked");
109 LOCK TABLE t1 WRITE;
110 DROP FUNCTION f2;
111 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
112 INSERT INTO t2 VALUES ("DROP FUNCTION f2 with table locked");
113 CREATE PROCEDURE p1() SELECT 1;
114 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
115 INSERT INTO t2 VALUES ("CREATE PROCEDURE p1 with table locked");
116 UNLOCK TABLE;
117 CREATE PROCEDURE p2() SELECT 1;
118 LOCK TABLE t1 WRITE;
119 ALTER PROCEDURE p2 SQL SECURITY INVOKER;
120 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
121 INSERT INTO t2 VALUES ("ALTER PROCEDURE P2 with table locked");
122 DROP PROCEDURE p2;
123 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
124 INSERT INTO t2 VALUES ("DROP PROCEDURE p2 with table locked");
125 CREATE EVENT e1 ON SCHEDULE EVERY 10 HOUR DO SELECT 1;
126 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
127 INSERT INTO t2 VALUES ("CREATE EVENT e1 with table locked");
128 UNLOCK TABLE;
129 CREATE EVENT e2 ON SCHEDULE EVERY 10 HOUR DO SELECT 1;
130 Warnings:
131 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
132 LOCK TABLE t1 WRITE;
133 ALTER EVENT e2 ON SCHEDULE EVERY 20 HOUR DO SELECT 1;
134 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
135 INSERT INTO t2 VALUES ("ALTER EVENT e2 with table locked");
136 DROP EVENT e2;
137 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
138 INSERT INTO t2 VALUES ("DROP EVENT e2 with table locked");
139 CREATE DATABASE mysqltest1;
140 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
141 INSERT INTO t2 VALUES ("CREATE DATABASE mysqltest1 with table locked");
142 UNLOCK TABLE;
143 CREATE DATABASE mysqltest2;
144 LOCK TABLE t1 WRITE;
145 DROP DATABASE mysqltest2;
146 ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
147 INSERT INTO t2 VALUES ("DROP DATABASE mysqltest2 with table locked");
148 UNLOCK TABLE;
149 DROP DATABASE mysqltest2;
150 LOCK TABLE t1 WRITE;
151 CREATE USER test_1@localhost;
152 ERROR HY000: Table 'db' was not locked with LOCK TABLES
153 INSERT INTO t2 VALUES ("CREATE USER test_1@localhost with table locked");
154 UNLOCK TABLE;
155 CREATE USER test_2@localhost;
156 LOCK TABLE t1 WRITE;
157 GRANT SELECT ON t1 TO test_2@localhost;
158 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
159 INSERT INTO t2 VALUES ("GRANT select on table to user with table locked");
160 GRANT ALL ON f2 TO test_2@localhost;
161 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
162 INSERT INTO t2 VALUES ("GRANT ALL ON f2 TO test_2 with table locked");
163 GRANT ALL ON p2 TO test_2@localhost;
164 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
165 INSERT INTO t2 VALUES ("GRANT ALL ON p2 TO test_2 with table locked");
166 GRANT USAGE ON *.* TO test_2@localhost;
167 ERROR HY000: Table 'db' was not locked with LOCK TABLES
168 INSERT INTO t2 VALUES ("GRANT USAGE ON *.* TO test_2 with table locked");
169 REVOKE ALL PRIVILEGES ON f2 FROM test_2@localhost;
170 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
171 INSERT INTO t2 VALUES ("REVOKE ALL PRIVILEGES on function to user with table locked");
172 REVOKE ALL PRIVILEGES ON p2 FROM test_2@localhost;
173 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
174 INSERT INTO t2 VALUES ("REVOKE ALL PRIVILEGES on procedure to user with table locked");
175 REVOKE ALL PRIVILEGES ON t1 FROM test_2@localhost;
176 ERROR HY000: Table 'tables_priv' was not locked with LOCK TABLES
177 INSERT INTO t2 VALUES ("REVOKE ALL PRIVILEGES on table to user with table locked");
178 REVOKE USAGE ON *.* FROM test_2@localhost;
179 ERROR HY000: Table 'db' was not locked with LOCK TABLES
180 INSERT INTO t2 VALUES ("REVOKE USAGE ON *.* TO test_2 with table locked");
181 RENAME USER test_2@localhost TO test_3@localhost;
182 ERROR HY000: Table 'db' was not locked with LOCK TABLES
183 INSERT INTO t2 VALUES ("RENAME USER test_2 TO test_3 with table locked");
184 UNLOCK TABLE;
185 RENAME USER test_2@localhost TO test_3@localhost;
186 LOCK TABLE t1 WRITE;
187 DROP USER test_3@localhost;
188 ERROR HY000: Table 'db' was not locked with LOCK TABLES
189 INSERT INTO t2 VALUES ("DROP USER test_3@localhost with table locked");
190 UNLOCK TABLE;
191 CREATE DATABASE db;
192 CREATE TABLE db.t1 LIKE t2;
193 CREATE TABLE t3 LIKE t2;
194 DROP TABLE t3;
195 DROP DATABASE db;
196 DROP USER test_3@localhost;
197 DROP FUNCTION f2;
198 DROP PROCEDURE p2;
199 DROP EVENT e2;
200 DROP TABLE t1, t2;
201 include/rpl_end.inc