diff options
| author | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
|---|---|---|
| committer | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
| commit | b2057f506a09e2adef81fc77efd697d16ae14bec (patch) | |
| tree | 3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/like2.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/like2.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/like2.test | 1009 |
1 files changed, 0 insertions, 1009 deletions
diff --git a/components/external/SQLite-3.8.1/test/like2.test b/components/external/SQLite-3.8.1/test/like2.test deleted file mode 100644 index 4fd16420ad..0000000000 --- a/components/external/SQLite-3.8.1/test/like2.test +++ /dev/null @@ -1,1009 +0,0 @@ -# 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 |
