2
DROP TABLE IF EXISTS t1;
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';
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';