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 c1='a' AND c2 = 'a';
9
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
10
--source suite/engines/funcs/t/data1.inc
11
SELECT COUNT(*) FROM t1;
12
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
14
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
15
--source suite/engines/funcs/t/data1.inc
16
SELECT COUNT(*) FROM t1;
17
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
19
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
20
--source suite/engines/funcs/t/data1.inc
21
SELECT COUNT(*) FROM t1;
22
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
24
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
25
--source suite/engines/funcs/t/data1.inc
26
SELECT COUNT(*) FROM t1;
27
SELECT COUNT(*) FROM t1 WHERE c1='e' AND c2 = 'e';
29
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
30
--source suite/engines/funcs/t/data1.inc
31
SELECT COUNT(*) FROM t1;
32
SELECT COUNT(*) FROM t1 WHERE c1='f' AND c2 = 'f';
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 c1='y' AND c2 = 'y';
39
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
40
--source suite/engines/funcs/t/data1.inc
41
SELECT COUNT(*) FROM t1;
42
SELECT COUNT(*) FROM t1 WHERE c1='a' AND c2 = 'a';
44
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
45
--source suite/engines/funcs/t/data1.inc
46
SELECT COUNT(*) FROM t1;
47
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
49
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
50
--source suite/engines/funcs/t/data1.inc
51
SELECT COUNT(*) FROM t1;
52
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
54
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
55
--source suite/engines/funcs/t/data1.inc
56
SELECT COUNT(*) FROM t1;
57
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
59
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
60
--source suite/engines/funcs/t/data1.inc
61
SELECT COUNT(*) FROM t1;
62
SELECT COUNT(*) FROM t1 WHERE c1='e' AND c2 = 'e';
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 c1='f' AND c2 = 'f';
69
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
70
--source suite/engines/funcs/t/data1.inc
71
SELECT COUNT(*) FROM t1;
72
SELECT COUNT(*) FROM t1 WHERE c1='y' AND c2 = 'y';
74
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
75
--source suite/engines/funcs/t/data1.inc
76
SELECT COUNT(*) FROM t1;
77
SELECT COUNT(*) FROM t1 WHERE c1='a' AND c2 = 'a';
79
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
80
--source suite/engines/funcs/t/data1.inc
81
SELECT COUNT(*) FROM t1;
82
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
84
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
85
--source suite/engines/funcs/t/data1.inc
86
SELECT COUNT(*) FROM t1;
87
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
89
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
90
--source suite/engines/funcs/t/data1.inc
91
SELECT COUNT(*) FROM t1;
92
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
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 c1='e' AND c2 = 'e';
99
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
100
--source suite/engines/funcs/t/data1.inc
101
SELECT COUNT(*) FROM t1;
102
SELECT COUNT(*) FROM t1 WHERE c1='f' AND c2 = 'f';
104
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
105
--source suite/engines/funcs/t/data1.inc
106
SELECT COUNT(*) FROM t1;
107
SELECT COUNT(*) FROM t1 WHERE c1='y' AND c2 = 'y';
109
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
110
--source suite/engines/funcs/t/data1.inc
111
SELECT COUNT(*) FROM t1;
112
SELECT COUNT(*) FROM t1 WHERE c1='a' AND c2 = 'a';
114
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
115
--source suite/engines/funcs/t/data1.inc
116
SELECT COUNT(*) FROM t1;
117
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
119
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
120
--source suite/engines/funcs/t/data1.inc
121
SELECT COUNT(*) FROM t1;
122
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
124
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
125
--source suite/engines/funcs/t/data1.inc
126
SELECT COUNT(*) FROM t1;
127
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
129
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
130
--source suite/engines/funcs/t/data1.inc
131
SELECT COUNT(*) FROM t1;
132
SELECT COUNT(*) FROM t1 WHERE c1='e' AND c2 = 'e';
134
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
135
--source suite/engines/funcs/t/data1.inc
136
SELECT COUNT(*) FROM t1;
137
SELECT COUNT(*) FROM t1 WHERE c1='f' AND c2 = 'f';
139
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
140
--source suite/engines/funcs/t/data1.inc
141
SELECT COUNT(*) FROM t1;
142
SELECT COUNT(*) FROM t1 WHERE c1='y' AND c2 = 'y';
144
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
145
--source suite/engines/funcs/t/data1.inc
146
SELECT COUNT(*) FROM t1;
147
SELECT COUNT(*) FROM t1 WHERE c1='a' AND c2 = 'a';
149
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
150
--source suite/engines/funcs/t/data1.inc
151
SELECT COUNT(*) FROM t1;
152
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
154
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
155
--source suite/engines/funcs/t/data1.inc
156
SELECT COUNT(*) FROM t1;
157
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
159
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
160
--source suite/engines/funcs/t/data1.inc
161
SELECT COUNT(*) FROM t1;
162
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
164
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
165
--source suite/engines/funcs/t/data1.inc
166
SELECT COUNT(*) FROM t1;
167
SELECT COUNT(*) FROM t1 WHERE c1='e' AND c2 = 'e';
169
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
170
--source suite/engines/funcs/t/data1.inc
171
SELECT COUNT(*) FROM t1;
172
SELECT COUNT(*) FROM t1 WHERE c1='f' AND c2 = 'f';
174
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
175
--source suite/engines/funcs/t/data1.inc
176
SELECT COUNT(*) FROM t1;
177
SELECT COUNT(*) FROM t1 WHERE c1='y' AND c2 = 'y';
179
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
180
--source suite/engines/funcs/t/data1.inc
181
SELECT COUNT(*) FROM t1;
182
SELECT COUNT(*) FROM t1 WHERE c1='a' AND c2 = 'a';
184
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
185
--source suite/engines/funcs/t/data1.inc
186
SELECT COUNT(*) FROM t1;
187
SELECT COUNT(*) FROM t1 WHERE c1='b' AND c2 = 'b';
189
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
190
--source suite/engines/funcs/t/data1.inc
191
SELECT COUNT(*) FROM t1;
192
SELECT COUNT(*) FROM t1 WHERE c1='c' AND c2 = 'c';
194
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
195
--source suite/engines/funcs/t/data1.inc
196
SELECT COUNT(*) FROM t1;
197
SELECT COUNT(*) FROM t1 WHERE c1='d' AND c2 = 'd';
199
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
200
--source suite/engines/funcs/t/data1.inc
201
SELECT COUNT(*) FROM t1;
202
SELECT COUNT(*) FROM t1 WHERE c1='e' AND c2 = 'e';
204
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
205
--source suite/engines/funcs/t/data1.inc
206
SELECT COUNT(*) FROM t1;
207
SELECT COUNT(*) FROM t1 WHERE c1='f' AND c2 = 'f';
209
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
210
--source suite/engines/funcs/t/data1.inc
211
SELECT COUNT(*) FROM t1;
212
SELECT COUNT(*) FROM t1 WHERE c1='y' AND c2 = 'y';