Debian Codegraph @

mysql-test/suite/parts/inc/part_exch_qa_8.inc

raw
1 --source include/default_charset.inc
2
3 CREATE USER test2@localhost;
4
5 --source include/not_embedded.inc
6 --disable_result_log
7 --disable_query_log
8 --source suite/parts/inc/part_exch_tabs.inc
9 --enable_result_log
10 --enable_query_log
11
12 CREATE DATABASE testdb;
13 USE testdb;
14 --disable_result_log
15 --disable_query_log
16 --source suite/parts/inc/part_exch_tabs.inc
17 --enable_result_log
18 --enable_query_log
19
20 USE test;
21 GRANT CREATE, ALTER, DROP, INSERT, SELECT on test.* TO test2@localhost;
22 GRANT CREATE, ALTER, DROP, INSERT, SELECT on testdb.* TO test2@localhost;
23
24 # 8) Exchanges partition and table and back in 2 sessions with 2 databases.
25 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
26 # Privileges on both DB's
27 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10;
28 --sorted_result
29 SELECT * FROM testdb.t_10;
30 --sorted_result
31 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
32 # Exchange back.
33 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10;
34 --sorted_result
35 SELECT * FROM testdb.t_10;
36 --sorted_result
37 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
38
39 ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10;
40 --sorted_result
41 SELECT * FROM t_10;
42 --sorted_result
43 SELECT * FROM testdb.tp WHERE a BETWEEN 0 AND 10;
44 # Exchange back.
45 ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10;
46 --sorted_result
47 SELECT * FROM t_10;
48 --sorted_result
49 SELECT * FROM testdb.tp WHERE a BETWEEN 0 AND 10;
50 disconnect test2;
51
52 connection default;
53 REVOKE INSERT ON testdb.* FROM test2@localhost;
54
55 connect (test2,localhost,test2,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
56 --error ER_TABLEACCESS_DENIED_ERROR
57 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE testdb.t_10;
58 --error ER_TABLEACCESS_DENIED_ERROR
59 ALTER TABLE testdb.tp EXCHANGE PARTITION p0 WITH TABLE t_10;
60 disconnect test2;
61
62 connection default;
63 --source suite/parts/inc/part_exch_drop_tabs.inc
64
65 DROP USER test2@localhost;
66 DROP DATABASE testdb;