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 1010
