Debian Codegraph @

mysql-test/suite/secondary_engine/t/load.test

raw
1 --source include/no_ps_protocol.inc
2 --disable_query_log
3 eval INSTALL PLUGIN mock SONAME '$MOCK_PLUGIN';
4 --enable_query_log
5
6 --echo #
7 --echo # Load into and unload from secondary engine.
8 --echo #
9 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
10 ALTER TABLE t1 SECONDARY_LOAD;
11 ALTER TABLE t1 SECONDARY_UNLOAD;
12 SHOW CREATE TABLE t1;
13 DROP TABLE t1;
14
15 --echo #
16 --echo # Attempt to load and unload table with no secondary engine.
17 --echo #
18 CREATE TABLE t1 (a INT);
19 --error ER_SECONDARY_ENGINE
20 ALTER TABLE t1 SECONDARY_LOAD;
21 --error ER_SECONDARY_ENGINE
22 ALTER TABLE t1 SECONDARY_UNLOAD;
23 ALTER TABLE t1 SECONDARY_ENGINE NULL;
24 DROP TABLE t1;
25
26 --echo #
27 --echo # Attempt to unload temporary table with no secondary engine.
28 --echo #
29 CREATE TEMPORARY TABLE t1 (a INT);
30 --error ER_SECONDARY_ENGINE
31 ALTER TABLE t1 SECONDARY_LOAD;
32 --error ER_SECONDARY_ENGINE
33 ALTER TABLE t1 SECONDARY_UNLOAD;
34 ALTER TABLE t1 SECONDARY_ENGINE NULL;
35 DROP TABLE t1;
36
37 --echo #
38 --echo # Attempt to load into secondary engine in conjunction with other DDL
39 --echo # operations.
40 --echo #
41 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
42 --error ER_PARSE_ERROR
43 ALTER TABLE t1 SECONDARY_LOAD, FORCE;
44 DROP TABLE t1;
45
46 --echo #
47 --echo # Perform alterations related to secondary engine using differing
48 --echo # algorithms.
49 --echo #
50 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
51 --error ER_PARSE_ERROR
52 ALTER TABLE t1 SECONDARY_LOAD, ALGORITHM=INPLACE;
53 --error ER_PARSE_ERROR
54 ALTER TABLE t1 SECONDARY_UNLOAD, ALGORITHM=INPLACE;
55 --error ER_PARSE_ERROR
56 ALTER TABLE t1 SECONDARY_LOAD, ALGORITHM=COPY;
57 --error ER_PARSE_ERROR
58 ALTER TABLE t1 SECONDARY_UNLOAD, ALGORITHM=COPY;
59 ALTER TABLE t1 SECONDARY_ENGINE NULL, ALGORITHM=INPLACE;
60 ALTER TABLE t1 SECONDARY_ENGINE MOCK, ALGORITHM=INPLACE;
61 ALTER TABLE t1 SECONDARY_ENGINE NULL, ALGORITHM=COPY;
62 ALTER TABLE t1 SECONDARY_ENGINE MOCK, ALGORITHM=COPY;
63 SHOW CREATE TABLE t1;
64 DROP TABLE t1;
65
66 --echo #
67 --echo # Load and unload a table in one session while another session
68 --echo # accesses the table concurrently.
69 --echo #
70 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
71 --disable_query_log
72 --disable_result_log
73 connect(con1, localhost, root);
74 let $i = 0;
75 while ($i < 10) {
76 inc $i;
77 connection con1;
78 --send ALTER TABLE t1 SECONDARY_LOAD; ALTER TABLE t1 SECONDARY_UNLOAD
79 connection default;
80 SELECT * FROM t1;
81 SELECT * FROM t1;
82 SELECT * FROM t1;
83 SELECT * FROM t1;
84 SELECT * FROM t1;
85 connection con1;
86 reap;
87 }
88 disconnect con1;
89 connection default;
90 --enable_query_log
91 --enable_result_log
92 DROP TABLE t1;
93
94 --echo #
95 --echo # Attempt to LOCK TABLE before loading a table into secondary engine.
96 --echo #
97 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
98 LOCK TABLES t1 WRITE;
99 ALTER TABLE t1 SECONDARY_LOAD;
100 ALTER TABLE t1 SECONDARY_UNLOAD;
101 UNLOCK TABLES;
102 LOCK TABLES t1 READ;
103 --error ER_TABLE_NOT_LOCKED_FOR_WRITE
104 ALTER TABLE t1 SECONDARY_LOAD;
105 --error ER_TABLE_NOT_LOCKED_FOR_WRITE
106 ALTER TABLE t1 SECONDARY_UNLOAD;
107 LOCK TABLES t1 WRITE;
108 ALTER TABLE t1 SECONDARY_LOAD;
109 ALTER TABLE t1 SECONDARY_UNLOAD;
110 UNLOCK TABLES;
111 ALTER TABLE t1 SECONDARY_LOAD;
112 ALTER TABLE t1 SECONDARY_UNLOAD;
113 DROP TABLE t1;
114
115 --echo #
116 --echo # Bug#28835066: Table not unloaded with SECONDARY_ENGINE = NULL
117 --echo #
118 CREATE TABLE t1 (a INT) SECONDARY_ENGINE MOCK;
119 ALTER TABLE t1 SECONDARY_LOAD;
120 ALTER TABLE t1 SECONDARY_ENGINE NULL;
121 ALTER TABLE t1 SECONDARY_ENGINE MOCK;
122 FLUSH STATUS;
123 SELECT * FROM t1;
124 SHOW SESSION STATUS LIKE 'Secondary_engine_execution_count';
125 DROP TABLE t1;
126
127 --echo #
128 --echo # Exclude some columns from secondary engine.
129 --echo #
130 CREATE TABLE t1 (
131 a INT,
132 b INT NOT SECONDARY,
133 c INT,
134 d INT NOT SECONDARY
135 ) SECONDARY_ENGINE MOCK;
136 ALTER TABLE t1 SECONDARY_LOAD;
137 DROP TABLE t1;
138
139 --echo #
140 --echo # Attempt to exclude all columns from secondary engine.
141 --echo #
142 CREATE TABLE t1 (a INT NOT SECONDARY, b INT NOT SECONDARY) SECONDARY_ENGINE MOCK;
143 CREATE TABLE t2 (a INT NOT SECONDARY, KEY i ((a < 10))) SECONDARY_ENGINE MOCK;
144 --error ER_SECONDARY_ENGINE
145 ALTER TABLE t1 SECONDARY_LOAD;
146 --error ER_SECONDARY_ENGINE
147 ALTER TABLE t2 SECONDARY_LOAD;
148 DROP TABLE t1, t2;
149
150 --disable_query_log
151 UNINSTALL PLUGIN mock;
152 --enable_query_log