wasCSharpSQLite – Blame information for rev 7
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | office | 1 | # 2008 May 26 |
2 | # |
||
3 | # The author disclaims copyright to this source code. In place of |
||
4 | # a legal notice, here is a blessing: |
||
5 | # |
||
6 | # May you do good and not evil. |
||
7 | # May you find forgiveness for yourself and forgive others. |
||
8 | # May you share freely, never taking more than you give. |
||
9 | # |
||
10 | #*********************************************************************** |
||
11 | # This file implements regression tests for SQLite library. The |
||
12 | # focus of this file is testing the LIKE and GLOB operators and |
||
13 | # in particular the optimizations that occur to help those operators |
||
14 | # run faster. |
||
15 | # |
||
16 | # $Id: like2.test,v 1.1 2008/05/26 18:33:41 drh Exp $ |
||
17 | |||
18 | set testdir [file dirname $argv0] |
||
19 | source $testdir/tester.tcl |
||
20 | |||
21 | do_test like2-1.1 { |
||
22 | db eval { |
||
23 | CREATE TABLE t1(x INT, y COLLATE NOCASE); |
||
24 | INSERT INTO t1(x,y) VALUES(1,CAST(x'01' AS TEXT)); |
||
25 | INSERT INTO t1(x,y) VALUES(2,CAST(x'02' AS TEXT)); |
||
26 | INSERT INTO t1(x,y) VALUES(3,CAST(x'03' AS TEXT)); |
||
27 | INSERT INTO t1(x,y) VALUES(4,CAST(x'04' AS TEXT)); |
||
28 | INSERT INTO t1(x,y) VALUES(5,CAST(x'05' AS TEXT)); |
||
29 | INSERT INTO t1(x,y) VALUES(6,CAST(x'06' AS TEXT)); |
||
30 | INSERT INTO t1(x,y) VALUES(7,CAST(x'07' AS TEXT)); |
||
31 | INSERT INTO t1(x,y) VALUES(8,CAST(x'08' AS TEXT)); |
||
32 | INSERT INTO t1(x,y) VALUES(9,CAST(x'09' AS TEXT)); |
||
33 | INSERT INTO t1(x,y) VALUES(10,CAST(x'0a' AS TEXT)); |
||
34 | INSERT INTO t1(x,y) VALUES(11,CAST(x'0b' AS TEXT)); |
||
35 | INSERT INTO t1(x,y) VALUES(12,CAST(x'0c' AS TEXT)); |
||
36 | INSERT INTO t1(x,y) VALUES(13,CAST(x'0d' AS TEXT)); |
||
37 | INSERT INTO t1(x,y) VALUES(14,CAST(x'0e' AS TEXT)); |
||
38 | INSERT INTO t1(x,y) VALUES(15,CAST(x'0f' AS TEXT)); |
||
39 | INSERT INTO t1(x,y) VALUES(16,CAST(x'10' AS TEXT)); |
||
40 | INSERT INTO t1(x,y) VALUES(17,CAST(x'11' AS TEXT)); |
||
41 | INSERT INTO t1(x,y) VALUES(18,CAST(x'12' AS TEXT)); |
||
42 | INSERT INTO t1(x,y) VALUES(19,CAST(x'13' AS TEXT)); |
||
43 | INSERT INTO t1(x,y) VALUES(20,CAST(x'14' AS TEXT)); |
||
44 | INSERT INTO t1(x,y) VALUES(21,CAST(x'15' AS TEXT)); |
||
45 | INSERT INTO t1(x,y) VALUES(22,CAST(x'16' AS TEXT)); |
||
46 | INSERT INTO t1(x,y) VALUES(23,CAST(x'17' AS TEXT)); |
||
47 | INSERT INTO t1(x,y) VALUES(24,CAST(x'18' AS TEXT)); |
||
48 | INSERT INTO t1(x,y) VALUES(25,CAST(x'19' AS TEXT)); |
||
49 | INSERT INTO t1(x,y) VALUES(26,CAST(x'1a' AS TEXT)); |
||
50 | INSERT INTO t1(x,y) VALUES(27,CAST(x'1b' AS TEXT)); |
||
51 | INSERT INTO t1(x,y) VALUES(28,CAST(x'1c' AS TEXT)); |
||
52 | INSERT INTO t1(x,y) VALUES(29,CAST(x'1d' AS TEXT)); |
||
53 | INSERT INTO t1(x,y) VALUES(30,CAST(x'1e' AS TEXT)); |
||
54 | INSERT INTO t1(x,y) VALUES(31,CAST(x'1f' AS TEXT)); |
||
55 | INSERT INTO t1(x,y) VALUES(32,' '); |
||
56 | INSERT INTO t1(x,y) VALUES(33,'!'); |
||
57 | INSERT INTO t1(x,y) VALUES(34,'"'); |
||
58 | INSERT INTO t1(x,y) VALUES(35,'#'); |
||
59 | INSERT INTO t1(x,y) VALUES(36,'$'); |
||
60 | INSERT INTO t1(x,y) VALUES(37,'%'); |
||
61 | INSERT INTO t1(x,y) VALUES(38,'&'); |
||
62 | INSERT INTO t1(x,y) VALUES(39,''''); |
||
63 | INSERT INTO t1(x,y) VALUES(40,'('); |
||
64 | INSERT INTO t1(x,y) VALUES(41,')'); |
||
65 | INSERT INTO t1(x,y) VALUES(42,'*'); |
||
66 | INSERT INTO t1(x,y) VALUES(43,'+'); |
||
67 | INSERT INTO t1(x,y) VALUES(44,','); |
||
68 | INSERT INTO t1(x,y) VALUES(45,'-'); |
||
69 | INSERT INTO t1(x,y) VALUES(46,'.'); |
||
70 | INSERT INTO t1(x,y) VALUES(47,'/'); |
||
71 | INSERT INTO t1(x,y) VALUES(48,'0'); |
||
72 | INSERT INTO t1(x,y) VALUES(49,'1'); |
||
73 | INSERT INTO t1(x,y) VALUES(50,'2'); |
||
74 | INSERT INTO t1(x,y) VALUES(51,'3'); |
||
75 | INSERT INTO t1(x,y) VALUES(52,'4'); |
||
76 | INSERT INTO t1(x,y) VALUES(53,'5'); |
||
77 | INSERT INTO t1(x,y) VALUES(54,'6'); |
||
78 | INSERT INTO t1(x,y) VALUES(55,'7'); |
||
79 | INSERT INTO t1(x,y) VALUES(56,'8'); |
||
80 | INSERT INTO t1(x,y) VALUES(57,'9'); |
||
81 | INSERT INTO t1(x,y) VALUES(58,':'); |
||
82 | INSERT INTO t1(x,y) VALUES(59,';'); |
||
83 | INSERT INTO t1(x,y) VALUES(60,'<'); |
||
84 | INSERT INTO t1(x,y) VALUES(61,'='); |
||
85 | INSERT INTO t1(x,y) VALUES(62,'>'); |
||
86 | INSERT INTO t1(x,y) VALUES(63,'?'); |
||
87 | INSERT INTO t1(x,y) VALUES(64,'@'); |
||
88 | INSERT INTO t1(x,y) VALUES(65,'A'); |
||
89 | INSERT INTO t1(x,y) VALUES(66,'B'); |
||
90 | INSERT INTO t1(x,y) VALUES(67,'C'); |
||
91 | INSERT INTO t1(x,y) VALUES(68,'D'); |
||
92 | INSERT INTO t1(x,y) VALUES(69,'E'); |
||
93 | INSERT INTO t1(x,y) VALUES(70,'F'); |
||
94 | INSERT INTO t1(x,y) VALUES(71,'G'); |
||
95 | INSERT INTO t1(x,y) VALUES(72,'H'); |
||
96 | INSERT INTO t1(x,y) VALUES(73,'I'); |
||
97 | INSERT INTO t1(x,y) VALUES(74,'J'); |
||
98 | INSERT INTO t1(x,y) VALUES(75,'K'); |
||
99 | INSERT INTO t1(x,y) VALUES(76,'L'); |
||
100 | INSERT INTO t1(x,y) VALUES(77,'M'); |
||
101 | INSERT INTO t1(x,y) VALUES(78,'N'); |
||
102 | INSERT INTO t1(x,y) VALUES(79,'O'); |
||
103 | INSERT INTO t1(x,y) VALUES(80,'P'); |
||
104 | INSERT INTO t1(x,y) VALUES(81,'Q'); |
||
105 | INSERT INTO t1(x,y) VALUES(82,'R'); |
||
106 | INSERT INTO t1(x,y) VALUES(83,'S'); |
||
107 | INSERT INTO t1(x,y) VALUES(84,'T'); |
||
108 | INSERT INTO t1(x,y) VALUES(85,'U'); |
||
109 | INSERT INTO t1(x,y) VALUES(86,'V'); |
||
110 | INSERT INTO t1(x,y) VALUES(87,'W'); |
||
111 | INSERT INTO t1(x,y) VALUES(88,'X'); |
||
112 | INSERT INTO t1(x,y) VALUES(89,'Y'); |
||
113 | INSERT INTO t1(x,y) VALUES(90,'Z'); |
||
114 | INSERT INTO t1(x,y) VALUES(91,'['); |
||
115 | INSERT INTO t1(x,y) VALUES(92,'\'); |
||
116 | INSERT INTO t1(x,y) VALUES(93,']'); |
||
117 | INSERT INTO t1(x,y) VALUES(94,'^'); |
||
118 | INSERT INTO t1(x,y) VALUES(95,'_'); |
||
119 | INSERT INTO t1(x,y) VALUES(96,'`'); |
||
120 | INSERT INTO t1(x,y) VALUES(97,'a'); |
||
121 | INSERT INTO t1(x,y) VALUES(98,'b'); |
||
122 | INSERT INTO t1(x,y) VALUES(99,'c'); |
||
123 | INSERT INTO t1(x,y) VALUES(100,'d'); |
||
124 | INSERT INTO t1(x,y) VALUES(101,'e'); |
||
125 | INSERT INTO t1(x,y) VALUES(102,'f'); |
||
126 | INSERT INTO t1(x,y) VALUES(103,'g'); |
||
127 | INSERT INTO t1(x,y) VALUES(104,'h'); |
||
128 | INSERT INTO t1(x,y) VALUES(105,'i'); |
||
129 | INSERT INTO t1(x,y) VALUES(106,'j'); |
||
130 | INSERT INTO t1(x,y) VALUES(107,'k'); |
||
131 | INSERT INTO t1(x,y) VALUES(108,'l'); |
||
132 | INSERT INTO t1(x,y) VALUES(109,'m'); |
||
133 | INSERT INTO t1(x,y) VALUES(110,'n'); |
||
134 | INSERT INTO t1(x,y) VALUES(111,'o'); |
||
135 | INSERT INTO t1(x,y) VALUES(112,'p'); |
||
136 | INSERT INTO t1(x,y) VALUES(113,'q'); |
||
137 | INSERT INTO t1(x,y) VALUES(114,'r'); |
||
138 | INSERT INTO t1(x,y) VALUES(115,'s'); |
||
139 | INSERT INTO t1(x,y) VALUES(116,'t'); |
||
140 | INSERT INTO t1(x,y) VALUES(117,'u'); |
||
141 | INSERT INTO t1(x,y) VALUES(118,'v'); |
||
142 | INSERT INTO t1(x,y) VALUES(119,'w'); |
||
143 | INSERT INTO t1(x,y) VALUES(120,'x'); |
||
144 | INSERT INTO t1(x,y) VALUES(121,'y'); |
||
145 | INSERT INTO t1(x,y) VALUES(122,'z'); |
||
146 | INSERT INTO t1(x,y) VALUES(123,'{'); |
||
147 | INSERT INTO t1(x,y) VALUES(124,'|'); |
||
148 | INSERT INTO t1(x,y) VALUES(125,'}'); |
||
149 | INSERT INTO t1(x,y) VALUES(126,'~'); |
||
150 | INSERT INTO t1(x,y) VALUES(127,CAST(x'7f' AS TEXT)); |
||
151 | SELECT count(*) FROM t1; |
||
152 | } |
||
153 | } {127} |
||
154 | do_test like2-1.2 { |
||
155 | db eval { |
||
156 | CREATE TABLE t2(x INT, y COLLATE NOCASE); |
||
157 | INSERT INTO t2 SELECT * FROM t1; |
||
158 | CREATE INDEX i2 ON t2(y); |
||
159 | SELECT count(*) FROM t2; |
||
160 | } |
||
161 | } {127} |
||
162 | do_test like2-1.3 { |
||
163 | db eval { |
||
164 | CREATE TABLE t3(x INT, y COLLATE NOCASE); |
||
165 | INSERT INTO t3 SELECT x, 'abc' || y || 'xyz' FROM t1; |
||
166 | CREATE INDEX i3 ON t3(y); |
||
167 | SELECT count(*) FROM t2; |
||
168 | } |
||
169 | } {127} |
||
170 | do_test like-2.32.1 { |
||
171 | db eval "SELECT x FROM t1 WHERE y LIKE ' %'" |
||
172 | } {32} |
||
173 | do_test like-2.32.2 { |
||
174 | db eval "SELECT x FROM t2 WHERE y LIKE ' %'" |
||
175 | } {32} |
||
176 | do_test like-2.32.3 { |
||
177 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc %'" |
||
178 | } {32} |
||
179 | do_test like-2.33.1 { |
||
180 | db eval "SELECT x FROM t1 WHERE y LIKE '!%'" |
||
181 | } {33} |
||
182 | do_test like-2.33.2 { |
||
183 | db eval "SELECT x FROM t2 WHERE y LIKE '!%'" |
||
184 | } {33} |
||
185 | do_test like-2.33.3 { |
||
186 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc!%'" |
||
187 | } {33} |
||
188 | do_test like-2.34.1 { |
||
189 | db eval "SELECT x FROM t1 WHERE y LIKE '\"%'" |
||
190 | } {34} |
||
191 | do_test like-2.34.2 { |
||
192 | db eval "SELECT x FROM t2 WHERE y LIKE '\"%'" |
||
193 | } {34} |
||
194 | do_test like-2.34.3 { |
||
195 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\"%'" |
||
196 | } {34} |
||
197 | do_test like-2.35.1 { |
||
198 | db eval "SELECT x FROM t1 WHERE y LIKE '#%'" |
||
199 | } {35} |
||
200 | do_test like-2.35.2 { |
||
201 | db eval "SELECT x FROM t2 WHERE y LIKE '#%'" |
||
202 | } {35} |
||
203 | do_test like-2.35.3 { |
||
204 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc#%'" |
||
205 | } {35} |
||
206 | do_test like-2.36.1 { |
||
207 | db eval "SELECT x FROM t1 WHERE y LIKE '\$%'" |
||
208 | } {36} |
||
209 | do_test like-2.36.2 { |
||
210 | db eval "SELECT x FROM t2 WHERE y LIKE '\$%'" |
||
211 | } {36} |
||
212 | do_test like-2.36.3 { |
||
213 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\$%'" |
||
214 | } {36} |
||
215 | do_test like-2.38.1 { |
||
216 | db eval "SELECT x FROM t1 WHERE y LIKE '&%'" |
||
217 | } {38} |
||
218 | do_test like-2.38.2 { |
||
219 | db eval "SELECT x FROM t2 WHERE y LIKE '&%'" |
||
220 | } {38} |
||
221 | do_test like-2.38.3 { |
||
222 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc&%'" |
||
223 | } {38} |
||
224 | do_test like-2.39.1 { |
||
225 | db eval "SELECT x FROM t1 WHERE y LIKE '''%'" |
||
226 | } {39} |
||
227 | do_test like-2.39.2 { |
||
228 | db eval "SELECT x FROM t2 WHERE y LIKE '''%'" |
||
229 | } {39} |
||
230 | do_test like-2.39.3 { |
||
231 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc''%'" |
||
232 | } {39} |
||
233 | do_test like-2.40.1 { |
||
234 | db eval "SELECT x FROM t1 WHERE y LIKE '(%'" |
||
235 | } {40} |
||
236 | do_test like-2.40.2 { |
||
237 | db eval "SELECT x FROM t2 WHERE y LIKE '(%'" |
||
238 | } {40} |
||
239 | do_test like-2.40.3 { |
||
240 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc(%'" |
||
241 | } {40} |
||
242 | do_test like-2.41.1 { |
||
243 | db eval "SELECT x FROM t1 WHERE y LIKE ')%'" |
||
244 | } {41} |
||
245 | do_test like-2.41.2 { |
||
246 | db eval "SELECT x FROM t2 WHERE y LIKE ')%'" |
||
247 | } {41} |
||
248 | do_test like-2.41.3 { |
||
249 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc)%'" |
||
250 | } {41} |
||
251 | do_test like-2.42.1 { |
||
252 | db eval "SELECT x FROM t1 WHERE y LIKE '*%'" |
||
253 | } {42} |
||
254 | do_test like-2.42.2 { |
||
255 | db eval "SELECT x FROM t2 WHERE y LIKE '*%'" |
||
256 | } {42} |
||
257 | do_test like-2.42.3 { |
||
258 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc*%'" |
||
259 | } {42} |
||
260 | do_test like-2.43.1 { |
||
261 | db eval "SELECT x FROM t1 WHERE y LIKE '+%'" |
||
262 | } {43} |
||
263 | do_test like-2.43.2 { |
||
264 | db eval "SELECT x FROM t2 WHERE y LIKE '+%'" |
||
265 | } {43} |
||
266 | do_test like-2.43.3 { |
||
267 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc+%'" |
||
268 | } {43} |
||
269 | do_test like-2.44.1 { |
||
270 | db eval "SELECT x FROM t1 WHERE y LIKE ',%'" |
||
271 | } {44} |
||
272 | do_test like-2.44.2 { |
||
273 | db eval "SELECT x FROM t2 WHERE y LIKE ',%'" |
||
274 | } {44} |
||
275 | do_test like-2.44.3 { |
||
276 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc,%'" |
||
277 | } {44} |
||
278 | do_test like-2.45.1 { |
||
279 | db eval "SELECT x FROM t1 WHERE y LIKE '-%'" |
||
280 | } {45} |
||
281 | do_test like-2.45.2 { |
||
282 | db eval "SELECT x FROM t2 WHERE y LIKE '-%'" |
||
283 | } {45} |
||
284 | do_test like-2.45.3 { |
||
285 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc-%'" |
||
286 | } {45} |
||
287 | do_test like-2.46.1 { |
||
288 | db eval "SELECT x FROM t1 WHERE y LIKE '.%'" |
||
289 | } {46} |
||
290 | do_test like-2.46.2 { |
||
291 | db eval "SELECT x FROM t2 WHERE y LIKE '.%'" |
||
292 | } {46} |
||
293 | do_test like-2.46.3 { |
||
294 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc.%'" |
||
295 | } {46} |
||
296 | do_test like-2.47.1 { |
||
297 | db eval "SELECT x FROM t1 WHERE y LIKE '/%'" |
||
298 | } {47} |
||
299 | do_test like-2.47.2 { |
||
300 | db eval "SELECT x FROM t2 WHERE y LIKE '/%'" |
||
301 | } {47} |
||
302 | do_test like-2.47.3 { |
||
303 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc/%'" |
||
304 | } {47} |
||
305 | do_test like-2.48.1 { |
||
306 | db eval "SELECT x FROM t1 WHERE y LIKE '0%'" |
||
307 | } {48} |
||
308 | do_test like-2.48.2 { |
||
309 | db eval "SELECT x FROM t2 WHERE y LIKE '0%'" |
||
310 | } {48} |
||
311 | do_test like-2.48.3 { |
||
312 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc0%'" |
||
313 | } {48} |
||
314 | do_test like-2.49.1 { |
||
315 | db eval "SELECT x FROM t1 WHERE y LIKE '1%'" |
||
316 | } {49} |
||
317 | do_test like-2.49.2 { |
||
318 | db eval "SELECT x FROM t2 WHERE y LIKE '1%'" |
||
319 | } {49} |
||
320 | do_test like-2.49.3 { |
||
321 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc1%'" |
||
322 | } {49} |
||
323 | do_test like-2.50.1 { |
||
324 | db eval "SELECT x FROM t1 WHERE y LIKE '2%'" |
||
325 | } {50} |
||
326 | do_test like-2.50.2 { |
||
327 | db eval "SELECT x FROM t2 WHERE y LIKE '2%'" |
||
328 | } {50} |
||
329 | do_test like-2.50.3 { |
||
330 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc2%'" |
||
331 | } {50} |
||
332 | do_test like-2.51.1 { |
||
333 | db eval "SELECT x FROM t1 WHERE y LIKE '3%'" |
||
334 | } {51} |
||
335 | do_test like-2.51.2 { |
||
336 | db eval "SELECT x FROM t2 WHERE y LIKE '3%'" |
||
337 | } {51} |
||
338 | do_test like-2.51.3 { |
||
339 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc3%'" |
||
340 | } {51} |
||
341 | do_test like-2.52.1 { |
||
342 | db eval "SELECT x FROM t1 WHERE y LIKE '4%'" |
||
343 | } {52} |
||
344 | do_test like-2.52.2 { |
||
345 | db eval "SELECT x FROM t2 WHERE y LIKE '4%'" |
||
346 | } {52} |
||
347 | do_test like-2.52.3 { |
||
348 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc4%'" |
||
349 | } {52} |
||
350 | do_test like-2.53.1 { |
||
351 | db eval "SELECT x FROM t1 WHERE y LIKE '5%'" |
||
352 | } {53} |
||
353 | do_test like-2.53.2 { |
||
354 | db eval "SELECT x FROM t2 WHERE y LIKE '5%'" |
||
355 | } {53} |
||
356 | do_test like-2.53.3 { |
||
357 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc5%'" |
||
358 | } {53} |
||
359 | do_test like-2.54.1 { |
||
360 | db eval "SELECT x FROM t1 WHERE y LIKE '6%'" |
||
361 | } {54} |
||
362 | do_test like-2.54.2 { |
||
363 | db eval "SELECT x FROM t2 WHERE y LIKE '6%'" |
||
364 | } {54} |
||
365 | do_test like-2.54.3 { |
||
366 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc6%'" |
||
367 | } {54} |
||
368 | do_test like-2.55.1 { |
||
369 | db eval "SELECT x FROM t1 WHERE y LIKE '7%'" |
||
370 | } {55} |
||
371 | do_test like-2.55.2 { |
||
372 | db eval "SELECT x FROM t2 WHERE y LIKE '7%'" |
||
373 | } {55} |
||
374 | do_test like-2.55.3 { |
||
375 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc7%'" |
||
376 | } {55} |
||
377 | do_test like-2.56.1 { |
||
378 | db eval "SELECT x FROM t1 WHERE y LIKE '8%'" |
||
379 | } {56} |
||
380 | do_test like-2.56.2 { |
||
381 | db eval "SELECT x FROM t2 WHERE y LIKE '8%'" |
||
382 | } {56} |
||
383 | do_test like-2.56.3 { |
||
384 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc8%'" |
||
385 | } {56} |
||
386 | do_test like-2.57.1 { |
||
387 | db eval "SELECT x FROM t1 WHERE y LIKE '9%'" |
||
388 | } {57} |
||
389 | do_test like-2.57.2 { |
||
390 | db eval "SELECT x FROM t2 WHERE y LIKE '9%'" |
||
391 | } {57} |
||
392 | do_test like-2.57.3 { |
||
393 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc9%'" |
||
394 | } {57} |
||
395 | do_test like-2.58.1 { |
||
396 | db eval "SELECT x FROM t1 WHERE y LIKE ':%'" |
||
397 | } {58} |
||
398 | do_test like-2.58.2 { |
||
399 | db eval "SELECT x FROM t2 WHERE y LIKE ':%'" |
||
400 | } {58} |
||
401 | do_test like-2.58.3 { |
||
402 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc:%'" |
||
403 | } {58} |
||
404 | do_test like-2.59.1 { |
||
405 | db eval "SELECT x FROM t1 WHERE y LIKE ';%'" |
||
406 | } {59} |
||
407 | do_test like-2.59.2 { |
||
408 | db eval "SELECT x FROM t2 WHERE y LIKE ';%'" |
||
409 | } {59} |
||
410 | do_test like-2.59.3 { |
||
411 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc;%'" |
||
412 | } {59} |
||
413 | do_test like-2.60.1 { |
||
414 | db eval "SELECT x FROM t1 WHERE y LIKE '<%'" |
||
415 | } {60} |
||
416 | do_test like-2.60.2 { |
||
417 | db eval "SELECT x FROM t2 WHERE y LIKE '<%'" |
||
418 | } {60} |
||
419 | do_test like-2.60.3 { |
||
420 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc<%'" |
||
421 | } {60} |
||
422 | do_test like-2.61.1 { |
||
423 | db eval "SELECT x FROM t1 WHERE y LIKE '=%'" |
||
424 | } {61} |
||
425 | do_test like-2.61.2 { |
||
426 | db eval "SELECT x FROM t2 WHERE y LIKE '=%'" |
||
427 | } {61} |
||
428 | do_test like-2.61.3 { |
||
429 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc=%'" |
||
430 | } {61} |
||
431 | do_test like-2.62.1 { |
||
432 | db eval "SELECT x FROM t1 WHERE y LIKE '>%'" |
||
433 | } {62} |
||
434 | do_test like-2.62.2 { |
||
435 | db eval "SELECT x FROM t2 WHERE y LIKE '>%'" |
||
436 | } {62} |
||
437 | do_test like-2.62.3 { |
||
438 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc>%'" |
||
439 | } {62} |
||
440 | do_test like-2.63.1 { |
||
441 | db eval "SELECT x FROM t1 WHERE y LIKE '?%'" |
||
442 | } {63} |
||
443 | do_test like-2.63.2 { |
||
444 | db eval "SELECT x FROM t2 WHERE y LIKE '?%'" |
||
445 | } {63} |
||
446 | do_test like-2.63.3 { |
||
447 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc?%'" |
||
448 | } {63} |
||
449 | do_test like-2.64.1 { |
||
450 | db eval "SELECT x FROM t1 WHERE y LIKE '@%'" |
||
451 | } {64} |
||
452 | do_test like-2.64.2 { |
||
453 | db eval "SELECT x FROM t2 WHERE y LIKE '@%'" |
||
454 | } {64} |
||
455 | do_test like-2.64.3 { |
||
456 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc@%'" |
||
457 | } {64} |
||
458 | do_test like-2.65.1 { |
||
459 | db eval "SELECT x FROM t1 WHERE y LIKE 'A%'" |
||
460 | } {65 97} |
||
461 | do_test like-2.65.2 { |
||
462 | db eval "SELECT x FROM t2 WHERE y LIKE 'A%'" |
||
463 | } {65 97} |
||
464 | do_test like-2.65.3 { |
||
465 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcA%'" |
||
466 | } {65 97} |
||
467 | do_test like-2.66.1 { |
||
468 | db eval "SELECT x FROM t1 WHERE y LIKE 'B%'" |
||
469 | } {66 98} |
||
470 | do_test like-2.66.2 { |
||
471 | db eval "SELECT x FROM t2 WHERE y LIKE 'B%'" |
||
472 | } {66 98} |
||
473 | do_test like-2.66.3 { |
||
474 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcB%'" |
||
475 | } {66 98} |
||
476 | do_test like-2.67.1 { |
||
477 | db eval "SELECT x FROM t1 WHERE y LIKE 'C%'" |
||
478 | } {67 99} |
||
479 | do_test like-2.67.2 { |
||
480 | db eval "SELECT x FROM t2 WHERE y LIKE 'C%'" |
||
481 | } {67 99} |
||
482 | do_test like-2.67.3 { |
||
483 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcC%'" |
||
484 | } {67 99} |
||
485 | do_test like-2.68.1 { |
||
486 | db eval "SELECT x FROM t1 WHERE y LIKE 'D%'" |
||
487 | } {68 100} |
||
488 | do_test like-2.68.2 { |
||
489 | db eval "SELECT x FROM t2 WHERE y LIKE 'D%'" |
||
490 | } {68 100} |
||
491 | do_test like-2.68.3 { |
||
492 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcD%'" |
||
493 | } {68 100} |
||
494 | do_test like-2.69.1 { |
||
495 | db eval "SELECT x FROM t1 WHERE y LIKE 'E%'" |
||
496 | } {69 101} |
||
497 | do_test like-2.69.2 { |
||
498 | db eval "SELECT x FROM t2 WHERE y LIKE 'E%'" |
||
499 | } {69 101} |
||
500 | do_test like-2.69.3 { |
||
501 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcE%'" |
||
502 | } {69 101} |
||
503 | do_test like-2.70.1 { |
||
504 | db eval "SELECT x FROM t1 WHERE y LIKE 'F%'" |
||
505 | } {70 102} |
||
506 | do_test like-2.70.2 { |
||
507 | db eval "SELECT x FROM t2 WHERE y LIKE 'F%'" |
||
508 | } {70 102} |
||
509 | do_test like-2.70.3 { |
||
510 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcF%'" |
||
511 | } {70 102} |
||
512 | do_test like-2.71.1 { |
||
513 | db eval "SELECT x FROM t1 WHERE y LIKE 'G%'" |
||
514 | } {71 103} |
||
515 | do_test like-2.71.2 { |
||
516 | db eval "SELECT x FROM t2 WHERE y LIKE 'G%'" |
||
517 | } {71 103} |
||
518 | do_test like-2.71.3 { |
||
519 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcG%'" |
||
520 | } {71 103} |
||
521 | do_test like-2.72.1 { |
||
522 | db eval "SELECT x FROM t1 WHERE y LIKE 'H%'" |
||
523 | } {72 104} |
||
524 | do_test like-2.72.2 { |
||
525 | db eval "SELECT x FROM t2 WHERE y LIKE 'H%'" |
||
526 | } {72 104} |
||
527 | do_test like-2.72.3 { |
||
528 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcH%'" |
||
529 | } {72 104} |
||
530 | do_test like-2.73.1 { |
||
531 | db eval "SELECT x FROM t1 WHERE y LIKE 'I%'" |
||
532 | } {73 105} |
||
533 | do_test like-2.73.2 { |
||
534 | db eval "SELECT x FROM t2 WHERE y LIKE 'I%'" |
||
535 | } {73 105} |
||
536 | do_test like-2.73.3 { |
||
537 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcI%'" |
||
538 | } {73 105} |
||
539 | do_test like-2.74.1 { |
||
540 | db eval "SELECT x FROM t1 WHERE y LIKE 'J%'" |
||
541 | } {74 106} |
||
542 | do_test like-2.74.2 { |
||
543 | db eval "SELECT x FROM t2 WHERE y LIKE 'J%'" |
||
544 | } {74 106} |
||
545 | do_test like-2.74.3 { |
||
546 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcJ%'" |
||
547 | } {74 106} |
||
548 | do_test like-2.75.1 { |
||
549 | db eval "SELECT x FROM t1 WHERE y LIKE 'K%'" |
||
550 | } {75 107} |
||
551 | do_test like-2.75.2 { |
||
552 | db eval "SELECT x FROM t2 WHERE y LIKE 'K%'" |
||
553 | } {75 107} |
||
554 | do_test like-2.75.3 { |
||
555 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcK%'" |
||
556 | } {75 107} |
||
557 | do_test like-2.76.1 { |
||
558 | db eval "SELECT x FROM t1 WHERE y LIKE 'L%'" |
||
559 | } {76 108} |
||
560 | do_test like-2.76.2 { |
||
561 | db eval "SELECT x FROM t2 WHERE y LIKE 'L%'" |
||
562 | } {76 108} |
||
563 | do_test like-2.76.3 { |
||
564 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcL%'" |
||
565 | } {76 108} |
||
566 | do_test like-2.77.1 { |
||
567 | db eval "SELECT x FROM t1 WHERE y LIKE 'M%'" |
||
568 | } {77 109} |
||
569 | do_test like-2.77.2 { |
||
570 | db eval "SELECT x FROM t2 WHERE y LIKE 'M%'" |
||
571 | } {77 109} |
||
572 | do_test like-2.77.3 { |
||
573 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcM%'" |
||
574 | } {77 109} |
||
575 | do_test like-2.78.1 { |
||
576 | db eval "SELECT x FROM t1 WHERE y LIKE 'N%'" |
||
577 | } {78 110} |
||
578 | do_test like-2.78.2 { |
||
579 | db eval "SELECT x FROM t2 WHERE y LIKE 'N%'" |
||
580 | } {78 110} |
||
581 | do_test like-2.78.3 { |
||
582 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcN%'" |
||
583 | } {78 110} |
||
584 | do_test like-2.79.1 { |
||
585 | db eval "SELECT x FROM t1 WHERE y LIKE 'O%'" |
||
586 | } {79 111} |
||
587 | do_test like-2.79.2 { |
||
588 | db eval "SELECT x FROM t2 WHERE y LIKE 'O%'" |
||
589 | } {79 111} |
||
590 | do_test like-2.79.3 { |
||
591 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcO%'" |
||
592 | } {79 111} |
||
593 | do_test like-2.80.1 { |
||
594 | db eval "SELECT x FROM t1 WHERE y LIKE 'P%'" |
||
595 | } {80 112} |
||
596 | do_test like-2.80.2 { |
||
597 | db eval "SELECT x FROM t2 WHERE y LIKE 'P%'" |
||
598 | } {80 112} |
||
599 | do_test like-2.80.3 { |
||
600 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcP%'" |
||
601 | } {80 112} |
||
602 | do_test like-2.81.1 { |
||
603 | db eval "SELECT x FROM t1 WHERE y LIKE 'Q%'" |
||
604 | } {81 113} |
||
605 | do_test like-2.81.2 { |
||
606 | db eval "SELECT x FROM t2 WHERE y LIKE 'Q%'" |
||
607 | } {81 113} |
||
608 | do_test like-2.81.3 { |
||
609 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcQ%'" |
||
610 | } {81 113} |
||
611 | do_test like-2.82.1 { |
||
612 | db eval "SELECT x FROM t1 WHERE y LIKE 'R%'" |
||
613 | } {82 114} |
||
614 | do_test like-2.82.2 { |
||
615 | db eval "SELECT x FROM t2 WHERE y LIKE 'R%'" |
||
616 | } {82 114} |
||
617 | do_test like-2.82.3 { |
||
618 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcR%'" |
||
619 | } {82 114} |
||
620 | do_test like-2.83.1 { |
||
621 | db eval "SELECT x FROM t1 WHERE y LIKE 'S%'" |
||
622 | } {83 115} |
||
623 | do_test like-2.83.2 { |
||
624 | db eval "SELECT x FROM t2 WHERE y LIKE 'S%'" |
||
625 | } {83 115} |
||
626 | do_test like-2.83.3 { |
||
627 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcS%'" |
||
628 | } {83 115} |
||
629 | do_test like-2.84.1 { |
||
630 | db eval "SELECT x FROM t1 WHERE y LIKE 'T%'" |
||
631 | } {84 116} |
||
632 | do_test like-2.84.2 { |
||
633 | db eval "SELECT x FROM t2 WHERE y LIKE 'T%'" |
||
634 | } {84 116} |
||
635 | do_test like-2.84.3 { |
||
636 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcT%'" |
||
637 | } {84 116} |
||
638 | do_test like-2.85.1 { |
||
639 | db eval "SELECT x FROM t1 WHERE y LIKE 'U%'" |
||
640 | } {85 117} |
||
641 | do_test like-2.85.2 { |
||
642 | db eval "SELECT x FROM t2 WHERE y LIKE 'U%'" |
||
643 | } {85 117} |
||
644 | do_test like-2.85.3 { |
||
645 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcU%'" |
||
646 | } {85 117} |
||
647 | do_test like-2.86.1 { |
||
648 | db eval "SELECT x FROM t1 WHERE y LIKE 'V%'" |
||
649 | } {86 118} |
||
650 | do_test like-2.86.2 { |
||
651 | db eval "SELECT x FROM t2 WHERE y LIKE 'V%'" |
||
652 | } {86 118} |
||
653 | do_test like-2.86.3 { |
||
654 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcV%'" |
||
655 | } {86 118} |
||
656 | do_test like-2.87.1 { |
||
657 | db eval "SELECT x FROM t1 WHERE y LIKE 'W%'" |
||
658 | } {87 119} |
||
659 | do_test like-2.87.2 { |
||
660 | db eval "SELECT x FROM t2 WHERE y LIKE 'W%'" |
||
661 | } {87 119} |
||
662 | do_test like-2.87.3 { |
||
663 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcW%'" |
||
664 | } {87 119} |
||
665 | do_test like-2.88.1 { |
||
666 | db eval "SELECT x FROM t1 WHERE y LIKE 'X%'" |
||
667 | } {88 120} |
||
668 | do_test like-2.88.2 { |
||
669 | db eval "SELECT x FROM t2 WHERE y LIKE 'X%'" |
||
670 | } {88 120} |
||
671 | do_test like-2.88.3 { |
||
672 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcX%'" |
||
673 | } {88 120} |
||
674 | do_test like-2.89.1 { |
||
675 | db eval "SELECT x FROM t1 WHERE y LIKE 'Y%'" |
||
676 | } {89 121} |
||
677 | do_test like-2.89.2 { |
||
678 | db eval "SELECT x FROM t2 WHERE y LIKE 'Y%'" |
||
679 | } {89 121} |
||
680 | do_test like-2.89.3 { |
||
681 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcY%'" |
||
682 | } {89 121} |
||
683 | do_test like-2.90.1 { |
||
684 | db eval "SELECT x FROM t1 WHERE y LIKE 'Z%'" |
||
685 | } {90 122} |
||
686 | do_test like-2.90.2 { |
||
687 | db eval "SELECT x FROM t2 WHERE y LIKE 'Z%'" |
||
688 | } {90 122} |
||
689 | do_test like-2.90.3 { |
||
690 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcZ%'" |
||
691 | } {90 122} |
||
692 | do_test like-2.91.1 { |
||
693 | db eval "SELECT x FROM t1 WHERE y LIKE '\[%'" |
||
694 | } {91} |
||
695 | do_test like-2.91.2 { |
||
696 | db eval "SELECT x FROM t2 WHERE y LIKE '\[%'" |
||
697 | } {91} |
||
698 | do_test like-2.91.3 { |
||
699 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\[%'" |
||
700 | } {91} |
||
701 | do_test like-2.92.1 { |
||
702 | db eval "SELECT x FROM t1 WHERE y LIKE '\\%'" |
||
703 | } {92} |
||
704 | do_test like-2.92.2 { |
||
705 | db eval "SELECT x FROM t2 WHERE y LIKE '\\%'" |
||
706 | } {92} |
||
707 | do_test like-2.92.3 { |
||
708 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\\%'" |
||
709 | } {92} |
||
710 | do_test like-2.93.1 { |
||
711 | db eval "SELECT x FROM t1 WHERE y LIKE '\]%'" |
||
712 | } {93} |
||
713 | do_test like-2.93.2 { |
||
714 | db eval "SELECT x FROM t2 WHERE y LIKE '\]%'" |
||
715 | } {93} |
||
716 | do_test like-2.93.3 { |
||
717 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\]%'" |
||
718 | } {93} |
||
719 | do_test like-2.94.1 { |
||
720 | db eval "SELECT x FROM t1 WHERE y LIKE '^%'" |
||
721 | } {94} |
||
722 | do_test like-2.94.2 { |
||
723 | db eval "SELECT x FROM t2 WHERE y LIKE '^%'" |
||
724 | } {94} |
||
725 | do_test like-2.94.3 { |
||
726 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc^%'" |
||
727 | } {94} |
||
728 | do_test like-2.96.1 { |
||
729 | db eval "SELECT x FROM t1 WHERE y LIKE '`%'" |
||
730 | } {96} |
||
731 | do_test like-2.96.2 { |
||
732 | db eval "SELECT x FROM t2 WHERE y LIKE '`%'" |
||
733 | } {96} |
||
734 | do_test like-2.96.3 { |
||
735 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc`%'" |
||
736 | } {96} |
||
737 | do_test like-2.97.1 { |
||
738 | db eval "SELECT x FROM t1 WHERE y LIKE 'a%'" |
||
739 | } {65 97} |
||
740 | do_test like-2.97.2 { |
||
741 | db eval "SELECT x FROM t2 WHERE y LIKE 'a%'" |
||
742 | } {65 97} |
||
743 | do_test like-2.97.3 { |
||
744 | db eval "SELECT x FROM t3 WHERE y LIKE 'abca%'" |
||
745 | } {65 97} |
||
746 | do_test like-2.98.1 { |
||
747 | db eval "SELECT x FROM t1 WHERE y LIKE 'b%'" |
||
748 | } {66 98} |
||
749 | do_test like-2.98.2 { |
||
750 | db eval "SELECT x FROM t2 WHERE y LIKE 'b%'" |
||
751 | } {66 98} |
||
752 | do_test like-2.98.3 { |
||
753 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcb%'" |
||
754 | } {66 98} |
||
755 | do_test like-2.99.1 { |
||
756 | db eval "SELECT x FROM t1 WHERE y LIKE 'c%'" |
||
757 | } {67 99} |
||
758 | do_test like-2.99.2 { |
||
759 | db eval "SELECT x FROM t2 WHERE y LIKE 'c%'" |
||
760 | } {67 99} |
||
761 | do_test like-2.99.3 { |
||
762 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcc%'" |
||
763 | } {67 99} |
||
764 | do_test like-2.100.1 { |
||
765 | db eval "SELECT x FROM t1 WHERE y LIKE 'd%'" |
||
766 | } {68 100} |
||
767 | do_test like-2.100.2 { |
||
768 | db eval "SELECT x FROM t2 WHERE y LIKE 'd%'" |
||
769 | } {68 100} |
||
770 | do_test like-2.100.3 { |
||
771 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcd%'" |
||
772 | } {68 100} |
||
773 | do_test like-2.101.1 { |
||
774 | db eval "SELECT x FROM t1 WHERE y LIKE 'e%'" |
||
775 | } {69 101} |
||
776 | do_test like-2.101.2 { |
||
777 | db eval "SELECT x FROM t2 WHERE y LIKE 'e%'" |
||
778 | } {69 101} |
||
779 | do_test like-2.101.3 { |
||
780 | db eval "SELECT x FROM t3 WHERE y LIKE 'abce%'" |
||
781 | } {69 101} |
||
782 | do_test like-2.102.1 { |
||
783 | db eval "SELECT x FROM t1 WHERE y LIKE 'f%'" |
||
784 | } {70 102} |
||
785 | do_test like-2.102.2 { |
||
786 | db eval "SELECT x FROM t2 WHERE y LIKE 'f%'" |
||
787 | } {70 102} |
||
788 | do_test like-2.102.3 { |
||
789 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcf%'" |
||
790 | } {70 102} |
||
791 | do_test like-2.103.1 { |
||
792 | db eval "SELECT x FROM t1 WHERE y LIKE 'g%'" |
||
793 | } {71 103} |
||
794 | do_test like-2.103.2 { |
||
795 | db eval "SELECT x FROM t2 WHERE y LIKE 'g%'" |
||
796 | } {71 103} |
||
797 | do_test like-2.103.3 { |
||
798 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcg%'" |
||
799 | } {71 103} |
||
800 | do_test like-2.104.1 { |
||
801 | db eval "SELECT x FROM t1 WHERE y LIKE 'h%'" |
||
802 | } {72 104} |
||
803 | do_test like-2.104.2 { |
||
804 | db eval "SELECT x FROM t2 WHERE y LIKE 'h%'" |
||
805 | } {72 104} |
||
806 | do_test like-2.104.3 { |
||
807 | db eval "SELECT x FROM t3 WHERE y LIKE 'abch%'" |
||
808 | } {72 104} |
||
809 | do_test like-2.105.1 { |
||
810 | db eval "SELECT x FROM t1 WHERE y LIKE 'i%'" |
||
811 | } {73 105} |
||
812 | do_test like-2.105.2 { |
||
813 | db eval "SELECT x FROM t2 WHERE y LIKE 'i%'" |
||
814 | } {73 105} |
||
815 | do_test like-2.105.3 { |
||
816 | db eval "SELECT x FROM t3 WHERE y LIKE 'abci%'" |
||
817 | } {73 105} |
||
818 | do_test like-2.106.1 { |
||
819 | db eval "SELECT x FROM t1 WHERE y LIKE 'j%'" |
||
820 | } {74 106} |
||
821 | do_test like-2.106.2 { |
||
822 | db eval "SELECT x FROM t2 WHERE y LIKE 'j%'" |
||
823 | } {74 106} |
||
824 | do_test like-2.106.3 { |
||
825 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcj%'" |
||
826 | } {74 106} |
||
827 | do_test like-2.107.1 { |
||
828 | db eval "SELECT x FROM t1 WHERE y LIKE 'k%'" |
||
829 | } {75 107} |
||
830 | do_test like-2.107.2 { |
||
831 | db eval "SELECT x FROM t2 WHERE y LIKE 'k%'" |
||
832 | } {75 107} |
||
833 | do_test like-2.107.3 { |
||
834 | db eval "SELECT x FROM t3 WHERE y LIKE 'abck%'" |
||
835 | } {75 107} |
||
836 | do_test like-2.108.1 { |
||
837 | db eval "SELECT x FROM t1 WHERE y LIKE 'l%'" |
||
838 | } {76 108} |
||
839 | do_test like-2.108.2 { |
||
840 | db eval "SELECT x FROM t2 WHERE y LIKE 'l%'" |
||
841 | } {76 108} |
||
842 | do_test like-2.108.3 { |
||
843 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcl%'" |
||
844 | } {76 108} |
||
845 | do_test like-2.109.1 { |
||
846 | db eval "SELECT x FROM t1 WHERE y LIKE 'm%'" |
||
847 | } {77 109} |
||
848 | do_test like-2.109.2 { |
||
849 | db eval "SELECT x FROM t2 WHERE y LIKE 'm%'" |
||
850 | } {77 109} |
||
851 | do_test like-2.109.3 { |
||
852 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcm%'" |
||
853 | } {77 109} |
||
854 | do_test like-2.110.1 { |
||
855 | db eval "SELECT x FROM t1 WHERE y LIKE 'n%'" |
||
856 | } {78 110} |
||
857 | do_test like-2.110.2 { |
||
858 | db eval "SELECT x FROM t2 WHERE y LIKE 'n%'" |
||
859 | } {78 110} |
||
860 | do_test like-2.110.3 { |
||
861 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcn%'" |
||
862 | } {78 110} |
||
863 | do_test like-2.111.1 { |
||
864 | db eval "SELECT x FROM t1 WHERE y LIKE 'o%'" |
||
865 | } {79 111} |
||
866 | do_test like-2.111.2 { |
||
867 | db eval "SELECT x FROM t2 WHERE y LIKE 'o%'" |
||
868 | } {79 111} |
||
869 | do_test like-2.111.3 { |
||
870 | db eval "SELECT x FROM t3 WHERE y LIKE 'abco%'" |
||
871 | } {79 111} |
||
872 | do_test like-2.112.1 { |
||
873 | db eval "SELECT x FROM t1 WHERE y LIKE 'p%'" |
||
874 | } {80 112} |
||
875 | do_test like-2.112.2 { |
||
876 | db eval "SELECT x FROM t2 WHERE y LIKE 'p%'" |
||
877 | } {80 112} |
||
878 | do_test like-2.112.3 { |
||
879 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcp%'" |
||
880 | } {80 112} |
||
881 | do_test like-2.113.1 { |
||
882 | db eval "SELECT x FROM t1 WHERE y LIKE 'q%'" |
||
883 | } {81 113} |
||
884 | do_test like-2.113.2 { |
||
885 | db eval "SELECT x FROM t2 WHERE y LIKE 'q%'" |
||
886 | } {81 113} |
||
887 | do_test like-2.113.3 { |
||
888 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcq%'" |
||
889 | } {81 113} |
||
890 | do_test like-2.114.1 { |
||
891 | db eval "SELECT x FROM t1 WHERE y LIKE 'r%'" |
||
892 | } {82 114} |
||
893 | do_test like-2.114.2 { |
||
894 | db eval "SELECT x FROM t2 WHERE y LIKE 'r%'" |
||
895 | } {82 114} |
||
896 | do_test like-2.114.3 { |
||
897 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcr%'" |
||
898 | } {82 114} |
||
899 | do_test like-2.115.1 { |
||
900 | db eval "SELECT x FROM t1 WHERE y LIKE 's%'" |
||
901 | } {83 115} |
||
902 | do_test like-2.115.2 { |
||
903 | db eval "SELECT x FROM t2 WHERE y LIKE 's%'" |
||
904 | } {83 115} |
||
905 | do_test like-2.115.3 { |
||
906 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcs%'" |
||
907 | } {83 115} |
||
908 | do_test like-2.116.1 { |
||
909 | db eval "SELECT x FROM t1 WHERE y LIKE 't%'" |
||
910 | } {84 116} |
||
911 | do_test like-2.116.2 { |
||
912 | db eval "SELECT x FROM t2 WHERE y LIKE 't%'" |
||
913 | } {84 116} |
||
914 | do_test like-2.116.3 { |
||
915 | db eval "SELECT x FROM t3 WHERE y LIKE 'abct%'" |
||
916 | } {84 116} |
||
917 | do_test like-2.117.1 { |
||
918 | db eval "SELECT x FROM t1 WHERE y LIKE 'u%'" |
||
919 | } {85 117} |
||
920 | do_test like-2.117.2 { |
||
921 | db eval "SELECT x FROM t2 WHERE y LIKE 'u%'" |
||
922 | } {85 117} |
||
923 | do_test like-2.117.3 { |
||
924 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcu%'" |
||
925 | } {85 117} |
||
926 | do_test like-2.118.1 { |
||
927 | db eval "SELECT x FROM t1 WHERE y LIKE 'v%'" |
||
928 | } {86 118} |
||
929 | do_test like-2.118.2 { |
||
930 | db eval "SELECT x FROM t2 WHERE y LIKE 'v%'" |
||
931 | } {86 118} |
||
932 | do_test like-2.118.3 { |
||
933 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcv%'" |
||
934 | } {86 118} |
||
935 | do_test like-2.119.1 { |
||
936 | db eval "SELECT x FROM t1 WHERE y LIKE 'w%'" |
||
937 | } {87 119} |
||
938 | do_test like-2.119.2 { |
||
939 | db eval "SELECT x FROM t2 WHERE y LIKE 'w%'" |
||
940 | } {87 119} |
||
941 | do_test like-2.119.3 { |
||
942 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcw%'" |
||
943 | } {87 119} |
||
944 | do_test like-2.120.1 { |
||
945 | db eval "SELECT x FROM t1 WHERE y LIKE 'x%'" |
||
946 | } {88 120} |
||
947 | do_test like-2.120.2 { |
||
948 | db eval "SELECT x FROM t2 WHERE y LIKE 'x%'" |
||
949 | } {88 120} |
||
950 | do_test like-2.120.3 { |
||
951 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcx%'" |
||
952 | } {88 120} |
||
953 | do_test like-2.121.1 { |
||
954 | db eval "SELECT x FROM t1 WHERE y LIKE 'y%'" |
||
955 | } {89 121} |
||
956 | do_test like-2.121.2 { |
||
957 | db eval "SELECT x FROM t2 WHERE y LIKE 'y%'" |
||
958 | } {89 121} |
||
959 | do_test like-2.121.3 { |
||
960 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcy%'" |
||
961 | } {89 121} |
||
962 | do_test like-2.122.1 { |
||
963 | db eval "SELECT x FROM t1 WHERE y LIKE 'z%'" |
||
964 | } {90 122} |
||
965 | do_test like-2.122.2 { |
||
966 | db eval "SELECT x FROM t2 WHERE y LIKE 'z%'" |
||
967 | } {90 122} |
||
968 | do_test like-2.122.3 { |
||
969 | db eval "SELECT x FROM t3 WHERE y LIKE 'abcz%'" |
||
970 | } {90 122} |
||
971 | do_test like-2.123.1 { |
||
972 | db eval "SELECT x FROM t1 WHERE y LIKE '\173%'" |
||
973 | } {123} |
||
974 | do_test like-2.123.2 { |
||
975 | db eval "SELECT x FROM t2 WHERE y LIKE '\173%'" |
||
976 | } {123} |
||
977 | do_test like-2.123.3 { |
||
978 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\173%'" |
||
979 | } {123} |
||
980 | do_test like-2.124.1 { |
||
981 | db eval "SELECT x FROM t1 WHERE y LIKE '|%'" |
||
982 | } {124} |
||
983 | do_test like-2.124.2 { |
||
984 | db eval "SELECT x FROM t2 WHERE y LIKE '|%'" |
||
985 | } {124} |
||
986 | do_test like-2.124.3 { |
||
987 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc|%'" |
||
988 | } {124} |
||
989 | do_test like-2.125.1 { |
||
990 | db eval "SELECT x FROM t1 WHERE y LIKE '\175%'" |
||
991 | } {125} |
||
992 | do_test like-2.125.2 { |
||
993 | db eval "SELECT x FROM t2 WHERE y LIKE '\175%'" |
||
994 | } {125} |
||
995 | do_test like-2.125.3 { |
||
996 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc\175%'" |
||
997 | } {125} |
||
998 | do_test like-2.126.1 { |
||
999 | db eval "SELECT x FROM t1 WHERE y LIKE '~%'" |
||
1000 | } {126} |
||
1001 | do_test like-2.126.2 { |
||
1002 | db eval "SELECT x FROM t2 WHERE y LIKE '~%'" |
||
1003 | } {126} |
||
1004 | do_test like-2.126.3 { |
||
1005 | db eval "SELECT x FROM t3 WHERE y LIKE 'abc~%'" |
||
1006 | } {126} |
||
1007 | |||
1008 | |||
1009 | finish_test |