Debian Codegraph @

mysql-test/suite/parts/t/partition_exch_qa_6.test

raw
1 # Author: Horst Hunger
2 # Created: 2010-07-06
3
4
5 let $engine_table= INNODB;
6 let $engine_part= INNODB;
7 let $engine_subpart= INNODB;
8
9 CREATE USER test2@localhost;
10
11 --disable_result_log
12 --disable_query_log
13 --source suite/parts/inc/part_exch_tabs.inc
14 --enable_result_log
15 --enable_query_log
16
17 GRANT USAGE ON *.* TO test2@localhost;
18 GRANT CREATE, DROP, ALTER, UPDATE, INSERT, SELECT ON test.* TO test2@localhost;
19
20 --echo connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
21 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
22 USE test;
23 SHOW GRANTS FOR CURRENT_USER;
24 # 9) Exchanges with different owner.
25 # Privilege for ALTER and SELECT
26 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
27 --sorted_result
28 SELECT * FROM t_10;
29 --sorted_result
30 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
31 # Back to former values.
32 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
33 --sorted_result
34 SELECT * FROM t_10;
35 --sorted_result
36 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
37 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
38 --sorted_result
39 SELECT * FROM tsp_00;
40 --sorted_result
41 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
42 # Back to former values.
43 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
44 --sorted_result
45 SELECT * FROM tsp_00;
46 --sorted_result
47 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
48 --echo disconnect test2;
49 disconnect test2;
50
51 --echo connection default;
52 connection default;
53 REVOKE INSERT ON test.* FROM test2@localhost;
54
55 --echo connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
56 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
57 USE test;
58 SHOW GRANTS FOR CURRENT_USER;
59 # Privilege for ALTER and SELECT
60 --error ER_TABLEACCESS_DENIED_ERROR
61 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
62 --echo disconnect test2;
63 disconnect test2;
64
65 --echo connection default;
66 connection default;
67 GRANT INSERT ON test.* TO test2@localhost;
68 REVOKE CREATE ON test.* FROM test2@localhost;
69
70 --echo connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
71 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
72 USE test;
73 SHOW GRANTS FOR CURRENT_USER;
74 --error ER_TABLEACCESS_DENIED_ERROR
75 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
76 --echo disconnect test2;
77 disconnect test2;
78
79 --echo connection default;
80 connection default;
81 GRANT CREATE ON test.* TO test2@localhost;
82 REVOKE DROP ON test.* FROM test2@localhost;
83
84 --echo connect (test2,localhost,test2,,test,MASTER_MYPORT,MASTER_MYSOCK);
85 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
86 USE test;
87 SHOW GRANTS FOR CURRENT_USER;
88 # Privilege for ALTER and SELECT
89 --error ER_TABLEACCESS_DENIED_ERROR
90 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
91 --echo disconnect test2;
92 disconnect test2;
93
94 --echo connection default;
95 connection default;
96
97 --source suite/parts/inc/part_exch_drop_tabs.inc
98
99 DROP USER test2@localhost;
100