| OLD | NEW |
|---|
| (Empty) | |
| 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 |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 949043002:
Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed)
Base URL: git@github.com:domokit/mojo.git@master