Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/t/ddl_rewriter.test

raw
1 --echo #
2 --echo # Test for the DDL rewrite plugin.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_ddl_rewriter.inc
6 --source include/have_log_bin.inc
7
8
9 --echo #
10 --echo # Create a table with a DATA DIRECTORY clause, to be dumped and
11 --echo # restored when the plugin is installed.
12 --echo #
13
14 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
15 --eval CREATE TABLE t(i int) DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp';
16 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
17 SHOW CREATE TABLE t;
18 INSERT INTO t VALUES (1);
19 --let $mysqldumpfile = $MYSQLTEST_VARDIR/tmp/mysqldumpfile.sql
20 --exec $MYSQL_DUMP test t > $mysqldumpfile
21
22
23 --echo #
24 --echo # Install plugin.
25 --echo #
26
27 --source suite/query_rewrite_plugins/include/install_ddl_rewriter.inc
28
29 SELECT PLUGIN_NAME, PLUGIN_TYPE, PLUGIN_VERSION, PLUGIN_TYPE_VERSION
30 FROM information_schema.plugins
31 WHERE plugin_name LIKE 'ddl_rewriter';
32
33
34 --echo #
35 --echo # Restore dump file.
36 --echo #
37
38 DROP TABLE t;
39 --exec $MYSQL test < $mysqldumpfile
40 SHOW CREATE TABLE t;
41 --let $assert_text = Expected table contents
42 --let $assert_cond = "[SELECT COUNT(*) FROM t]" = 1
43 --source include/assert.inc
44 DROP TABLE t;
45 --remove_file $mysqldumpfile
46 --rmdir $MYSQLTEST_VARDIR/tmp/test
47
48
49 --echo #
50 --echo # False positives.
51 --echo #
52
53 CREATE TABLE t(i int) /* data directory = 'x' */ ;
54 DROP TABLE t;
55
56 CREATE TABLE t(i int, `j encryption='n'j` int);
57 DROP TABLE t;
58
59
60 --echo #
61 --echo # Prefix comments make the statement not be rewritten.
62 --echo #
63
64 /* */ CREATE TABLE t(i int) /* data directory = 'x' */ ;
65 DROP TABLE t;
66
67 /* */
68 CREATE TABLE t(i int) /* data directory = 'x' */ ;
69 DROP TABLE t;
70
71
72 --echo #
73 --echo # Double quotes.
74 --echo #
75
76 CREATE TABLE t(i int) DATA DIRECTORY = "/tmp";
77 DROP TABLE t;
78
79 CREATE TABLE t(i int) ENCRYPTION = "n";
80 DROP TABLE t;
81
82
83 --echo #
84 --echo # Multi-statement queries are separated before pre-parse,
85 --echo # so a second non-CREATE TABLE statement will be treated
86 --echo # separately.
87 --echo #
88
89 CREATE SCHEMA s; CREATE TABLE s.t(i int) DATA DIRECTORY = '/tmp';
90 DROP SCHEMA s;
91
92 CREATE TABLE t(i int); CREATE SCHEMA s /* DATA DIRECTORY = '/tmp' */;
93 DROP SCHEMA s; DROP TABLE t;
94
95
96 --echo #
97 --echo # Statements with prefix != 'CREATE TABLE' are not rewritten.
98 --echo #
99
100 CREATE SCHEMA s /* data directory = 'x' */ ;
101 DROP SCHEMA s;
102
103 CREATE SCHEMA `s encryption='n' s`;
104 DROP SCHEMA `s encryption='n' s`;
105
106 --echo #
107 --echo # Case sensitivity.
108 --echo #
109
110 CREATE TABLE t(i int) DATA DIRECTORY = '/tmp', ENGINE = MyISAM;
111 DROP TABLE t;
112 create table t(i int) DATA DIRECTORY = '/tmp', ENGINE = MyISAM;
113 DROP TABLE t;
114
115 CREATE TABLE t(i int) data directory = '/tmp', ENGINE = MyISAM;
116 DROP TABLE t;
117
118 CREATE TABLE t(i int) INDEX DIRECTORY = '/tmp', ENGINE = MyISAM;
119 DROP TABLE t;
120 CREATE TABLE t(i int) index directory = '/tmp', ENGINE = MyISAM;
121 DROP TABLE t;
122
123 CREATE TABLE t(i int) ENCRYPTION = 'N', ENGINE = MyISAM;
124 DROP TABLE t;
125 CREATE TABLE t(i int) encryption = 'n', ENGINE = MyISAM;
126 DROP TABLE t;
127 CREATE TABLE t(i int) ENCRYPTION = 'Y', ENGINE = MyISAM;
128 DROP TABLE t;
129 CREATE TABLE t(i int) ENCRYPTION = 'y', ENGINE = MyISAM;
130 DROP TABLE t;
131
132
133 --echo #
134 --echo # Optional preceding comma with optional surrounding whitespace.
135 --echo #
136
137 CREATE TABLE t(i int) ENGINE = MyISAM ENCRYPTION = 'N';
138 DROP TABLE t;
139 CREATE TABLE t(i int) ENGINE = MyISAM,ENCRYPTION = 'N';
140 DROP TABLE t;
141 CREATE TABLE t(i int) ENGINE = MyISAM, ENCRYPTION = 'N';
142 DROP TABLE t;
143 CREATE TABLE t(i int) ENGINE = MyISAM ,ENCRYPTION = 'N';
144 DROP TABLE t;
145 CREATE TABLE t(i int) ENGINE = MyISAM , ENCRYPTION = 'N';
146 DROP TABLE t;
147
148
149 --echo #
150 --echo # Optional succeeding comma with optional surrounding whitespace.
151 --echo #
152
153 CREATE TABLE t(i int) ENCRYPTION = 'N' ENGINE = MyISAM;
154 DROP TABLE t;
155 CREATE TABLE t(i int) ENCRYPTION = 'N',ENGINE = MyISAM;
156 DROP TABLE t;
157 CREATE TABLE t(i int) ENCRYPTION = 'N', ENGINE = MyISAM;
158 DROP TABLE t;
159 CREATE TABLE t(i int) ENCRYPTION = 'N' ,ENGINE = MyISAM;
160 DROP TABLE t;
161 CREATE TABLE t(i int) ENCRYPTION = 'N' , ENGINE = MyISAM;
162 DROP TABLE t;
163
164
165 --echo #
166 --echo # Optional assignment operator with optional surrounding whitespace.
167 --echo #
168
169 CREATE TABLE t(i int) ENCRYPTION 'N' ENGINE = MyISAM;
170 DROP TABLE t;
171 CREATE TABLE t(i int) ENCRYPTION='N' ENGINE = MyISAM;
172 DROP TABLE t;
173 CREATE TABLE t(i int) ENCRYPTION= 'N' ENGINE = MyISAM;
174 DROP TABLE t;
175 CREATE TABLE t(i int) ENCRYPTION ='N' ENGINE = MyISAM;
176 DROP TABLE t;
177 CREATE TABLE t(i int) ENCRYPTION = 'N' ENGINE = MyISAM;
178 DROP TABLE t;
179
180
181 --echo #
182 --echo # Multi line statements.
183 --echo #
184
185 CREATE TABLE t(i int) ENCRYPTION ='N'
186 ,ENGINE = MyISAM
187 DATA
188 DIRECTORY = '/tmp'
189 DEFAULT CHARSET latin1
190 INDEX
191
192 DIRECTORY '/t
193 mp';
194 DROP TABLE t;
195
196
197 --echo #
198 --echo # Partitioned tables.
199 --echo #
200
201 CREATE TABLE t (
202 i int NOT NULL AUTO_INCREMENT,
203 mt mediumtext NOT NULL,
204 c varchar(10) NOT NULL,
205 ti tinyint(1) unsigned NOT NULL,
206 PRIMARY KEY (i, ti)
207 )
208 ENGINE = InnoDB AUTO_INCREMENT = 0
209 DEFAULT CHARSET = latin1, DATA DIRECTORY = '/tmp'
210 PARTITION BY LIST (ti) (
211 PARTITION p0 VALUES IN (0) ENGINE = InnoDB,
212 PARTITION p1 VALUES IN (1) DATA DIRECTORY = '/tmp' ,ENGINE = InnoDB
213 );
214 SHOW CREATE TABLE t;
215 DROP TABLE t;
216
217
218 --echo #
219 --echo # Stored programs.
220 --echo #
221
222 CREATE PROCEDURE p() CREATE TABLE test.t(i int) ENCRYPTION = 'N';
223 CALL p();
224 SHOW CREATE TABLE test.t;
225 DROP TABLE test.t;
226 DROP PROCEDURE p;
227
228 # CREATE TABLE not allowed in a stored function.
229
230
231 --echo #
232 --echo # Prepared statements.
233 --echo #
234
235 PREPARE stmt FROM 'CREATE TABLE test.t(i int) ENCRYPTION = "N"';
236 EXECUTE stmt;
237 SHOW CREATE TABLE test.t;
238 DROP TABLE test.t;
239 DROP PREPARE stmt;
240
241
242 --echo #
243 --echo # Uninstall plugin and verify that queries are not rewritten anymore.
244 --echo #
245
246 UNINSTALL PLUGIN ddl_rewriter;
247 --source include/disconnect_connections.inc
248
249 CREATE TABLE t(i int) /* data directory = 'x' */ ;
250 DROP TABLE t;