# 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%'"