Debian Codegraph @

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

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