Debian Codegraph @

mysql-test/suite/ndb/r/ndb_tmp_table_and_DDL.result

raw
1 CREATE TEMPORARY TABLE t1 (a INT);
2 CREATE TABLE t2 (a INT, b INT) ENGINE= NDB;
3 INSERT INTO t1 VALUES (1);
4 CREATE EVENT e1 ON SCHEDULE EVERY 10 HOUR DO SELECT 1;
5 INSERT INTO t1 VALUES (1);
6 ALTER EVENT e1 ON SCHEDULE EVERY 20 HOUR DO SELECT 1;
7 INSERT INTO t1 VALUES (1);
8 DROP EVENT IF EXISTS e1;
9 INSERT INTO t1 VALUES (1);
10 CREATE PROCEDURE p1() SELECT 1;
11 INSERT INTO t1 VALUES (1);
12 ALTER PROCEDURE p1 SQL SECURITY INVOKER;
13 INSERT INTO t1 VALUES (1);
14 CREATE FUNCTION f1() RETURNS INT RETURN 123;
15 INSERT INTO t1 VALUES (1);
16 ALTER FUNCTION f1 SQL SECURITY INVOKER;
17 INSERT INTO t1 VALUES (1);
18 CREATE DATABASE mysqltest1;
19 INSERT INTO t1 VALUES (1);
20 DROP DATABASE mysqltest1;
21 INSERT INTO t1 VALUES (1);
22 CREATE USER test_1@localhost;
23 INSERT INTO t1 VALUES (1);
24 GRANT SELECT ON t2 TO test_1@localhost;
25 INSERT INTO t1 VALUES (1);
26 GRANT ALL ON f1 TO test_1@localhost;
27 INSERT INTO t1 VALUES (1);
28 GRANT ALL ON p1 TO test_1@localhost;
29 INSERT INTO t1 VALUES (1);
30 GRANT USAGE ON *.* TO test_1@localhost;
31 INSERT INTO t1 VALUES (1);
32 REVOKE ALL PRIVILEGES ON f1 FROM test_1@localhost;
33 INSERT INTO t1 VALUES (1);
34 REVOKE ALL PRIVILEGES ON p1 FROM test_1@localhost;
35 INSERT INTO t1 VALUES (1);
36 REVOKE ALL PRIVILEGES ON t2 FROM test_1@localhost;
37 INSERT INTO t1 VALUES (1);
38 REVOKE USAGE ON *.* FROM test_1@localhost;
39 INSERT INTO t1 VALUES (1);
40 RENAME USER test_1@localhost TO test_2@localhost;
41 INSERT INTO t1 VALUES (1);
42 DROP USER test_2@localhost;
43 INSERT INTO t1 VALUES (1);
44 CREATE PROCEDURE p2()
45 BEGIN
46 # CREATE USER when a temporary table is open.
47 CREATE TEMPORARY TABLE t3 (a INT);
48 CREATE USER test_2@localhost;
49 INSERT INTO t1 VALUES (1);
50 # GRANT select on table to user when a temporary table is open.
51 GRANT SELECT ON t2 TO test_2@localhost;
52 INSERT INTO t1 VALUES (1);
53 # GRANT all on function to user when a temporary table is open.
54 GRANT ALL ON f1 TO test_2@localhost;
55 INSERT INTO t1 VALUES (1);
56 # GRANT all on procedure to user when a temporary table is open.
57 GRANT ALL ON p1 TO test_2@localhost;
58 INSERT INTO t1 VALUES (1);
59 # GRANT usage on *.* to user when a temporary table is open.
60 GRANT USAGE ON *.* TO test_2@localhost;
61 INSERT INTO t1 VALUES (1);
62 # REVOKE ALL PRIVILEGES on function to user when a temporary table is open.
63 REVOKE ALL PRIVILEGES ON f1 FROM test_2@localhost;
64 INSERT INTO t1 VALUES (1);
65 # REVOKE ALL PRIVILEGES on procedure to user when a temporary table is open.
66 REVOKE ALL PRIVILEGES ON p1 FROM test_2@localhost;
67 INSERT INTO t1 VALUES (1);
68 # REVOKE ALL PRIVILEGES on table to user when a temporary table is open.
69 REVOKE ALL PRIVILEGES ON t2 FROM test_2@localhost;
70 INSERT INTO t1 VALUES (1);
71 # REVOKE usage on *.* from user when a temporary table is open.
72 REVOKE USAGE ON *.* FROM test_2@localhost;
73 INSERT INTO t1 VALUES (1);
74 # RENAME USER when a temporary table is open.
75 RENAME USER test_2@localhost TO test_3@localhost;
76 INSERT INTO t1 VALUES (1);
77 # DROP USER when a temporary table is open.
78 DROP USER test_3@localhost;
79 INSERT INTO t1 VALUES (1);
80 DROP TEMPORARY TABLE t3;
81 END |
82 DROP PROCEDURE p1;
83 INSERT INTO t1 VALUES (1);
84 DROP PROCEDURE p2;
85 INSERT INTO t1 VALUES (1);
86 DROP FUNCTION f1;
87 INSERT INTO t1 VALUES (1);
88 DROP TABLE t2;
89 INSERT INTO t1 VALUES (1);
90 DROP TEMPORARY TABLE t1;