Debian Codegraph @

mysql-test/suite/engines/funcs/t/se_string_where.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
5 --source suite/engines/funcs/t/data1.inc
6 SELECT COUNT(*) FROM t1;
7 SELECT COUNT(*) FROM t1 WHERE c2='a';
8 SELECT COUNT(*) FROM t1 WHERE c1='a';
9 DROP TABLE t1;
10 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
11 --source suite/engines/funcs/t/data1.inc
12 SELECT COUNT(*) FROM t1;
13 SELECT COUNT(*) FROM t1 WHERE c2='b';
14 SELECT COUNT(*) FROM t1 WHERE c1='b';
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
17 --source suite/engines/funcs/t/data1.inc
18 SELECT COUNT(*) FROM t1;
19 SELECT COUNT(*) FROM t1 WHERE c2='c';
20 SELECT COUNT(*) FROM t1 WHERE c1='c';
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
23 --source suite/engines/funcs/t/data1.inc
24 SELECT COUNT(*) FROM t1;
25 SELECT COUNT(*) FROM t1 WHERE c2='d';
26 SELECT COUNT(*) FROM t1 WHERE c1='d';
27 DROP TABLE t1;
28 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
29 --source suite/engines/funcs/t/data1.inc
30 SELECT COUNT(*) FROM t1;
31 SELECT COUNT(*) FROM t1 WHERE c2='e';
32 SELECT COUNT(*) FROM t1 WHERE c1='e';
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
35 --source suite/engines/funcs/t/data1.inc
36 SELECT COUNT(*) FROM t1;
37 SELECT COUNT(*) FROM t1 WHERE c2='f';
38 SELECT COUNT(*) FROM t1 WHERE c1='f';
39 DROP TABLE t1;
40 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
41 --source suite/engines/funcs/t/data1.inc
42 SELECT COUNT(*) FROM t1;
43 SELECT COUNT(*) FROM t1 WHERE c2='y';
44 SELECT COUNT(*) FROM t1 WHERE c1='y';
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
47 --source suite/engines/funcs/t/data1.inc
48 SELECT COUNT(*) FROM t1;
49 SELECT COUNT(*) FROM t1 WHERE c2='a';
50 SELECT COUNT(*) FROM t1 WHERE c1='a';
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
53 --source suite/engines/funcs/t/data1.inc
54 SELECT COUNT(*) FROM t1;
55 SELECT COUNT(*) FROM t1 WHERE c2='b';
56 SELECT COUNT(*) FROM t1 WHERE c1='b';
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
59 --source suite/engines/funcs/t/data1.inc
60 SELECT COUNT(*) FROM t1;
61 SELECT COUNT(*) FROM t1 WHERE c2='c';
62 SELECT COUNT(*) FROM t1 WHERE c1='c';
63 DROP TABLE t1;
64 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
65 --source suite/engines/funcs/t/data1.inc
66 SELECT COUNT(*) FROM t1;
67 SELECT COUNT(*) FROM t1 WHERE c2='d';
68 SELECT COUNT(*) FROM t1 WHERE c1='d';
69 DROP TABLE t1;
70 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
71 --source suite/engines/funcs/t/data1.inc
72 SELECT COUNT(*) FROM t1;
73 SELECT COUNT(*) FROM t1 WHERE c2='e';
74 SELECT COUNT(*) FROM t1 WHERE c1='e';
75 DROP TABLE t1;
76 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
77 --source suite/engines/funcs/t/data1.inc
78 SELECT COUNT(*) FROM t1;
79 SELECT COUNT(*) FROM t1 WHERE c2='f';
80 SELECT COUNT(*) FROM t1 WHERE c1='f';
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
83 --source suite/engines/funcs/t/data1.inc
84 SELECT COUNT(*) FROM t1;
85 SELECT COUNT(*) FROM t1 WHERE c2='y';
86 SELECT COUNT(*) FROM t1 WHERE c1='y';
87 DROP TABLE t1;
88 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
89 --source suite/engines/funcs/t/data1.inc
90 SELECT COUNT(*) FROM t1;
91 SELECT COUNT(*) FROM t1 WHERE c2='a';
92 SELECT COUNT(*) FROM t1 WHERE c1='a';
93 DROP TABLE t1;
94 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
95 --source suite/engines/funcs/t/data1.inc
96 SELECT COUNT(*) FROM t1;
97 SELECT COUNT(*) FROM t1 WHERE c2='b';
98 SELECT COUNT(*) FROM t1 WHERE c1='b';
99 DROP TABLE t1;
100 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
101 --source suite/engines/funcs/t/data1.inc
102 SELECT COUNT(*) FROM t1;
103 SELECT COUNT(*) FROM t1 WHERE c2='c';
104 SELECT COUNT(*) FROM t1 WHERE c1='c';
105 DROP TABLE t1;
106 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
107 --source suite/engines/funcs/t/data1.inc
108 SELECT COUNT(*) FROM t1;
109 SELECT COUNT(*) FROM t1 WHERE c2='d';
110 SELECT COUNT(*) FROM t1 WHERE c1='d';
111 DROP TABLE t1;
112 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
113 --source suite/engines/funcs/t/data1.inc
114 SELECT COUNT(*) FROM t1;
115 SELECT COUNT(*) FROM t1 WHERE c2='e';
116 SELECT COUNT(*) FROM t1 WHERE c1='e';
117 DROP TABLE t1;
118 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
119 --source suite/engines/funcs/t/data1.inc
120 SELECT COUNT(*) FROM t1;
121 SELECT COUNT(*) FROM t1 WHERE c2='f';
122 SELECT COUNT(*) FROM t1 WHERE c1='f';
123 DROP TABLE t1;
124 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
125 --source suite/engines/funcs/t/data1.inc
126 SELECT COUNT(*) FROM t1;
127 SELECT COUNT(*) FROM t1 WHERE c2='y';
128 SELECT COUNT(*) FROM t1 WHERE c1='y';
129 DROP TABLE t1;
130 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
131 --source suite/engines/funcs/t/data1.inc
132 SELECT COUNT(*) FROM t1;
133 SELECT COUNT(*) FROM t1 WHERE c2='a';
134 SELECT COUNT(*) FROM t1 WHERE c1='a';
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
137 --source suite/engines/funcs/t/data1.inc
138 SELECT COUNT(*) FROM t1;
139 SELECT COUNT(*) FROM t1 WHERE c2='b';
140 SELECT COUNT(*) FROM t1 WHERE c1='b';
141 DROP TABLE t1;
142 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
143 --source suite/engines/funcs/t/data1.inc
144 SELECT COUNT(*) FROM t1;
145 SELECT COUNT(*) FROM t1 WHERE c2='c';
146 SELECT COUNT(*) FROM t1 WHERE c1='c';
147 DROP TABLE t1;
148 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
149 --source suite/engines/funcs/t/data1.inc
150 SELECT COUNT(*) FROM t1;
151 SELECT COUNT(*) FROM t1 WHERE c2='d';
152 SELECT COUNT(*) FROM t1 WHERE c1='d';
153 DROP TABLE t1;
154 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
155 --source suite/engines/funcs/t/data1.inc
156 SELECT COUNT(*) FROM t1;
157 SELECT COUNT(*) FROM t1 WHERE c2='e';
158 SELECT COUNT(*) FROM t1 WHERE c1='e';
159 DROP TABLE t1;
160 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
161 --source suite/engines/funcs/t/data1.inc
162 SELECT COUNT(*) FROM t1;
163 SELECT COUNT(*) FROM t1 WHERE c2='f';
164 SELECT COUNT(*) FROM t1 WHERE c1='f';
165 DROP TABLE t1;
166 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
167 --source suite/engines/funcs/t/data1.inc
168 SELECT COUNT(*) FROM t1;
169 SELECT COUNT(*) FROM t1 WHERE c2='y';
170 SELECT COUNT(*) FROM t1 WHERE c1='y';
171 DROP TABLE t1;
172 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
173 --source suite/engines/funcs/t/data1.inc
174 SELECT COUNT(*) FROM t1;
175 SELECT COUNT(*) FROM t1 WHERE c2='a';
176 SELECT COUNT(*) FROM t1 WHERE c1='a';
177 DROP TABLE t1;
178 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
179 --source suite/engines/funcs/t/data1.inc
180 SELECT COUNT(*) FROM t1;
181 SELECT COUNT(*) FROM t1 WHERE c2='b';
182 SELECT COUNT(*) FROM t1 WHERE c1='b';
183 DROP TABLE t1;
184 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
185 --source suite/engines/funcs/t/data1.inc
186 SELECT COUNT(*) FROM t1;
187 SELECT COUNT(*) FROM t1 WHERE c2='c';
188 SELECT COUNT(*) FROM t1 WHERE c1='c';
189 DROP TABLE t1;
190 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
191 --source suite/engines/funcs/t/data1.inc
192 SELECT COUNT(*) FROM t1;
193 SELECT COUNT(*) FROM t1 WHERE c2='d';
194 SELECT COUNT(*) FROM t1 WHERE c1='d';
195 DROP TABLE t1;
196 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
197 --source suite/engines/funcs/t/data1.inc
198 SELECT COUNT(*) FROM t1;
199 SELECT COUNT(*) FROM t1 WHERE c2='e';
200 SELECT COUNT(*) FROM t1 WHERE c1='e';
201 DROP TABLE t1;
202 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
203 --source suite/engines/funcs/t/data1.inc
204 SELECT COUNT(*) FROM t1;
205 SELECT COUNT(*) FROM t1 WHERE c2='f';
206 SELECT COUNT(*) FROM t1 WHERE c1='f';
207 DROP TABLE t1;
208 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
209 --source suite/engines/funcs/t/data1.inc
210 SELECT COUNT(*) FROM t1;
211 SELECT COUNT(*) FROM t1 WHERE c2='y';
212 SELECT COUNT(*) FROM t1 WHERE c1='y';
213 DROP TABLE t1;
214 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
215 --source suite/engines/funcs/t/data1.inc
216 SELECT COUNT(*) FROM t1;
217 SELECT COUNT(*) FROM t1 WHERE c2='a';
218 SELECT COUNT(*) FROM t1 WHERE c1='a';
219 DROP TABLE t1;
220 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
221 --source suite/engines/funcs/t/data1.inc
222 SELECT COUNT(*) FROM t1;
223 SELECT COUNT(*) FROM t1 WHERE c2='b';
224 SELECT COUNT(*) FROM t1 WHERE c1='b';
225 DROP TABLE t1;
226 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
227 --source suite/engines/funcs/t/data1.inc
228 SELECT COUNT(*) FROM t1;
229 SELECT COUNT(*) FROM t1 WHERE c2='c';
230 SELECT COUNT(*) FROM t1 WHERE c1='c';
231 DROP TABLE t1;
232 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
233 --source suite/engines/funcs/t/data1.inc
234 SELECT COUNT(*) FROM t1;
235 SELECT COUNT(*) FROM t1 WHERE c2='d';
236 SELECT COUNT(*) FROM t1 WHERE c1='d';
237 DROP TABLE t1;
238 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
239 --source suite/engines/funcs/t/data1.inc
240 SELECT COUNT(*) FROM t1;
241 SELECT COUNT(*) FROM t1 WHERE c2='e';
242 SELECT COUNT(*) FROM t1 WHERE c1='e';
243 DROP TABLE t1;
244 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
245 --source suite/engines/funcs/t/data1.inc
246 SELECT COUNT(*) FROM t1;
247 SELECT COUNT(*) FROM t1 WHERE c2='f';
248 SELECT COUNT(*) FROM t1 WHERE c1='f';
249 DROP TABLE t1;
250 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
251 --source suite/engines/funcs/t/data1.inc
252 SELECT COUNT(*) FROM t1;
253 SELECT COUNT(*) FROM t1 WHERE c2='y';
254 SELECT COUNT(*) FROM t1 WHERE c1='y';
255 DROP TABLE t1;
256