diff options
Diffstat (limited to 'test/like2.test')
| -rw-r--r-- | test/like2.test | 1009 |
1 files changed, 1009 insertions, 0 deletions
diff --git a/test/like2.test b/test/like2.test new file mode 100644 index 0000000..4fd1642 --- /dev/null +++ b/test/like2.test @@ -0,0 +1,1009 @@ +# 2008 May 26 +# +# The author disclaims copyright to this source code. In place of +# a legal notice, here is a blessing: +# +# May you do good and not evil. +# May you find forgiveness for yourself and forgive others. +# May you share freely, never taking more than you give. +# +#*********************************************************************** +# This file implements regression tests for SQLite library. The +# focus of this file is testing the LIKE and GLOB operators and +# in particular the optimizations that occur to help those operators +# run faster. +# +# $Id: like2.test,v 1.1 2008/05/26 18:33:41 drh Exp $ + +set testdir [file dirname $argv0] +source $testdir/tester.tcl + +do_test like2-1.1 { + db eval { + CREATE TABLE t1(x INT, y COLLATE NOCASE); + INSERT INTO t1(x,y) VALUES(1,CAST(x'01' AS TEXT)); + INSERT INTO t1(x,y) VALUES(2,CAST(x'02' AS TEXT)); + INSERT INTO t1(x,y) VALUES(3,CAST(x'03' AS TEXT)); + INSERT INTO t1(x,y) VALUES(4,CAST(x'04' AS TEXT)); + INSERT INTO t1(x,y) VALUES(5,CAST(x'05' AS TEXT)); + INSERT INTO t1(x,y) VALUES(6,CAST(x'06' AS TEXT)); + INSERT INTO t1(x,y) VALUES(7,CAST(x'07' AS TEXT)); + INSERT INTO t1(x,y) VALUES(8,CAST(x'08' AS TEXT)); + INSERT INTO t1(x,y) VALUES(9,CAST(x'09' AS TEXT)); + INSERT INTO t1(x,y) VALUES(10,CAST(x'0a' AS TEXT)); + INSERT INTO t1(x,y) VALUES(11,CAST(x'0b' AS TEXT)); + INSERT INTO t1(x,y) VALUES(12,CAST(x'0c' AS TEXT)); + INSERT INTO t1(x,y) VALUES(13,CAST(x'0d' AS TEXT)); + INSERT INTO t1(x,y) VALUES(14,CAST(x'0e' AS TEXT)); + INSERT INTO t1(x,y) VALUES(15,CAST(x'0f' AS TEXT)); + INSERT INTO t1(x,y) VALUES(16,CAST(x'10' AS TEXT)); + INSERT INTO t1(x,y) VALUES(17,CAST(x'11' AS TEXT)); + INSERT INTO t1(x,y) VALUES(18,CAST(x'12' AS TEXT)); + INSERT INTO t1(x,y) VALUES(19,CAST(x'13' AS TEXT)); + INSERT INTO t1(x,y) VALUES(20,CAST(x'14' AS TEXT)); + INSERT INTO t1(x,y) VALUES(21,CAST(x'15' AS TEXT)); + INSERT INTO t1(x,y) VALUES(22,CAST(x'16' AS TEXT)); + INSERT INTO t1(x,y) VALUES(23,CAST(x'17' AS TEXT)); + INSERT INTO t1(x,y) VALUES(24,CAST(x'18' AS TEXT)); + INSERT INTO t1(x,y) VALUES(25,CAST(x'19' AS TEXT)); + INSERT INTO t1(x,y) VALUES(26,CAST(x'1a' AS TEXT)); + INSERT INTO t1(x,y) VALUES(27,CAST(x'1b' AS TEXT)); + INSERT INTO t1(x,y) VALUES(28,CAST(x'1c' AS TEXT)); + INSERT INTO t1(x,y) VALUES(29,CAST(x'1d' AS TEXT)); + INSERT INTO t1(x,y) VALUES(30,CAST(x'1e' AS TEXT)); + INSERT INTO t1(x,y) VALUES(31,CAST(x'1f' AS TEXT)); + INSERT INTO t1(x,y) VALUES(32,' '); + INSERT INTO t1(x,y) VALUES(33,'!'); + INSERT INTO t1(x,y) VALUES(34,'"'); + INSERT INTO t1(x,y) VALUES(35,'#'); + INSERT INTO t1(x,y) VALUES(36,'$'); + INSERT INTO t1(x,y) VALUES(37,'%'); + INSERT INTO t1(x,y) VALUES(38,'&'); + INSERT INTO t1(x,y) VALUES(39,''''); + INSERT INTO t1(x,y) VALUES(40,'('); + INSERT INTO t1(x,y) VALUES(41,')'); + INSERT INTO t1(x,y) VALUES(42,'*'); + INSERT INTO t1(x,y) VALUES(43,'+'); + INSERT INTO t1(x,y) VALUES(44,','); + INSERT INTO t1(x,y) VALUES(45,'-'); + INSERT INTO t1(x,y) VALUES(46,'.'); + INSERT INTO t1(x,y) VALUES(47,'/'); + INSERT INTO t1(x,y) VALUES(48,'0'); + INSERT INTO t1(x,y) VALUES(49,'1'); + INSERT INTO t1(x,y) VALUES(50,'2'); + INSERT INTO t1(x,y) VALUES(51,'3'); + INSERT INTO t1(x,y) VALUES(52,'4'); + INSERT INTO t1(x,y) VALUES(53,'5'); + INSERT INTO t1(x,y) VALUES(54,'6'); + INSERT INTO t1(x,y) VALUES(55,'7'); + INSERT INTO t1(x,y) VALUES(56,'8'); + INSERT INTO t1(x,y) VALUES(57,'9'); + INSERT INTO t1(x,y) VALUES(58,':'); + INSERT INTO t1(x,y) VALUES(59,';'); + INSERT INTO t1(x,y) VALUES(60,'<'); + INSERT INTO t1(x,y) VALUES(61,'='); + INSERT INTO t1(x,y) VALUES(62,'>'); + INSERT INTO t1(x,y) VALUES(63,'?'); + INSERT INTO t1(x,y) VALUES(64,'@'); + INSERT INTO t1(x,y) VALUES(65,'A'); + INSERT INTO t1(x,y) VALUES(66,'B'); + INSERT INTO t1(x,y) VALUES(67,'C'); + INSERT INTO t1(x,y) VALUES(68,'D'); + INSERT INTO t1(x,y) VALUES(69,'E'); + INSERT INTO t1(x,y) VALUES(70,'F'); + INSERT INTO t1(x,y) VALUES(71,'G'); + INSERT INTO t1(x,y) VALUES(72,'H'); + INSERT INTO t1(x,y) VALUES(73,'I'); + INSERT INTO t1(x,y) VALUES(74,'J'); + INSERT INTO t1(x,y) VALUES(75,'K'); + INSERT INTO t1(x,y) VALUES(76,'L'); + INSERT INTO t1(x,y) VALUES(77,'M'); + INSERT INTO t1(x,y) VALUES(78,'N'); + INSERT INTO t1(x,y) VALUES(79,'O'); + INSERT INTO t1(x,y) VALUES(80,'P'); + INSERT INTO t1(x,y) VALUES(81,'Q'); + INSERT INTO t1(x,y) VALUES(82,'R'); + INSERT INTO t1(x,y) VALUES(83,'S'); + INSERT INTO t1(x,y) VALUES(84,'T'); + INSERT INTO t1(x,y) VALUES(85,'U'); + INSERT INTO t1(x,y) VALUES(86,'V'); + INSERT INTO t1(x,y) VALUES(87,'W'); + INSERT INTO t1(x,y) VALUES(88,'X'); + INSERT INTO t1(x,y) VALUES(89,'Y'); + INSERT INTO t1(x,y) VALUES(90,'Z'); + INSERT INTO t1(x,y) VALUES(91,'['); + INSERT INTO t1(x,y) VALUES(92,'\'); + INSERT INTO t1(x,y) VALUES(93,']'); + INSERT INTO t1(x,y) VALUES(94,'^'); + INSERT INTO t1(x,y) VALUES(95,'_'); + INSERT INTO t1(x,y) VALUES(96,'`'); + INSERT INTO t1(x,y) VALUES(97,'a'); + INSERT INTO t1(x,y) VALUES(98,'b'); + INSERT INTO t1(x,y) VALUES(99,'c'); + INSERT INTO t1(x,y) VALUES(100,'d'); + INSERT INTO t1(x,y) VALUES(101,'e'); + INSERT INTO t1(x,y) VALUES(102,'f'); + INSERT INTO t1(x,y) VALUES(103,'g'); + INSERT INTO t1(x,y) VALUES(104,'h'); + INSERT INTO t1(x,y) VALUES(105,'i'); + INSERT INTO t1(x,y) VALUES(106,'j'); + INSERT INTO t1(x,y) VALUES(107,'k'); + INSERT INTO t1(x,y) VALUES(108,'l'); + INSERT INTO t1(x,y) VALUES(109,'m'); + INSERT INTO t1(x,y) VALUES(110,'n'); + INSERT INTO t1(x,y) VALUES(111,'o'); + INSERT INTO t1(x,y) VALUES(112,'p'); + INSERT INTO t1(x,y) VALUES(113,'q'); + INSERT INTO t1(x,y) VALUES(114,'r'); + INSERT INTO t1(x,y) VALUES(115,'s'); + INSERT INTO t1(x,y) VALUES(116,'t'); + INSERT INTO t1(x,y) VALUES(117,'u'); + INSERT INTO t1(x,y) VALUES(118,'v'); + INSERT INTO t1(x,y) VALUES(119,'w'); + INSERT INTO t1(x,y) VALUES(120,'x'); + INSERT INTO t1(x,y) VALUES(121,'y'); + INSERT INTO t1(x,y) VALUES(122,'z'); + INSERT INTO t1(x,y) VALUES(123,'{'); + INSERT INTO t1(x,y) VALUES(124,'|'); + INSERT INTO t1(x,y) VALUES(125,'}'); + INSERT INTO t1(x,y) VALUES(126,'~'); + INSERT INTO t1(x,y) VALUES(127,CAST(x'7f' AS TEXT)); + SELECT count(*) FROM t1; + } +} {127} +do_test like2-1.2 { + db eval { + CREATE TABLE t2(x INT, y COLLATE NOCASE); + INSERT INTO t2 SELECT * FROM t1; + CREATE INDEX i2 ON t2(y); + SELECT count(*) FROM t2; + } +} {127} +do_test like2-1.3 { + db eval { + CREATE TABLE t3(x INT, y COLLATE NOCASE); + INSERT INTO t3 SELECT x, 'abc' || y || 'xyz' FROM t1; + CREATE INDEX i3 ON t3(y); + SELECT count(*) FROM t2; + } +} {127} +do_test like-2.32.1 { + db eval "SELECT x FROM t1 WHERE y LIKE ' %'" +} {32} +do_test like-2.32.2 { + db eval "SELECT x FROM t2 WHERE y LIKE ' %'" +} {32} +do_test like-2.32.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc %'" +} {32} +do_test like-2.33.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '!%'" +} {33} +do_test like-2.33.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '!%'" +} {33} +do_test like-2.33.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc!%'" +} {33} +do_test like-2.34.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\"%'" +} {34} +do_test like-2.34.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\"%'" +} {34} +do_test like-2.34.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\"%'" +} {34} +do_test like-2.35.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '#%'" +} {35} +do_test like-2.35.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '#%'" +} {35} +do_test like-2.35.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc#%'" +} {35} +do_test like-2.36.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\$%'" +} {36} +do_test like-2.36.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\$%'" +} {36} +do_test like-2.36.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\$%'" +} {36} +do_test like-2.38.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '&%'" +} {38} +do_test like-2.38.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '&%'" +} {38} +do_test like-2.38.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc&%'" +} {38} +do_test like-2.39.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '''%'" +} {39} +do_test like-2.39.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '''%'" +} {39} +do_test like-2.39.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc''%'" +} {39} +do_test like-2.40.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '(%'" +} {40} +do_test like-2.40.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '(%'" +} {40} +do_test like-2.40.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc(%'" +} {40} +do_test like-2.41.1 { + db eval "SELECT x FROM t1 WHERE y LIKE ')%'" +} {41} +do_test like-2.41.2 { + db eval "SELECT x FROM t2 WHERE y LIKE ')%'" +} {41} +do_test like-2.41.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc)%'" +} {41} +do_test like-2.42.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '*%'" +} {42} +do_test like-2.42.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '*%'" +} {42} +do_test like-2.42.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc*%'" +} {42} +do_test like-2.43.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '+%'" +} {43} +do_test like-2.43.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '+%'" +} {43} +do_test like-2.43.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc+%'" +} {43} +do_test like-2.44.1 { + db eval "SELECT x FROM t1 WHERE y LIKE ',%'" +} {44} +do_test like-2.44.2 { + db eval "SELECT x FROM t2 WHERE y LIKE ',%'" +} {44} +do_test like-2.44.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc,%'" +} {44} +do_test like-2.45.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '-%'" +} {45} +do_test like-2.45.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '-%'" +} {45} +do_test like-2.45.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc-%'" +} {45} +do_test like-2.46.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '.%'" +} {46} +do_test like-2.46.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '.%'" +} {46} +do_test like-2.46.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc.%'" +} {46} +do_test like-2.47.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '/%'" +} {47} +do_test like-2.47.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '/%'" +} {47} +do_test like-2.47.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc/%'" +} {47} +do_test like-2.48.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '0%'" +} {48} +do_test like-2.48.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '0%'" +} {48} +do_test like-2.48.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc0%'" +} {48} +do_test like-2.49.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '1%'" +} {49} +do_test like-2.49.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '1%'" +} {49} +do_test like-2.49.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc1%'" +} {49} +do_test like-2.50.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '2%'" +} {50} +do_test like-2.50.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '2%'" +} {50} +do_test like-2.50.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc2%'" +} {50} +do_test like-2.51.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '3%'" +} {51} +do_test like-2.51.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '3%'" +} {51} +do_test like-2.51.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc3%'" +} {51} +do_test like-2.52.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '4%'" +} {52} +do_test like-2.52.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '4%'" +} {52} +do_test like-2.52.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc4%'" +} {52} +do_test like-2.53.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '5%'" +} {53} +do_test like-2.53.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '5%'" +} {53} +do_test like-2.53.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc5%'" +} {53} +do_test like-2.54.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '6%'" +} {54} +do_test like-2.54.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '6%'" +} {54} +do_test like-2.54.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc6%'" +} {54} +do_test like-2.55.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '7%'" +} {55} +do_test like-2.55.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '7%'" +} {55} +do_test like-2.55.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc7%'" +} {55} +do_test like-2.56.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '8%'" +} {56} +do_test like-2.56.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '8%'" +} {56} +do_test like-2.56.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc8%'" +} {56} +do_test like-2.57.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '9%'" +} {57} +do_test like-2.57.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '9%'" +} {57} +do_test like-2.57.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc9%'" +} {57} +do_test like-2.58.1 { + db eval "SELECT x FROM t1 WHERE y LIKE ':%'" +} {58} +do_test like-2.58.2 { + db eval "SELECT x FROM t2 WHERE y LIKE ':%'" +} {58} +do_test like-2.58.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc:%'" +} {58} +do_test like-2.59.1 { + db eval "SELECT x FROM t1 WHERE y LIKE ';%'" +} {59} +do_test like-2.59.2 { + db eval "SELECT x FROM t2 WHERE y LIKE ';%'" +} {59} +do_test like-2.59.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc;%'" +} {59} +do_test like-2.60.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '<%'" +} {60} +do_test like-2.60.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '<%'" +} {60} +do_test like-2.60.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc<%'" +} {60} +do_test like-2.61.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '=%'" +} {61} +do_test like-2.61.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '=%'" +} {61} +do_test like-2.61.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc=%'" +} {61} +do_test like-2.62.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '>%'" +} {62} +do_test like-2.62.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '>%'" +} {62} +do_test like-2.62.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc>%'" +} {62} +do_test like-2.63.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '?%'" +} {63} +do_test like-2.63.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '?%'" +} {63} +do_test like-2.63.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc?%'" +} {63} +do_test like-2.64.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '@%'" +} {64} +do_test like-2.64.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '@%'" +} {64} +do_test like-2.64.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc@%'" +} {64} +do_test like-2.65.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'A%'" +} {65 97} +do_test like-2.65.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'A%'" +} {65 97} +do_test like-2.65.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcA%'" +} {65 97} +do_test like-2.66.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'B%'" +} {66 98} +do_test like-2.66.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'B%'" +} {66 98} +do_test like-2.66.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcB%'" +} {66 98} +do_test like-2.67.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'C%'" +} {67 99} +do_test like-2.67.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'C%'" +} {67 99} +do_test like-2.67.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcC%'" +} {67 99} +do_test like-2.68.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'D%'" +} {68 100} +do_test like-2.68.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'D%'" +} {68 100} +do_test like-2.68.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcD%'" +} {68 100} +do_test like-2.69.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'E%'" +} {69 101} +do_test like-2.69.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'E%'" +} {69 101} +do_test like-2.69.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcE%'" +} {69 101} +do_test like-2.70.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'F%'" +} {70 102} +do_test like-2.70.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'F%'" +} {70 102} +do_test like-2.70.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcF%'" +} {70 102} +do_test like-2.71.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'G%'" +} {71 103} +do_test like-2.71.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'G%'" +} {71 103} +do_test like-2.71.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcG%'" +} {71 103} +do_test like-2.72.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'H%'" +} {72 104} +do_test like-2.72.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'H%'" +} {72 104} +do_test like-2.72.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcH%'" +} {72 104} +do_test like-2.73.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'I%'" +} {73 105} +do_test like-2.73.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'I%'" +} {73 105} +do_test like-2.73.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcI%'" +} {73 105} +do_test like-2.74.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'J%'" +} {74 106} +do_test like-2.74.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'J%'" +} {74 106} +do_test like-2.74.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcJ%'" +} {74 106} +do_test like-2.75.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'K%'" +} {75 107} +do_test like-2.75.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'K%'" +} {75 107} +do_test like-2.75.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcK%'" +} {75 107} +do_test like-2.76.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'L%'" +} {76 108} +do_test like-2.76.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'L%'" +} {76 108} +do_test like-2.76.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcL%'" +} {76 108} +do_test like-2.77.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'M%'" +} {77 109} +do_test like-2.77.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'M%'" +} {77 109} +do_test like-2.77.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcM%'" +} {77 109} +do_test like-2.78.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'N%'" +} {78 110} +do_test like-2.78.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'N%'" +} {78 110} +do_test like-2.78.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcN%'" +} {78 110} +do_test like-2.79.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'O%'" +} {79 111} +do_test like-2.79.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'O%'" +} {79 111} +do_test like-2.79.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcO%'" +} {79 111} +do_test like-2.80.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'P%'" +} {80 112} +do_test like-2.80.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'P%'" +} {80 112} +do_test like-2.80.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcP%'" +} {80 112} +do_test like-2.81.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'Q%'" +} {81 113} +do_test like-2.81.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'Q%'" +} {81 113} +do_test like-2.81.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcQ%'" +} {81 113} +do_test like-2.82.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'R%'" +} {82 114} +do_test like-2.82.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'R%'" +} {82 114} +do_test like-2.82.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcR%'" +} {82 114} +do_test like-2.83.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'S%'" +} {83 115} +do_test like-2.83.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'S%'" +} {83 115} +do_test like-2.83.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcS%'" +} {83 115} +do_test like-2.84.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'T%'" +} {84 116} +do_test like-2.84.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'T%'" +} {84 116} +do_test like-2.84.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcT%'" +} {84 116} +do_test like-2.85.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'U%'" +} {85 117} +do_test like-2.85.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'U%'" +} {85 117} +do_test like-2.85.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcU%'" +} {85 117} +do_test like-2.86.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'V%'" +} {86 118} +do_test like-2.86.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'V%'" +} {86 118} +do_test like-2.86.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcV%'" +} {86 118} +do_test like-2.87.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'W%'" +} {87 119} +do_test like-2.87.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'W%'" +} {87 119} +do_test like-2.87.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcW%'" +} {87 119} +do_test like-2.88.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'X%'" +} {88 120} +do_test like-2.88.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'X%'" +} {88 120} +do_test like-2.88.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcX%'" +} {88 120} +do_test like-2.89.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'Y%'" +} {89 121} +do_test like-2.89.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'Y%'" +} {89 121} +do_test like-2.89.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcY%'" +} {89 121} +do_test like-2.90.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'Z%'" +} {90 122} +do_test like-2.90.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'Z%'" +} {90 122} +do_test like-2.90.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcZ%'" +} {90 122} +do_test like-2.91.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\[%'" +} {91} +do_test like-2.91.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\[%'" +} {91} +do_test like-2.91.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\[%'" +} {91} +do_test like-2.92.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\\%'" +} {92} +do_test like-2.92.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\\%'" +} {92} +do_test like-2.92.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\\%'" +} {92} +do_test like-2.93.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\]%'" +} {93} +do_test like-2.93.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\]%'" +} {93} +do_test like-2.93.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\]%'" +} {93} +do_test like-2.94.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '^%'" +} {94} +do_test like-2.94.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '^%'" +} {94} +do_test like-2.94.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc^%'" +} {94} +do_test like-2.96.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '`%'" +} {96} +do_test like-2.96.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '`%'" +} {96} +do_test like-2.96.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc`%'" +} {96} +do_test like-2.97.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'a%'" +} {65 97} +do_test like-2.97.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'a%'" +} {65 97} +do_test like-2.97.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abca%'" +} {65 97} +do_test like-2.98.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'b%'" +} {66 98} +do_test like-2.98.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'b%'" +} {66 98} +do_test like-2.98.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcb%'" +} {66 98} +do_test like-2.99.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'c%'" +} {67 99} +do_test like-2.99.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'c%'" +} {67 99} +do_test like-2.99.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcc%'" +} {67 99} +do_test like-2.100.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'd%'" +} {68 100} +do_test like-2.100.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'd%'" +} {68 100} +do_test like-2.100.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcd%'" +} {68 100} +do_test like-2.101.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'e%'" +} {69 101} +do_test like-2.101.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'e%'" +} {69 101} +do_test like-2.101.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abce%'" +} {69 101} +do_test like-2.102.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'f%'" +} {70 102} +do_test like-2.102.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'f%'" +} {70 102} +do_test like-2.102.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcf%'" +} {70 102} +do_test like-2.103.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'g%'" +} {71 103} +do_test like-2.103.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'g%'" +} {71 103} +do_test like-2.103.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcg%'" +} {71 103} +do_test like-2.104.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'h%'" +} {72 104} +do_test like-2.104.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'h%'" +} {72 104} +do_test like-2.104.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abch%'" +} {72 104} +do_test like-2.105.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'i%'" +} {73 105} +do_test like-2.105.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'i%'" +} {73 105} +do_test like-2.105.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abci%'" +} {73 105} +do_test like-2.106.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'j%'" +} {74 106} +do_test like-2.106.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'j%'" +} {74 106} +do_test like-2.106.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcj%'" +} {74 106} +do_test like-2.107.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'k%'" +} {75 107} +do_test like-2.107.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'k%'" +} {75 107} +do_test like-2.107.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abck%'" +} {75 107} +do_test like-2.108.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'l%'" +} {76 108} +do_test like-2.108.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'l%'" +} {76 108} +do_test like-2.108.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcl%'" +} {76 108} +do_test like-2.109.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'm%'" +} {77 109} +do_test like-2.109.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'm%'" +} {77 109} +do_test like-2.109.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcm%'" +} {77 109} +do_test like-2.110.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'n%'" +} {78 110} +do_test like-2.110.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'n%'" +} {78 110} +do_test like-2.110.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcn%'" +} {78 110} +do_test like-2.111.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'o%'" +} {79 111} +do_test like-2.111.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'o%'" +} {79 111} +do_test like-2.111.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abco%'" +} {79 111} +do_test like-2.112.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'p%'" +} {80 112} +do_test like-2.112.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'p%'" +} {80 112} +do_test like-2.112.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcp%'" +} {80 112} +do_test like-2.113.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'q%'" +} {81 113} +do_test like-2.113.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'q%'" +} {81 113} +do_test like-2.113.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcq%'" +} {81 113} +do_test like-2.114.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'r%'" +} {82 114} +do_test like-2.114.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'r%'" +} {82 114} +do_test like-2.114.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcr%'" +} {82 114} +do_test like-2.115.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 's%'" +} {83 115} +do_test like-2.115.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 's%'" +} {83 115} +do_test like-2.115.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcs%'" +} {83 115} +do_test like-2.116.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 't%'" +} {84 116} +do_test like-2.116.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 't%'" +} {84 116} +do_test like-2.116.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abct%'" +} {84 116} +do_test like-2.117.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'u%'" +} {85 117} +do_test like-2.117.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'u%'" +} {85 117} +do_test like-2.117.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcu%'" +} {85 117} +do_test like-2.118.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'v%'" +} {86 118} +do_test like-2.118.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'v%'" +} {86 118} +do_test like-2.118.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcv%'" +} {86 118} +do_test like-2.119.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'w%'" +} {87 119} +do_test like-2.119.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'w%'" +} {87 119} +do_test like-2.119.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcw%'" +} {87 119} +do_test like-2.120.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'x%'" +} {88 120} +do_test like-2.120.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'x%'" +} {88 120} +do_test like-2.120.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcx%'" +} {88 120} +do_test like-2.121.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'y%'" +} {89 121} +do_test like-2.121.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'y%'" +} {89 121} +do_test like-2.121.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcy%'" +} {89 121} +do_test like-2.122.1 { + db eval "SELECT x FROM t1 WHERE y LIKE 'z%'" +} {90 122} +do_test like-2.122.2 { + db eval "SELECT x FROM t2 WHERE y LIKE 'z%'" +} {90 122} +do_test like-2.122.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abcz%'" +} {90 122} +do_test like-2.123.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\173%'" +} {123} +do_test like-2.123.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\173%'" +} {123} +do_test like-2.123.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\173%'" +} {123} +do_test like-2.124.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '|%'" +} {124} +do_test like-2.124.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '|%'" +} {124} +do_test like-2.124.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc|%'" +} {124} +do_test like-2.125.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '\175%'" +} {125} +do_test like-2.125.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '\175%'" +} {125} +do_test like-2.125.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc\175%'" +} {125} +do_test like-2.126.1 { + db eval "SELECT x FROM t1 WHERE y LIKE '~%'" +} {126} +do_test like-2.126.2 { + db eval "SELECT x FROM t2 WHERE y LIKE '~%'" +} {126} +do_test like-2.126.3 { + db eval "SELECT x FROM t3 WHERE y LIKE 'abc~%'" +} {126} + + +finish_test |