Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_6.result

raw
1 CREATE USER test2@localhost;
2 GRANT USAGE ON *.* TO test2@localhost;
3 GRANT CREATE, DROP, ALTER, UPDATE, INSERT, SELECT ON test.* TO test2@localhost;
4 connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
5 USE test;
6 SHOW GRANTS FOR CURRENT_USER;
7 Grants for test2@localhost
8 GRANT USAGE ON *.* TO `test2`@`localhost`
9 GRANT SELECT, INSERT, UPDATE, CREATE, DROP, ALTER ON `test`.* TO `test2`@`localhost`
10 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
11 SELECT * FROM t_10;
12 a b
13 2 Two
14 4 Four
15 6 Six
16 8 Eight
17 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
18 a b
19 1 One
20 3 Three
21 5 Five
22 9 Nine
23 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
24 SELECT * FROM t_10;
25 a b
26 1 One
27 3 Three
28 5 Five
29 9 Nine
30 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
31 a b
32 2 Two
33 4 Four
34 6 Six
35 8 Eight
36 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
37 SELECT * FROM tsp_00;
38 a b
39 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
40 a b
41 2 Two
42 4 Four
43 5 Five
44 6 Six
45 8 Eight
46 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
47 SELECT * FROM tsp_00;
48 a b
49 5 Five
50 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
51 a b
52 2 Two
53 4 Four
54 6 Six
55 8 Eight
56 disconnect test2;
57 connection default;
58 REVOKE INSERT ON test.* FROM test2@localhost;
59 connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
60 USE test;
61 SHOW GRANTS FOR CURRENT_USER;
62 Grants for test2@localhost
63 GRANT USAGE ON *.* TO `test2`@`localhost`
64 GRANT SELECT, UPDATE, CREATE, DROP, ALTER ON `test`.* TO `test2`@`localhost`
65 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
66 ERROR 42000: INSERT command denied to user 'test2'@'localhost' for table 'tp'
67 disconnect test2;
68 connection default;
69 GRANT INSERT ON test.* TO test2@localhost;
70 REVOKE CREATE ON test.* FROM test2@localhost;
71 connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
72 USE test;
73 SHOW GRANTS FOR CURRENT_USER;
74 Grants for test2@localhost
75 GRANT USAGE ON *.* TO `test2`@`localhost`
76 GRANT SELECT, INSERT, UPDATE, DROP, ALTER ON `test`.* TO `test2`@`localhost`
77 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
78 ERROR 42000: CREATE command denied to user 'test2'@'localhost' for table 'tsp'
79 disconnect test2;
80 connection default;
81 GRANT CREATE ON test.* TO test2@localhost;
82 REVOKE DROP ON test.* FROM test2@localhost;
83 connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
84 USE test;
85 SHOW GRANTS FOR CURRENT_USER;
86 Grants for test2@localhost
87 GRANT USAGE ON *.* TO `test2`@`localhost`
88 GRANT SELECT, INSERT, UPDATE, CREATE, ALTER ON `test`.* TO `test2`@`localhost`
89 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
90 ERROR 42000: DROP command denied to user 'test2'@'localhost' for table 'tp'
91 disconnect test2;
92 connection default;
93 DROP TABLE IF EXISTS t_10;
94 DROP TABLE IF EXISTS t_100;
95 DROP TABLE IF EXISTS t_1000;
96 DROP TABLE IF EXISTS tp;
97 DROP TABLE IF EXISTS tsp;
98 DROP TABLE IF EXISTS tsp_00;
99 DROP TABLE IF EXISTS tsp_01;
100 DROP TABLE IF EXISTS tsp_02;
101 DROP TABLE IF EXISTS tsp_03;
102 DROP TABLE IF EXISTS tsp_04;
103 DROP TABLE IF EXISTS t_empty;
104 DROP TABLE IF EXISTS t_null;
105 DROP USER test2@localhost;