Annotation of embedaddon/sqlite3/test/like2.test, revision 1.1
1.1 ! misho 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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to like2.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test