/ Hex Artifact Content
Login

Artifact 3b2ee13149ba4a8a60b59756f4e5d345573852da:


0000: 23 20 32 30 30 38 20 4d 61 79 20 32 36 0a 23 0a  # 2008 May 26.#.
0010: 23 20 54 68 65 20 61 75 74 68 6f 72 20 64 69 73  # The author dis
0020: 63 6c 61 69 6d 73 20 63 6f 70 79 72 69 67 68 74  claims copyright
0030: 20 74 6f 20 74 68 69 73 20 73 6f 75 72 63 65 20   to this source 
0040: 63 6f 64 65 2e 20 20 49 6e 20 70 6c 61 63 65 20  code.  In place 
0050: 6f 66 0a 23 20 61 20 6c 65 67 61 6c 20 6e 6f 74  of.# a legal not
0060: 69 63 65 2c 20 68 65 72 65 20 69 73 20 61 20 62  ice, here is a b
0070: 6c 65 73 73 69 6e 67 3a 0a 23 0a 23 20 20 20 20  lessing:.#.#    
0080: 4d 61 79 20 79 6f 75 20 64 6f 20 67 6f 6f 64 20  May you do good 
0090: 61 6e 64 20 6e 6f 74 20 65 76 69 6c 2e 0a 23 20  and not evil..# 
00a0: 20 20 20 4d 61 79 20 79 6f 75 20 66 69 6e 64 20     May you find 
00b0: 66 6f 72 67 69 76 65 6e 65 73 73 20 66 6f 72 20  forgiveness for 
00c0: 79 6f 75 72 73 65 6c 66 20 61 6e 64 20 66 6f 72  yourself and for
00d0: 67 69 76 65 20 6f 74 68 65 72 73 2e 0a 23 20 20  give others..#  
00e0: 20 20 4d 61 79 20 79 6f 75 20 73 68 61 72 65 20    May you share 
00f0: 66 72 65 65 6c 79 2c 20 6e 65 76 65 72 20 74 61  freely, never ta
0100: 6b 69 6e 67 20 6d 6f 72 65 20 74 68 61 6e 20 79  king more than y
0110: 6f 75 20 67 69 76 65 2e 0a 23 0a 23 2a 2a 2a 2a  ou give..#.#****
0120: 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a  ****************
0130: 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a  ****************
0140: 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a  ****************
0150: 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a 2a  ****************
0160: 2a 2a 2a 0a 23 20 54 68 69 73 20 66 69 6c 65 20  ***.# This file 
0170: 69 6d 70 6c 65 6d 65 6e 74 73 20 72 65 67 72 65  implements regre
0180: 73 73 69 6f 6e 20 74 65 73 74 73 20 66 6f 72 20  ssion tests for 
0190: 53 51 4c 69 74 65 20 6c 69 62 72 61 72 79 2e 20  SQLite library. 
01a0: 20 54 68 65 0a 23 20 66 6f 63 75 73 20 6f 66 20   The.# focus of 
01b0: 74 68 69 73 20 66 69 6c 65 20 69 73 20 74 65 73  this file is tes
01c0: 74 69 6e 67 20 74 68 65 20 4c 49 4b 45 20 61 6e  ting the LIKE an
01d0: 64 20 47 4c 4f 42 20 6f 70 65 72 61 74 6f 72 73  d GLOB operators
01e0: 20 61 6e 64 0a 23 20 69 6e 20 70 61 72 74 69 63   and.# in partic
01f0: 75 6c 61 72 20 74 68 65 20 6f 70 74 69 6d 69 7a  ular the optimiz
0200: 61 74 69 6f 6e 73 20 74 68 61 74 20 6f 63 63 75  ations that occu
0210: 72 20 74 6f 20 68 65 6c 70 20 74 68 6f 73 65 20  r to help those 
0220: 6f 70 65 72 61 74 6f 72 73 0a 23 20 72 75 6e 20  operators.# run 
0230: 66 61 73 74 65 72 2e 0a 23 0a 23 20 24 49 64 3a  faster..#.# $Id:
0240: 20 6c 69 6b 65 32 2e 74 65 73 74 2c 76 20 31 2e   like2.test,v 1.
0250: 31 20 32 30 30 38 2f 30 35 2f 32 36 20 31 38 3a  1 2008/05/26 18:
0260: 33 33 3a 34 31 20 64 72 68 20 45 78 70 20 24 0a  33:41 drh Exp $.
0270: 0a 73 65 74 20 74 65 73 74 64 69 72 20 5b 66 69  .set testdir [fi
0280: 6c 65 20 64 69 72 6e 61 6d 65 20 24 61 72 67 76  le dirname $argv
0290: 30 5d 0a 73 6f 75 72 63 65 20 24 74 65 73 74 64  0].source $testd
02a0: 69 72 2f 74 65 73 74 65 72 2e 74 63 6c 0a 0a 64  ir/tester.tcl..d
02b0: 6f 5f 74 65 73 74 20 6c 69 6b 65 32 2d 31 2e 31  o_test like2-1.1
02c0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 7b 0a 20   {.  db eval {. 
02d0: 20 20 20 43 52 45 41 54 45 20 54 41 42 4c 45 20     CREATE TABLE 
02e0: 74 31 28 78 20 49 4e 54 2c 20 79 20 43 4f 4c 4c  t1(x INT, y COLL
02f0: 41 54 45 20 4e 4f 43 41 53 45 29 3b 0a 20 20 20  ATE NOCASE);.   
0300: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0310: 78 2c 79 29 20 56 41 4c 55 45 53 28 31 2c 43 41  x,y) VALUES(1,CA
0320: 53 54 28 78 27 30 31 27 20 41 53 20 54 45 58 54  ST(x'01' AS TEXT
0330: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0340: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0350: 45 53 28 32 2c 43 41 53 54 28 78 27 30 32 27 20  ES(2,CAST(x'02' 
0360: 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20 49  AS TEXT));.    I
0370: 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c  NSERT INTO t1(x,
0380: 79 29 20 56 41 4c 55 45 53 28 33 2c 43 41 53 54  y) VALUES(3,CAST
0390: 28 78 27 30 33 27 20 41 53 20 54 45 58 54 29 29  (x'03' AS TEXT))
03a0: 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54  ;.    INSERT INT
03b0: 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53  O t1(x,y) VALUES
03c0: 28 34 2c 43 41 53 54 28 78 27 30 34 27 20 41 53  (4,CAST(x'04' AS
03d0: 20 54 45 58 54 29 29 3b 0a 20 20 20 20 49 4e 53   TEXT));.    INS
03e0: 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29  ERT INTO t1(x,y)
03f0: 20 56 41 4c 55 45 53 28 35 2c 43 41 53 54 28 78   VALUES(5,CAST(x
0400: 27 30 35 27 20 41 53 20 54 45 58 54 29 29 3b 0a  '05' AS TEXT));.
0410: 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20      INSERT INTO 
0420: 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28 36  t1(x,y) VALUES(6
0430: 2c 43 41 53 54 28 78 27 30 36 27 20 41 53 20 54  ,CAST(x'06' AS T
0440: 45 58 54 29 29 3b 0a 20 20 20 20 49 4e 53 45 52  EXT));.    INSER
0450: 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56  T INTO t1(x,y) V
0460: 41 4c 55 45 53 28 37 2c 43 41 53 54 28 78 27 30  ALUES(7,CAST(x'0
0470: 37 27 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20  7' AS TEXT));.  
0480: 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31    INSERT INTO t1
0490: 28 78 2c 79 29 20 56 41 4c 55 45 53 28 38 2c 43  (x,y) VALUES(8,C
04a0: 41 53 54 28 78 27 30 38 27 20 41 53 20 54 45 58  AST(x'08' AS TEX
04b0: 54 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  T));.    INSERT 
04c0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
04d0: 55 45 53 28 39 2c 43 41 53 54 28 78 27 30 39 27  UES(9,CAST(x'09'
04e0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
04f0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0500: 2c 79 29 20 56 41 4c 55 45 53 28 31 30 2c 43 41  ,y) VALUES(10,CA
0510: 53 54 28 78 27 30 61 27 20 41 53 20 54 45 58 54  ST(x'0a' AS TEXT
0520: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0530: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0540: 45 53 28 31 31 2c 43 41 53 54 28 78 27 30 62 27  ES(11,CAST(x'0b'
0550: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0560: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0570: 2c 79 29 20 56 41 4c 55 45 53 28 31 32 2c 43 41  ,y) VALUES(12,CA
0580: 53 54 28 78 27 30 63 27 20 41 53 20 54 45 58 54  ST(x'0c' AS TEXT
0590: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
05a0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
05b0: 45 53 28 31 33 2c 43 41 53 54 28 78 27 30 64 27  ES(13,CAST(x'0d'
05c0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
05d0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
05e0: 2c 79 29 20 56 41 4c 55 45 53 28 31 34 2c 43 41  ,y) VALUES(14,CA
05f0: 53 54 28 78 27 30 65 27 20 41 53 20 54 45 58 54  ST(x'0e' AS TEXT
0600: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0610: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0620: 45 53 28 31 35 2c 43 41 53 54 28 78 27 30 66 27  ES(15,CAST(x'0f'
0630: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0640: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0650: 2c 79 29 20 56 41 4c 55 45 53 28 31 36 2c 43 41  ,y) VALUES(16,CA
0660: 53 54 28 78 27 31 30 27 20 41 53 20 54 45 58 54  ST(x'10' AS TEXT
0670: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0680: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0690: 45 53 28 31 37 2c 43 41 53 54 28 78 27 31 31 27  ES(17,CAST(x'11'
06a0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
06b0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
06c0: 2c 79 29 20 56 41 4c 55 45 53 28 31 38 2c 43 41  ,y) VALUES(18,CA
06d0: 53 54 28 78 27 31 32 27 20 41 53 20 54 45 58 54  ST(x'12' AS TEXT
06e0: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
06f0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0700: 45 53 28 31 39 2c 43 41 53 54 28 78 27 31 33 27  ES(19,CAST(x'13'
0710: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0720: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0730: 2c 79 29 20 56 41 4c 55 45 53 28 32 30 2c 43 41  ,y) VALUES(20,CA
0740: 53 54 28 78 27 31 34 27 20 41 53 20 54 45 58 54  ST(x'14' AS TEXT
0750: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0760: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0770: 45 53 28 32 31 2c 43 41 53 54 28 78 27 31 35 27  ES(21,CAST(x'15'
0780: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0790: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
07a0: 2c 79 29 20 56 41 4c 55 45 53 28 32 32 2c 43 41  ,y) VALUES(22,CA
07b0: 53 54 28 78 27 31 36 27 20 41 53 20 54 45 58 54  ST(x'16' AS TEXT
07c0: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
07d0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
07e0: 45 53 28 32 33 2c 43 41 53 54 28 78 27 31 37 27  ES(23,CAST(x'17'
07f0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0800: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0810: 2c 79 29 20 56 41 4c 55 45 53 28 32 34 2c 43 41  ,y) VALUES(24,CA
0820: 53 54 28 78 27 31 38 27 20 41 53 20 54 45 58 54  ST(x'18' AS TEXT
0830: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0840: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0850: 45 53 28 32 35 2c 43 41 53 54 28 78 27 31 39 27  ES(25,CAST(x'19'
0860: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0870: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0880: 2c 79 29 20 56 41 4c 55 45 53 28 32 36 2c 43 41  ,y) VALUES(26,CA
0890: 53 54 28 78 27 31 61 27 20 41 53 20 54 45 58 54  ST(x'1a' AS TEXT
08a0: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
08b0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
08c0: 45 53 28 32 37 2c 43 41 53 54 28 78 27 31 62 27  ES(27,CAST(x'1b'
08d0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
08e0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
08f0: 2c 79 29 20 56 41 4c 55 45 53 28 32 38 2c 43 41  ,y) VALUES(28,CA
0900: 53 54 28 78 27 31 63 27 20 41 53 20 54 45 58 54  ST(x'1c' AS TEXT
0910: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0920: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0930: 45 53 28 32 39 2c 43 41 53 54 28 78 27 31 64 27  ES(29,CAST(x'1d'
0940: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
0950: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0960: 2c 79 29 20 56 41 4c 55 45 53 28 33 30 2c 43 41  ,y) VALUES(30,CA
0970: 53 54 28 78 27 31 65 27 20 41 53 20 54 45 58 54  ST(x'1e' AS TEXT
0980: 29 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ));.    INSERT I
0990: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
09a0: 45 53 28 33 31 2c 43 41 53 54 28 78 27 31 66 27  ES(31,CAST(x'1f'
09b0: 20 41 53 20 54 45 58 54 29 29 3b 0a 20 20 20 20   AS TEXT));.    
09c0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
09d0: 2c 79 29 20 56 41 4c 55 45 53 28 33 32 2c 27 20  ,y) VALUES(32,' 
09e0: 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ');.    INSERT I
09f0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0a00: 45 53 28 33 33 2c 27 21 27 29 3b 0a 20 20 20 20  ES(33,'!');.    
0a10: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0a20: 2c 79 29 20 56 41 4c 55 45 53 28 33 34 2c 27 22  ,y) VALUES(34,'"
0a30: 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ');.    INSERT I
0a40: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0a50: 45 53 28 33 35 2c 27 23 27 29 3b 0a 20 20 20 20  ES(35,'#');.    
0a60: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0a70: 2c 79 29 20 56 41 4c 55 45 53 28 33 36 2c 27 24  ,y) VALUES(36,'$
0a80: 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ');.    INSERT I
0a90: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0aa0: 45 53 28 33 37 2c 27 25 27 29 3b 0a 20 20 20 20  ES(37,'%');.    
0ab0: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
0ac0: 2c 79 29 20 56 41 4c 55 45 53 28 33 38 2c 27 26  ,y) VALUES(38,'&
0ad0: 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ');.    INSERT I
0ae0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
0af0: 45 53 28 33 39 2c 27 27 27 27 29 3b 0a 20 20 20  ES(39,'''');.   
0b00: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0b10: 78 2c 79 29 20 56 41 4c 55 45 53 28 34 30 2c 27  x,y) VALUES(40,'
0b20: 28 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  (');.    INSERT 
0b30: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0b40: 55 45 53 28 34 31 2c 27 29 27 29 3b 0a 20 20 20  UES(41,')');.   
0b50: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0b60: 78 2c 79 29 20 56 41 4c 55 45 53 28 34 32 2c 27  x,y) VALUES(42,'
0b70: 2a 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  *');.    INSERT 
0b80: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0b90: 55 45 53 28 34 33 2c 27 2b 27 29 3b 0a 20 20 20  UES(43,'+');.   
0ba0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0bb0: 78 2c 79 29 20 56 41 4c 55 45 53 28 34 34 2c 27  x,y) VALUES(44,'
0bc0: 2c 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  ,');.    INSERT 
0bd0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0be0: 55 45 53 28 34 35 2c 27 2d 27 29 3b 0a 20 20 20  UES(45,'-');.   
0bf0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0c00: 78 2c 79 29 20 56 41 4c 55 45 53 28 34 36 2c 27  x,y) VALUES(46,'
0c10: 2e 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  .');.    INSERT 
0c20: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0c30: 55 45 53 28 34 37 2c 27 2f 27 29 3b 0a 20 20 20  UES(47,'/');.   
0c40: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0c50: 78 2c 79 29 20 56 41 4c 55 45 53 28 34 38 2c 27  x,y) VALUES(48,'
0c60: 30 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  0');.    INSERT 
0c70: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0c80: 55 45 53 28 34 39 2c 27 31 27 29 3b 0a 20 20 20  UES(49,'1');.   
0c90: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0ca0: 78 2c 79 29 20 56 41 4c 55 45 53 28 35 30 2c 27  x,y) VALUES(50,'
0cb0: 32 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  2');.    INSERT 
0cc0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0cd0: 55 45 53 28 35 31 2c 27 33 27 29 3b 0a 20 20 20  UES(51,'3');.   
0ce0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0cf0: 78 2c 79 29 20 56 41 4c 55 45 53 28 35 32 2c 27  x,y) VALUES(52,'
0d00: 34 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  4');.    INSERT 
0d10: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0d20: 55 45 53 28 35 33 2c 27 35 27 29 3b 0a 20 20 20  UES(53,'5');.   
0d30: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0d40: 78 2c 79 29 20 56 41 4c 55 45 53 28 35 34 2c 27  x,y) VALUES(54,'
0d50: 36 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  6');.    INSERT 
0d60: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0d70: 55 45 53 28 35 35 2c 27 37 27 29 3b 0a 20 20 20  UES(55,'7');.   
0d80: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0d90: 78 2c 79 29 20 56 41 4c 55 45 53 28 35 36 2c 27  x,y) VALUES(56,'
0da0: 38 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  8');.    INSERT 
0db0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0dc0: 55 45 53 28 35 37 2c 27 39 27 29 3b 0a 20 20 20  UES(57,'9');.   
0dd0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0de0: 78 2c 79 29 20 56 41 4c 55 45 53 28 35 38 2c 27  x,y) VALUES(58,'
0df0: 3a 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  :');.    INSERT 
0e00: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0e10: 55 45 53 28 35 39 2c 27 3b 27 29 3b 0a 20 20 20  UES(59,';');.   
0e20: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0e30: 78 2c 79 29 20 56 41 4c 55 45 53 28 36 30 2c 27  x,y) VALUES(60,'
0e40: 3c 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  <');.    INSERT 
0e50: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0e60: 55 45 53 28 36 31 2c 27 3d 27 29 3b 0a 20 20 20  UES(61,'=');.   
0e70: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0e80: 78 2c 79 29 20 56 41 4c 55 45 53 28 36 32 2c 27  x,y) VALUES(62,'
0e90: 3e 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  >');.    INSERT 
0ea0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0eb0: 55 45 53 28 36 33 2c 27 3f 27 29 3b 0a 20 20 20  UES(63,'?');.   
0ec0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0ed0: 78 2c 79 29 20 56 41 4c 55 45 53 28 36 34 2c 27  x,y) VALUES(64,'
0ee0: 40 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  @');.    INSERT 
0ef0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0f00: 55 45 53 28 36 35 2c 27 41 27 29 3b 0a 20 20 20  UES(65,'A');.   
0f10: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0f20: 78 2c 79 29 20 56 41 4c 55 45 53 28 36 36 2c 27  x,y) VALUES(66,'
0f30: 42 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  B');.    INSERT 
0f40: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0f50: 55 45 53 28 36 37 2c 27 43 27 29 3b 0a 20 20 20  UES(67,'C');.   
0f60: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0f70: 78 2c 79 29 20 56 41 4c 55 45 53 28 36 38 2c 27  x,y) VALUES(68,'
0f80: 44 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  D');.    INSERT 
0f90: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0fa0: 55 45 53 28 36 39 2c 27 45 27 29 3b 0a 20 20 20  UES(69,'E');.   
0fb0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
0fc0: 78 2c 79 29 20 56 41 4c 55 45 53 28 37 30 2c 27  x,y) VALUES(70,'
0fd0: 46 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  F');.    INSERT 
0fe0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
0ff0: 55 45 53 28 37 31 2c 27 47 27 29 3b 0a 20 20 20  UES(71,'G');.   
1000: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1010: 78 2c 79 29 20 56 41 4c 55 45 53 28 37 32 2c 27  x,y) VALUES(72,'
1020: 48 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  H');.    INSERT 
1030: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1040: 55 45 53 28 37 33 2c 27 49 27 29 3b 0a 20 20 20  UES(73,'I');.   
1050: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1060: 78 2c 79 29 20 56 41 4c 55 45 53 28 37 34 2c 27  x,y) VALUES(74,'
1070: 4a 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  J');.    INSERT 
1080: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1090: 55 45 53 28 37 35 2c 27 4b 27 29 3b 0a 20 20 20  UES(75,'K');.   
10a0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
10b0: 78 2c 79 29 20 56 41 4c 55 45 53 28 37 36 2c 27  x,y) VALUES(76,'
10c0: 4c 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  L');.    INSERT 
10d0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
10e0: 55 45 53 28 37 37 2c 27 4d 27 29 3b 0a 20 20 20  UES(77,'M');.   
10f0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1100: 78 2c 79 29 20 56 41 4c 55 45 53 28 37 38 2c 27  x,y) VALUES(78,'
1110: 4e 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  N');.    INSERT 
1120: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1130: 55 45 53 28 37 39 2c 27 4f 27 29 3b 0a 20 20 20  UES(79,'O');.   
1140: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1150: 78 2c 79 29 20 56 41 4c 55 45 53 28 38 30 2c 27  x,y) VALUES(80,'
1160: 50 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  P');.    INSERT 
1170: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1180: 55 45 53 28 38 31 2c 27 51 27 29 3b 0a 20 20 20  UES(81,'Q');.   
1190: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
11a0: 78 2c 79 29 20 56 41 4c 55 45 53 28 38 32 2c 27  x,y) VALUES(82,'
11b0: 52 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  R');.    INSERT 
11c0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
11d0: 55 45 53 28 38 33 2c 27 53 27 29 3b 0a 20 20 20  UES(83,'S');.   
11e0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
11f0: 78 2c 79 29 20 56 41 4c 55 45 53 28 38 34 2c 27  x,y) VALUES(84,'
1200: 54 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  T');.    INSERT 
1210: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1220: 55 45 53 28 38 35 2c 27 55 27 29 3b 0a 20 20 20  UES(85,'U');.   
1230: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1240: 78 2c 79 29 20 56 41 4c 55 45 53 28 38 36 2c 27  x,y) VALUES(86,'
1250: 56 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  V');.    INSERT 
1260: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1270: 55 45 53 28 38 37 2c 27 57 27 29 3b 0a 20 20 20  UES(87,'W');.   
1280: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1290: 78 2c 79 29 20 56 41 4c 55 45 53 28 38 38 2c 27  x,y) VALUES(88,'
12a0: 58 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  X');.    INSERT 
12b0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
12c0: 55 45 53 28 38 39 2c 27 59 27 29 3b 0a 20 20 20  UES(89,'Y');.   
12d0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
12e0: 78 2c 79 29 20 56 41 4c 55 45 53 28 39 30 2c 27  x,y) VALUES(90,'
12f0: 5a 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  Z');.    INSERT 
1300: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1310: 55 45 53 28 39 31 2c 27 5b 27 29 3b 0a 20 20 20  UES(91,'[');.   
1320: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1330: 78 2c 79 29 20 56 41 4c 55 45 53 28 39 32 2c 27  x,y) VALUES(92,'
1340: 5c 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  \');.    INSERT 
1350: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1360: 55 45 53 28 39 33 2c 27 5d 27 29 3b 0a 20 20 20  UES(93,']');.   
1370: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1380: 78 2c 79 29 20 56 41 4c 55 45 53 28 39 34 2c 27  x,y) VALUES(94,'
1390: 5e 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  ^');.    INSERT 
13a0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
13b0: 55 45 53 28 39 35 2c 27 5f 27 29 3b 0a 20 20 20  UES(95,'_');.   
13c0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
13d0: 78 2c 79 29 20 56 41 4c 55 45 53 28 39 36 2c 27  x,y) VALUES(96,'
13e0: 60 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  `');.    INSERT 
13f0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1400: 55 45 53 28 39 37 2c 27 61 27 29 3b 0a 20 20 20  UES(97,'a');.   
1410: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1420: 78 2c 79 29 20 56 41 4c 55 45 53 28 39 38 2c 27  x,y) VALUES(98,'
1430: 62 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  b');.    INSERT 
1440: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1450: 55 45 53 28 39 39 2c 27 63 27 29 3b 0a 20 20 20  UES(99,'c');.   
1460: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1470: 78 2c 79 29 20 56 41 4c 55 45 53 28 31 30 30 2c  x,y) VALUES(100,
1480: 27 64 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54  'd');.    INSERT
1490: 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41   INTO t1(x,y) VA
14a0: 4c 55 45 53 28 31 30 31 2c 27 65 27 29 3b 0a 20  LUES(101,'e');. 
14b0: 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74     INSERT INTO t
14c0: 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31 30  1(x,y) VALUES(10
14d0: 32 2c 27 66 27 29 3b 0a 20 20 20 20 49 4e 53 45  2,'f');.    INSE
14e0: 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20  RT INTO t1(x,y) 
14f0: 56 41 4c 55 45 53 28 31 30 33 2c 27 67 27 29 3b  VALUES(103,'g');
1500: 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f  .    INSERT INTO
1510: 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28   t1(x,y) VALUES(
1520: 31 30 34 2c 27 68 27 29 3b 0a 20 20 20 20 49 4e  104,'h');.    IN
1530: 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79  SERT INTO t1(x,y
1540: 29 20 56 41 4c 55 45 53 28 31 30 35 2c 27 69 27  ) VALUES(105,'i'
1550: 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e  );.    INSERT IN
1560: 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45  TO t1(x,y) VALUE
1570: 53 28 31 30 36 2c 27 6a 27 29 3b 0a 20 20 20 20  S(106,'j');.    
1580: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
1590: 2c 79 29 20 56 41 4c 55 45 53 28 31 30 37 2c 27  ,y) VALUES(107,'
15a0: 6b 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  k');.    INSERT 
15b0: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
15c0: 55 45 53 28 31 30 38 2c 27 6c 27 29 3b 0a 20 20  UES(108,'l');.  
15d0: 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31    INSERT INTO t1
15e0: 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31 30 39  (x,y) VALUES(109
15f0: 2c 27 6d 27 29 3b 0a 20 20 20 20 49 4e 53 45 52  ,'m');.    INSER
1600: 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56  T INTO t1(x,y) V
1610: 41 4c 55 45 53 28 31 31 30 2c 27 6e 27 29 3b 0a  ALUES(110,'n');.
1620: 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20      INSERT INTO 
1630: 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31  t1(x,y) VALUES(1
1640: 31 31 2c 27 6f 27 29 3b 0a 20 20 20 20 49 4e 53  11,'o');.    INS
1650: 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29  ERT INTO t1(x,y)
1660: 20 56 41 4c 55 45 53 28 31 31 32 2c 27 70 27 29   VALUES(112,'p')
1670: 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54  ;.    INSERT INT
1680: 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53  O t1(x,y) VALUES
1690: 28 31 31 33 2c 27 71 27 29 3b 0a 20 20 20 20 49  (113,'q');.    I
16a0: 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c  NSERT INTO t1(x,
16b0: 79 29 20 56 41 4c 55 45 53 28 31 31 34 2c 27 72  y) VALUES(114,'r
16c0: 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49  ');.    INSERT I
16d0: 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55  NTO t1(x,y) VALU
16e0: 45 53 28 31 31 35 2c 27 73 27 29 3b 0a 20 20 20  ES(115,'s');.   
16f0: 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28   INSERT INTO t1(
1700: 78 2c 79 29 20 56 41 4c 55 45 53 28 31 31 36 2c  x,y) VALUES(116,
1710: 27 74 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54  't');.    INSERT
1720: 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41   INTO t1(x,y) VA
1730: 4c 55 45 53 28 31 31 37 2c 27 75 27 29 3b 0a 20  LUES(117,'u');. 
1740: 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74     INSERT INTO t
1750: 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31 31  1(x,y) VALUES(11
1760: 38 2c 27 76 27 29 3b 0a 20 20 20 20 49 4e 53 45  8,'v');.    INSE
1770: 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20  RT INTO t1(x,y) 
1780: 56 41 4c 55 45 53 28 31 31 39 2c 27 77 27 29 3b  VALUES(119,'w');
1790: 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f  .    INSERT INTO
17a0: 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28   t1(x,y) VALUES(
17b0: 31 32 30 2c 27 78 27 29 3b 0a 20 20 20 20 49 4e  120,'x');.    IN
17c0: 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78 2c 79  SERT INTO t1(x,y
17d0: 29 20 56 41 4c 55 45 53 28 31 32 31 2c 27 79 27  ) VALUES(121,'y'
17e0: 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20 49 4e  );.    INSERT IN
17f0: 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c 55 45  TO t1(x,y) VALUE
1800: 53 28 31 32 32 2c 27 7a 27 29 3b 0a 20 20 20 20  S(122,'z');.    
1810: 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31 28 78  INSERT INTO t1(x
1820: 2c 79 29 20 56 41 4c 55 45 53 28 31 32 33 2c 27  ,y) VALUES(123,'
1830: 7b 27 29 3b 0a 20 20 20 20 49 4e 53 45 52 54 20  {');.    INSERT 
1840: 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56 41 4c  INTO t1(x,y) VAL
1850: 55 45 53 28 31 32 34 2c 27 7c 27 29 3b 0a 20 20  UES(124,'|');.  
1860: 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 74 31    INSERT INTO t1
1870: 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31 32 35  (x,y) VALUES(125
1880: 2c 27 7d 27 29 3b 0a 20 20 20 20 49 4e 53 45 52  ,'}');.    INSER
1890: 54 20 49 4e 54 4f 20 74 31 28 78 2c 79 29 20 56  T INTO t1(x,y) V
18a0: 41 4c 55 45 53 28 31 32 36 2c 27 7e 27 29 3b 0a  ALUES(126,'~');.
18b0: 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20      INSERT INTO 
18c0: 74 31 28 78 2c 79 29 20 56 41 4c 55 45 53 28 31  t1(x,y) VALUES(1
18d0: 32 37 2c 43 41 53 54 28 78 27 37 66 27 20 41 53  27,CAST(x'7f' AS
18e0: 20 54 45 58 54 29 29 3b 0a 20 20 20 20 53 45 4c   TEXT));.    SEL
18f0: 45 43 54 20 63 6f 75 6e 74 28 2a 29 20 46 52 4f  ECT count(*) FRO
1900: 4d 20 74 31 3b 0a 20 20 7d 0a 7d 20 7b 31 32 37  M t1;.  }.} {127
1910: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 32 2d  }.do_test like2-
1920: 31 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  1.2 {.  db eval 
1930: 7b 0a 20 20 20 20 43 52 45 41 54 45 20 54 41 42  {.    CREATE TAB
1940: 4c 45 20 74 32 28 78 20 49 4e 54 2c 20 79 20 43  LE t2(x INT, y C
1950: 4f 4c 4c 41 54 45 20 4e 4f 43 41 53 45 29 3b 0a  OLLATE NOCASE);.
1960: 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20      INSERT INTO 
1970: 74 32 20 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d  t2 SELECT * FROM
1980: 20 74 31 3b 0a 20 20 20 20 43 52 45 41 54 45 20   t1;.    CREATE 
1990: 49 4e 44 45 58 20 69 32 20 4f 4e 20 74 32 28 79  INDEX i2 ON t2(y
19a0: 29 3b 0a 20 20 20 20 53 45 4c 45 43 54 20 63 6f  );.    SELECT co
19b0: 75 6e 74 28 2a 29 20 46 52 4f 4d 20 74 32 3b 0a  unt(*) FROM t2;.
19c0: 20 20 7d 0a 7d 20 7b 31 32 37 7d 0a 64 6f 5f 74    }.} {127}.do_t
19d0: 65 73 74 20 6c 69 6b 65 32 2d 31 2e 33 20 7b 0a  est like2-1.3 {.
19e0: 20 20 64 62 20 65 76 61 6c 20 7b 0a 20 20 20 20    db eval {.    
19f0: 43 52 45 41 54 45 20 54 41 42 4c 45 20 74 33 28  CREATE TABLE t3(
1a00: 78 20 49 4e 54 2c 20 79 20 43 4f 4c 4c 41 54 45  x INT, y COLLATE
1a10: 20 4e 4f 43 41 53 45 29 3b 0a 20 20 20 20 49 4e   NOCASE);.    IN
1a20: 53 45 52 54 20 49 4e 54 4f 20 74 33 20 53 45 4c  SERT INTO t3 SEL
1a30: 45 43 54 20 78 2c 20 27 61 62 63 27 20 7c 7c 20  ECT x, 'abc' || 
1a40: 79 20 7c 7c 20 27 78 79 7a 27 20 46 52 4f 4d 20  y || 'xyz' FROM 
1a50: 74 31 3b 0a 20 20 20 20 43 52 45 41 54 45 20 49  t1;.    CREATE I
1a60: 4e 44 45 58 20 69 33 20 4f 4e 20 74 33 28 79 29  NDEX i3 ON t3(y)
1a70: 3b 0a 20 20 20 20 53 45 4c 45 43 54 20 63 6f 75  ;.    SELECT cou
1a80: 6e 74 28 2a 29 20 46 52 4f 4d 20 74 32 3b 0a 20  nt(*) FROM t2;. 
1a90: 20 7d 0a 7d 20 7b 31 32 37 7d 0a 64 6f 5f 74 65   }.} {127}.do_te
1aa0: 73 74 20 6c 69 6b 65 2d 32 2e 33 32 2e 31 20 7b  st like-2.32.1 {
1ab0: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
1ac0: 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45  CT x FROM t1 WHE
1ad0: 52 45 20 79 20 4c 49 4b 45 20 27 20 25 27 22 0a  RE y LIKE ' %'".
1ae0: 7d 20 7b 33 32 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {32}.do_test l
1af0: 69 6b 65 2d 32 2e 33 32 2e 32 20 7b 0a 20 20 64  ike-2.32.2 {.  d
1b00: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
1b10: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
1b20: 20 4c 49 4b 45 20 27 20 25 27 22 0a 7d 20 7b 33   LIKE ' %'".} {3
1b30: 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  2}.do_test like-
1b40: 32 2e 33 32 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.32.3 {.  db ev
1b50: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
1b60: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
1b70: 45 20 27 61 62 63 20 25 27 22 0a 7d 20 7b 33 32  E 'abc %'".} {32
1b80: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
1b90: 2e 33 33 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  .33.1 {.  db eva
1ba0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
1bb0: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
1bc0: 20 27 21 25 27 22 0a 7d 20 7b 33 33 7d 0a 64 6f   '!%'".} {33}.do
1bd0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 33 33 2e  _test like-2.33.
1be0: 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  2 {.  db eval "S
1bf0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20  ELECT x FROM t2 
1c00: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 21 25  WHERE y LIKE '!%
1c10: 27 22 0a 7d 20 7b 33 33 7d 0a 64 6f 5f 74 65 73  '".} {33}.do_tes
1c20: 74 20 6c 69 6b 65 2d 32 2e 33 33 2e 33 20 7b 0a  t like-2.33.3 {.
1c30: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
1c40: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
1c50: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 21 25 27  E y LIKE 'abc!%'
1c60: 22 0a 7d 20 7b 33 33 7d 0a 64 6f 5f 74 65 73 74  ".} {33}.do_test
1c70: 20 6c 69 6b 65 2d 32 2e 33 34 2e 31 20 7b 0a 20   like-2.34.1 {. 
1c80: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
1c90: 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45   x FROM t1 WHERE
1ca0: 20 79 20 4c 49 4b 45 20 27 5c 22 25 27 22 0a 7d   y LIKE '\"%'".}
1cb0: 20 7b 33 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {34}.do_test li
1cc0: 6b 65 2d 32 2e 33 34 2e 32 20 7b 0a 20 20 64 62  ke-2.34.2 {.  db
1cd0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
1ce0: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
1cf0: 4c 49 4b 45 20 27 5c 22 25 27 22 0a 7d 20 7b 33  LIKE '\"%'".} {3
1d00: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
1d10: 32 2e 33 34 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.34.3 {.  db ev
1d20: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
1d30: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
1d40: 45 20 27 61 62 63 5c 22 25 27 22 0a 7d 20 7b 33  E 'abc\"%'".} {3
1d50: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
1d60: 32 2e 33 35 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.35.1 {.  db ev
1d70: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
1d80: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
1d90: 45 20 27 23 25 27 22 0a 7d 20 7b 33 35 7d 0a 64  E '#%'".} {35}.d
1da0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 33 35  o_test like-2.35
1db0: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
1dc0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
1dd0: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 23   WHERE y LIKE '#
1de0: 25 27 22 0a 7d 20 7b 33 35 7d 0a 64 6f 5f 74 65  %'".} {35}.do_te
1df0: 73 74 20 6c 69 6b 65 2d 32 2e 33 35 2e 33 20 7b  st like-2.35.3 {
1e00: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
1e10: 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45  CT x FROM t3 WHE
1e20: 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 23 25  RE y LIKE 'abc#%
1e30: 27 22 0a 7d 20 7b 33 35 7d 0a 64 6f 5f 74 65 73  '".} {35}.do_tes
1e40: 74 20 6c 69 6b 65 2d 32 2e 33 36 2e 31 20 7b 0a  t like-2.36.1 {.
1e50: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
1e60: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
1e70: 45 20 79 20 4c 49 4b 45 20 27 5c 24 25 27 22 0a  E y LIKE '\$%'".
1e80: 7d 20 7b 33 36 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {36}.do_test l
1e90: 69 6b 65 2d 32 2e 33 36 2e 32 20 7b 0a 20 20 64  ike-2.36.2 {.  d
1ea0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
1eb0: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
1ec0: 20 4c 49 4b 45 20 27 5c 24 25 27 22 0a 7d 20 7b   LIKE '\$%'".} {
1ed0: 33 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  36}.do_test like
1ee0: 2d 32 2e 33 36 2e 33 20 7b 0a 20 20 64 62 20 65  -2.36.3 {.  db e
1ef0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
1f00: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
1f10: 4b 45 20 27 61 62 63 5c 24 25 27 22 0a 7d 20 7b  KE 'abc\$%'".} {
1f20: 33 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  36}.do_test like
1f30: 2d 32 2e 33 38 2e 31 20 7b 0a 20 20 64 62 20 65  -2.38.1 {.  db e
1f40: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
1f50: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
1f60: 4b 45 20 27 26 25 27 22 0a 7d 20 7b 33 38 7d 0a  KE '&%'".} {38}.
1f70: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 33  do_test like-2.3
1f80: 38 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  8.2 {.  db eval 
1f90: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
1fa0: 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  2 WHERE y LIKE '
1fb0: 26 25 27 22 0a 7d 20 7b 33 38 7d 0a 64 6f 5f 74  &%'".} {38}.do_t
1fc0: 65 73 74 20 6c 69 6b 65 2d 32 2e 33 38 2e 33 20  est like-2.38.3 
1fd0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
1fe0: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
1ff0: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 26  ERE y LIKE 'abc&
2000: 25 27 22 0a 7d 20 7b 33 38 7d 0a 64 6f 5f 74 65  %'".} {38}.do_te
2010: 73 74 20 6c 69 6b 65 2d 32 2e 33 39 2e 31 20 7b  st like-2.39.1 {
2020: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
2030: 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45  CT x FROM t1 WHE
2040: 52 45 20 79 20 4c 49 4b 45 20 27 27 27 25 27 22  RE y LIKE '''%'"
2050: 0a 7d 20 7b 33 39 7d 0a 64 6f 5f 74 65 73 74 20  .} {39}.do_test 
2060: 6c 69 6b 65 2d 32 2e 33 39 2e 32 20 7b 0a 20 20  like-2.39.2 {.  
2070: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
2080: 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20  x FROM t2 WHERE 
2090: 79 20 4c 49 4b 45 20 27 27 27 25 27 22 0a 7d 20  y LIKE '''%'".} 
20a0: 7b 33 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {39}.do_test lik
20b0: 65 2d 32 2e 33 39 2e 33 20 7b 0a 20 20 64 62 20  e-2.39.3 {.  db 
20c0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
20d0: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
20e0: 49 4b 45 20 27 61 62 63 27 27 25 27 22 0a 7d 20  IKE 'abc''%'".} 
20f0: 7b 33 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {39}.do_test lik
2100: 65 2d 32 2e 34 30 2e 31 20 7b 0a 20 20 64 62 20  e-2.40.1 {.  db 
2110: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
2120: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
2130: 49 4b 45 20 27 28 25 27 22 0a 7d 20 7b 34 30 7d  IKE '(%'".} {40}
2140: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
2150: 34 30 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  40.2 {.  db eval
2160: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
2170: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
2180: 27 28 25 27 22 0a 7d 20 7b 34 30 7d 0a 64 6f 5f  '(%'".} {40}.do_
2190: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 30 2e 33  test like-2.40.3
21a0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
21b0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57  LECT x FROM t3 W
21c0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63  HERE y LIKE 'abc
21d0: 28 25 27 22 0a 7d 20 7b 34 30 7d 0a 64 6f 5f 74  (%'".} {40}.do_t
21e0: 65 73 74 20 6c 69 6b 65 2d 32 2e 34 31 2e 31 20  est like-2.41.1 
21f0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
2200: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
2210: 45 52 45 20 79 20 4c 49 4b 45 20 27 29 25 27 22  ERE y LIKE ')%'"
2220: 0a 7d 20 7b 34 31 7d 0a 64 6f 5f 74 65 73 74 20  .} {41}.do_test 
2230: 6c 69 6b 65 2d 32 2e 34 31 2e 32 20 7b 0a 20 20  like-2.41.2 {.  
2240: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
2250: 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20  x FROM t2 WHERE 
2260: 79 20 4c 49 4b 45 20 27 29 25 27 22 0a 7d 20 7b  y LIKE ')%'".} {
2270: 34 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  41}.do_test like
2280: 2d 32 2e 34 31 2e 33 20 7b 0a 20 20 64 62 20 65  -2.41.3 {.  db e
2290: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
22a0: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
22b0: 4b 45 20 27 61 62 63 29 25 27 22 0a 7d 20 7b 34  KE 'abc)%'".} {4
22c0: 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  1}.do_test like-
22d0: 32 2e 34 32 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.42.1 {.  db ev
22e0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
22f0: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
2300: 45 20 27 2a 25 27 22 0a 7d 20 7b 34 32 7d 0a 64  E '*%'".} {42}.d
2310: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 32  o_test like-2.42
2320: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
2330: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
2340: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 2a   WHERE y LIKE '*
2350: 25 27 22 0a 7d 20 7b 34 32 7d 0a 64 6f 5f 74 65  %'".} {42}.do_te
2360: 73 74 20 6c 69 6b 65 2d 32 2e 34 32 2e 33 20 7b  st like-2.42.3 {
2370: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
2380: 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45  CT x FROM t3 WHE
2390: 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 2a 25  RE y LIKE 'abc*%
23a0: 27 22 0a 7d 20 7b 34 32 7d 0a 64 6f 5f 74 65 73  '".} {42}.do_tes
23b0: 74 20 6c 69 6b 65 2d 32 2e 34 33 2e 31 20 7b 0a  t like-2.43.1 {.
23c0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
23d0: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
23e0: 45 20 79 20 4c 49 4b 45 20 27 2b 25 27 22 0a 7d  E y LIKE '+%'".}
23f0: 20 7b 34 33 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {43}.do_test li
2400: 6b 65 2d 32 2e 34 33 2e 32 20 7b 0a 20 20 64 62  ke-2.43.2 {.  db
2410: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
2420: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
2430: 4c 49 4b 45 20 27 2b 25 27 22 0a 7d 20 7b 34 33  LIKE '+%'".} {43
2440: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
2450: 2e 34 33 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .43.3 {.  db eva
2460: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
2470: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
2480: 20 27 61 62 63 2b 25 27 22 0a 7d 20 7b 34 33 7d   'abc+%'".} {43}
2490: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
24a0: 34 34 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c  44.1 {.  db eval
24b0: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
24c0: 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t1 WHERE y LIKE 
24d0: 27 2c 25 27 22 0a 7d 20 7b 34 34 7d 0a 64 6f 5f  ',%'".} {44}.do_
24e0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 34 2e 32  test like-2.44.2
24f0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
2500: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
2510: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 2c 25 27  HERE y LIKE ',%'
2520: 22 0a 7d 20 7b 34 34 7d 0a 64 6f 5f 74 65 73 74  ".} {44}.do_test
2530: 20 6c 69 6b 65 2d 32 2e 34 34 2e 33 20 7b 0a 20   like-2.44.3 {. 
2540: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
2550: 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45   x FROM t3 WHERE
2560: 20 79 20 4c 49 4b 45 20 27 61 62 63 2c 25 27 22   y LIKE 'abc,%'"
2570: 0a 7d 20 7b 34 34 7d 0a 64 6f 5f 74 65 73 74 20  .} {44}.do_test 
2580: 6c 69 6b 65 2d 32 2e 34 35 2e 31 20 7b 0a 20 20  like-2.45.1 {.  
2590: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
25a0: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
25b0: 79 20 4c 49 4b 45 20 27 2d 25 27 22 0a 7d 20 7b  y LIKE '-%'".} {
25c0: 34 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  45}.do_test like
25d0: 2d 32 2e 34 35 2e 32 20 7b 0a 20 20 64 62 20 65  -2.45.2 {.  db e
25e0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
25f0: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
2600: 4b 45 20 27 2d 25 27 22 0a 7d 20 7b 34 35 7d 0a  KE '-%'".} {45}.
2610: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34  do_test like-2.4
2620: 35 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  5.3 {.  db eval 
2630: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
2640: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
2650: 61 62 63 2d 25 27 22 0a 7d 20 7b 34 35 7d 0a 64  abc-%'".} {45}.d
2660: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 36  o_test like-2.46
2670: 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .1 {.  db eval "
2680: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31  SELECT x FROM t1
2690: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 2e   WHERE y LIKE '.
26a0: 25 27 22 0a 7d 20 7b 34 36 7d 0a 64 6f 5f 74 65  %'".} {46}.do_te
26b0: 73 74 20 6c 69 6b 65 2d 32 2e 34 36 2e 32 20 7b  st like-2.46.2 {
26c0: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
26d0: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
26e0: 52 45 20 79 20 4c 49 4b 45 20 27 2e 25 27 22 0a  RE y LIKE '.%'".
26f0: 7d 20 7b 34 36 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {46}.do_test l
2700: 69 6b 65 2d 32 2e 34 36 2e 33 20 7b 0a 20 20 64  ike-2.46.3 {.  d
2710: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
2720: 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79   FROM t3 WHERE y
2730: 20 4c 49 4b 45 20 27 61 62 63 2e 25 27 22 0a 7d   LIKE 'abc.%'".}
2740: 20 7b 34 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {46}.do_test li
2750: 6b 65 2d 32 2e 34 37 2e 31 20 7b 0a 20 20 64 62  ke-2.47.1 {.  db
2760: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
2770: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
2780: 4c 49 4b 45 20 27 2f 25 27 22 0a 7d 20 7b 34 37  LIKE '/%'".} {47
2790: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
27a0: 2e 34 37 2e 32 20 7b 0a 20 20 64 62 20 65 76 61  .47.2 {.  db eva
27b0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
27c0: 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t2 WHERE y LIKE
27d0: 20 27 2f 25 27 22 0a 7d 20 7b 34 37 7d 0a 64 6f   '/%'".} {47}.do
27e0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 37 2e  _test like-2.47.
27f0: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
2800: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
2810: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
2820: 63 2f 25 27 22 0a 7d 20 7b 34 37 7d 0a 64 6f 5f  c/%'".} {47}.do_
2830: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34 38 2e 31  test like-2.48.1
2840: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
2850: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57  LECT x FROM t1 W
2860: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 30 25 27  HERE y LIKE '0%'
2870: 22 0a 7d 20 7b 34 38 7d 0a 64 6f 5f 74 65 73 74  ".} {48}.do_test
2880: 20 6c 69 6b 65 2d 32 2e 34 38 2e 32 20 7b 0a 20   like-2.48.2 {. 
2890: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
28a0: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
28b0: 20 79 20 4c 49 4b 45 20 27 30 25 27 22 0a 7d 20   y LIKE '0%'".} 
28c0: 7b 34 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {48}.do_test lik
28d0: 65 2d 32 2e 34 38 2e 33 20 7b 0a 20 20 64 62 20  e-2.48.3 {.  db 
28e0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
28f0: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
2900: 49 4b 45 20 27 61 62 63 30 25 27 22 0a 7d 20 7b  IKE 'abc0%'".} {
2910: 34 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  48}.do_test like
2920: 2d 32 2e 34 39 2e 31 20 7b 0a 20 20 64 62 20 65  -2.49.1 {.  db e
2930: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
2940: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
2950: 4b 45 20 27 31 25 27 22 0a 7d 20 7b 34 39 7d 0a  KE '1%'".} {49}.
2960: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 34  do_test like-2.4
2970: 39 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  9.2 {.  db eval 
2980: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
2990: 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  2 WHERE y LIKE '
29a0: 31 25 27 22 0a 7d 20 7b 34 39 7d 0a 64 6f 5f 74  1%'".} {49}.do_t
29b0: 65 73 74 20 6c 69 6b 65 2d 32 2e 34 39 2e 33 20  est like-2.49.3 
29c0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
29d0: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
29e0: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 31  ERE y LIKE 'abc1
29f0: 25 27 22 0a 7d 20 7b 34 39 7d 0a 64 6f 5f 74 65  %'".} {49}.do_te
2a00: 73 74 20 6c 69 6b 65 2d 32 2e 35 30 2e 31 20 7b  st like-2.50.1 {
2a10: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
2a20: 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45  CT x FROM t1 WHE
2a30: 52 45 20 79 20 4c 49 4b 45 20 27 32 25 27 22 0a  RE y LIKE '2%'".
2a40: 7d 20 7b 35 30 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {50}.do_test l
2a50: 69 6b 65 2d 32 2e 35 30 2e 32 20 7b 0a 20 20 64  ike-2.50.2 {.  d
2a60: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
2a70: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
2a80: 20 4c 49 4b 45 20 27 32 25 27 22 0a 7d 20 7b 35   LIKE '2%'".} {5
2a90: 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  0}.do_test like-
2aa0: 32 2e 35 30 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.50.3 {.  db ev
2ab0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
2ac0: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
2ad0: 45 20 27 61 62 63 32 25 27 22 0a 7d 20 7b 35 30  E 'abc2%'".} {50
2ae0: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
2af0: 2e 35 31 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  .51.1 {.  db eva
2b00: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
2b10: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
2b20: 20 27 33 25 27 22 0a 7d 20 7b 35 31 7d 0a 64 6f   '3%'".} {51}.do
2b30: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35 31 2e  _test like-2.51.
2b40: 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  2 {.  db eval "S
2b50: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20  ELECT x FROM t2 
2b60: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 33 25  WHERE y LIKE '3%
2b70: 27 22 0a 7d 20 7b 35 31 7d 0a 64 6f 5f 74 65 73  '".} {51}.do_tes
2b80: 74 20 6c 69 6b 65 2d 32 2e 35 31 2e 33 20 7b 0a  t like-2.51.3 {.
2b90: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
2ba0: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
2bb0: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 33 25 27  E y LIKE 'abc3%'
2bc0: 22 0a 7d 20 7b 35 31 7d 0a 64 6f 5f 74 65 73 74  ".} {51}.do_test
2bd0: 20 6c 69 6b 65 2d 32 2e 35 32 2e 31 20 7b 0a 20   like-2.52.1 {. 
2be0: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
2bf0: 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45   x FROM t1 WHERE
2c00: 20 79 20 4c 49 4b 45 20 27 34 25 27 22 0a 7d 20   y LIKE '4%'".} 
2c10: 7b 35 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {52}.do_test lik
2c20: 65 2d 32 2e 35 32 2e 32 20 7b 0a 20 20 64 62 20  e-2.52.2 {.  db 
2c30: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
2c40: 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c  ROM t2 WHERE y L
2c50: 49 4b 45 20 27 34 25 27 22 0a 7d 20 7b 35 32 7d  IKE '4%'".} {52}
2c60: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
2c70: 35 32 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c  52.3 {.  db eval
2c80: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
2c90: 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t3 WHERE y LIKE 
2ca0: 27 61 62 63 34 25 27 22 0a 7d 20 7b 35 32 7d 0a  'abc4%'".} {52}.
2cb0: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35  do_test like-2.5
2cc0: 33 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  3.1 {.  db eval 
2cd0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
2ce0: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
2cf0: 35 25 27 22 0a 7d 20 7b 35 33 7d 0a 64 6f 5f 74  5%'".} {53}.do_t
2d00: 65 73 74 20 6c 69 6b 65 2d 32 2e 35 33 2e 32 20  est like-2.53.2 
2d10: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
2d20: 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48  ECT x FROM t2 WH
2d30: 45 52 45 20 79 20 4c 49 4b 45 20 27 35 25 27 22  ERE y LIKE '5%'"
2d40: 0a 7d 20 7b 35 33 7d 0a 64 6f 5f 74 65 73 74 20  .} {53}.do_test 
2d50: 6c 69 6b 65 2d 32 2e 35 33 2e 33 20 7b 0a 20 20  like-2.53.3 {.  
2d60: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
2d70: 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20  x FROM t3 WHERE 
2d80: 79 20 4c 49 4b 45 20 27 61 62 63 35 25 27 22 0a  y LIKE 'abc5%'".
2d90: 7d 20 7b 35 33 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {53}.do_test l
2da0: 69 6b 65 2d 32 2e 35 34 2e 31 20 7b 0a 20 20 64  ike-2.54.1 {.  d
2db0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
2dc0: 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79   FROM t1 WHERE y
2dd0: 20 4c 49 4b 45 20 27 36 25 27 22 0a 7d 20 7b 35   LIKE '6%'".} {5
2de0: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
2df0: 32 2e 35 34 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.54.2 {.  db ev
2e00: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
2e10: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
2e20: 45 20 27 36 25 27 22 0a 7d 20 7b 35 34 7d 0a 64  E '6%'".} {54}.d
2e30: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35 34  o_test like-2.54
2e40: 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .3 {.  db eval "
2e50: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33  SELECT x FROM t3
2e60: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61   WHERE y LIKE 'a
2e70: 62 63 36 25 27 22 0a 7d 20 7b 35 34 7d 0a 64 6f  bc6%'".} {54}.do
2e80: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35 35 2e  _test like-2.55.
2e90: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
2ea0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
2eb0: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 37 25  WHERE y LIKE '7%
2ec0: 27 22 0a 7d 20 7b 35 35 7d 0a 64 6f 5f 74 65 73  '".} {55}.do_tes
2ed0: 74 20 6c 69 6b 65 2d 32 2e 35 35 2e 32 20 7b 0a  t like-2.55.2 {.
2ee0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
2ef0: 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52  T x FROM t2 WHER
2f00: 45 20 79 20 4c 49 4b 45 20 27 37 25 27 22 0a 7d  E y LIKE '7%'".}
2f10: 20 7b 35 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {55}.do_test li
2f20: 6b 65 2d 32 2e 35 35 2e 33 20 7b 0a 20 20 64 62  ke-2.55.3 {.  db
2f30: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
2f40: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
2f50: 4c 49 4b 45 20 27 61 62 63 37 25 27 22 0a 7d 20  LIKE 'abc7%'".} 
2f60: 7b 35 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {55}.do_test lik
2f70: 65 2d 32 2e 35 36 2e 31 20 7b 0a 20 20 64 62 20  e-2.56.1 {.  db 
2f80: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
2f90: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
2fa0: 49 4b 45 20 27 38 25 27 22 0a 7d 20 7b 35 36 7d  IKE '8%'".} {56}
2fb0: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
2fc0: 35 36 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  56.2 {.  db eval
2fd0: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
2fe0: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
2ff0: 27 38 25 27 22 0a 7d 20 7b 35 36 7d 0a 64 6f 5f  '8%'".} {56}.do_
3000: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35 36 2e 33  test like-2.56.3
3010: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
3020: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57  LECT x FROM t3 W
3030: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63  HERE y LIKE 'abc
3040: 38 25 27 22 0a 7d 20 7b 35 36 7d 0a 64 6f 5f 74  8%'".} {56}.do_t
3050: 65 73 74 20 6c 69 6b 65 2d 32 2e 35 37 2e 31 20  est like-2.57.1 
3060: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
3070: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
3080: 45 52 45 20 79 20 4c 49 4b 45 20 27 39 25 27 22  ERE y LIKE '9%'"
3090: 0a 7d 20 7b 35 37 7d 0a 64 6f 5f 74 65 73 74 20  .} {57}.do_test 
30a0: 6c 69 6b 65 2d 32 2e 35 37 2e 32 20 7b 0a 20 20  like-2.57.2 {.  
30b0: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
30c0: 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20  x FROM t2 WHERE 
30d0: 79 20 4c 49 4b 45 20 27 39 25 27 22 0a 7d 20 7b  y LIKE '9%'".} {
30e0: 35 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  57}.do_test like
30f0: 2d 32 2e 35 37 2e 33 20 7b 0a 20 20 64 62 20 65  -2.57.3 {.  db e
3100: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3110: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
3120: 4b 45 20 27 61 62 63 39 25 27 22 0a 7d 20 7b 35  KE 'abc9%'".} {5
3130: 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  7}.do_test like-
3140: 32 2e 35 38 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.58.1 {.  db ev
3150: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
3160: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
3170: 45 20 27 3a 25 27 22 0a 7d 20 7b 35 38 7d 0a 64  E ':%'".} {58}.d
3180: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 35 38  o_test like-2.58
3190: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
31a0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
31b0: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 3a   WHERE y LIKE ':
31c0: 25 27 22 0a 7d 20 7b 35 38 7d 0a 64 6f 5f 74 65  %'".} {58}.do_te
31d0: 73 74 20 6c 69 6b 65 2d 32 2e 35 38 2e 33 20 7b  st like-2.58.3 {
31e0: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
31f0: 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45  CT x FROM t3 WHE
3200: 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 3a 25  RE y LIKE 'abc:%
3210: 27 22 0a 7d 20 7b 35 38 7d 0a 64 6f 5f 74 65 73  '".} {58}.do_tes
3220: 74 20 6c 69 6b 65 2d 32 2e 35 39 2e 31 20 7b 0a  t like-2.59.1 {.
3230: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
3240: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
3250: 45 20 79 20 4c 49 4b 45 20 27 3b 25 27 22 0a 7d  E y LIKE ';%'".}
3260: 20 7b 35 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {59}.do_test li
3270: 6b 65 2d 32 2e 35 39 2e 32 20 7b 0a 20 20 64 62  ke-2.59.2 {.  db
3280: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
3290: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
32a0: 4c 49 4b 45 20 27 3b 25 27 22 0a 7d 20 7b 35 39  LIKE ';%'".} {59
32b0: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
32c0: 2e 35 39 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .59.3 {.  db eva
32d0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
32e0: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
32f0: 20 27 61 62 63 3b 25 27 22 0a 7d 20 7b 35 39 7d   'abc;%'".} {59}
3300: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
3310: 36 30 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c  60.1 {.  db eval
3320: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
3330: 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t1 WHERE y LIKE 
3340: 27 3c 25 27 22 0a 7d 20 7b 36 30 7d 0a 64 6f 5f  '<%'".} {60}.do_
3350: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 36 30 2e 32  test like-2.60.2
3360: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
3370: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
3380: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 3c 25 27  HERE y LIKE '<%'
3390: 22 0a 7d 20 7b 36 30 7d 0a 64 6f 5f 74 65 73 74  ".} {60}.do_test
33a0: 20 6c 69 6b 65 2d 32 2e 36 30 2e 33 20 7b 0a 20   like-2.60.3 {. 
33b0: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
33c0: 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45   x FROM t3 WHERE
33d0: 20 79 20 4c 49 4b 45 20 27 61 62 63 3c 25 27 22   y LIKE 'abc<%'"
33e0: 0a 7d 20 7b 36 30 7d 0a 64 6f 5f 74 65 73 74 20  .} {60}.do_test 
33f0: 6c 69 6b 65 2d 32 2e 36 31 2e 31 20 7b 0a 20 20  like-2.61.1 {.  
3400: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
3410: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
3420: 79 20 4c 49 4b 45 20 27 3d 25 27 22 0a 7d 20 7b  y LIKE '=%'".} {
3430: 36 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  61}.do_test like
3440: 2d 32 2e 36 31 2e 32 20 7b 0a 20 20 64 62 20 65  -2.61.2 {.  db e
3450: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3460: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
3470: 4b 45 20 27 3d 25 27 22 0a 7d 20 7b 36 31 7d 0a  KE '=%'".} {61}.
3480: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 36  do_test like-2.6
3490: 31 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  1.3 {.  db eval 
34a0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
34b0: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
34c0: 61 62 63 3d 25 27 22 0a 7d 20 7b 36 31 7d 0a 64  abc=%'".} {61}.d
34d0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 36 32  o_test like-2.62
34e0: 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .1 {.  db eval "
34f0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31  SELECT x FROM t1
3500: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 3e   WHERE y LIKE '>
3510: 25 27 22 0a 7d 20 7b 36 32 7d 0a 64 6f 5f 74 65  %'".} {62}.do_te
3520: 73 74 20 6c 69 6b 65 2d 32 2e 36 32 2e 32 20 7b  st like-2.62.2 {
3530: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
3540: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
3550: 52 45 20 79 20 4c 49 4b 45 20 27 3e 25 27 22 0a  RE y LIKE '>%'".
3560: 7d 20 7b 36 32 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {62}.do_test l
3570: 69 6b 65 2d 32 2e 36 32 2e 33 20 7b 0a 20 20 64  ike-2.62.3 {.  d
3580: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
3590: 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79   FROM t3 WHERE y
35a0: 20 4c 49 4b 45 20 27 61 62 63 3e 25 27 22 0a 7d   LIKE 'abc>%'".}
35b0: 20 7b 36 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {62}.do_test li
35c0: 6b 65 2d 32 2e 36 33 2e 31 20 7b 0a 20 20 64 62  ke-2.63.1 {.  db
35d0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
35e0: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
35f0: 4c 49 4b 45 20 27 3f 25 27 22 0a 7d 20 7b 36 33  LIKE '?%'".} {63
3600: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
3610: 2e 36 33 2e 32 20 7b 0a 20 20 64 62 20 65 76 61  .63.2 {.  db eva
3620: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
3630: 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t2 WHERE y LIKE
3640: 20 27 3f 25 27 22 0a 7d 20 7b 36 33 7d 0a 64 6f   '?%'".} {63}.do
3650: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 36 33 2e  _test like-2.63.
3660: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
3670: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
3680: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
3690: 63 3f 25 27 22 0a 7d 20 7b 36 33 7d 0a 64 6f 5f  c?%'".} {63}.do_
36a0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 36 34 2e 31  test like-2.64.1
36b0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
36c0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57  LECT x FROM t1 W
36d0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 40 25 27  HERE y LIKE '@%'
36e0: 22 0a 7d 20 7b 36 34 7d 0a 64 6f 5f 74 65 73 74  ".} {64}.do_test
36f0: 20 6c 69 6b 65 2d 32 2e 36 34 2e 32 20 7b 0a 20   like-2.64.2 {. 
3700: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
3710: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
3720: 20 79 20 4c 49 4b 45 20 27 40 25 27 22 0a 7d 20   y LIKE '@%'".} 
3730: 7b 36 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {64}.do_test lik
3740: 65 2d 32 2e 36 34 2e 33 20 7b 0a 20 20 64 62 20  e-2.64.3 {.  db 
3750: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
3760: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
3770: 49 4b 45 20 27 61 62 63 40 25 27 22 0a 7d 20 7b  IKE 'abc@%'".} {
3780: 36 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  64}.do_test like
3790: 2d 32 2e 36 35 2e 31 20 7b 0a 20 20 64 62 20 65  -2.65.1 {.  db e
37a0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
37b0: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
37c0: 4b 45 20 27 41 25 27 22 0a 7d 20 7b 36 35 20 39  KE 'A%'".} {65 9
37d0: 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  7}.do_test like-
37e0: 32 2e 36 35 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.65.2 {.  db ev
37f0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
3800: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
3810: 45 20 27 41 25 27 22 0a 7d 20 7b 36 35 20 39 37  E 'A%'".} {65 97
3820: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
3830: 2e 36 35 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .65.3 {.  db eva
3840: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
3850: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
3860: 20 27 61 62 63 41 25 27 22 0a 7d 20 7b 36 35 20   'abcA%'".} {65 
3870: 39 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  97}.do_test like
3880: 2d 32 2e 36 36 2e 31 20 7b 0a 20 20 64 62 20 65  -2.66.1 {.  db e
3890: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
38a0: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
38b0: 4b 45 20 27 42 25 27 22 0a 7d 20 7b 36 36 20 39  KE 'B%'".} {66 9
38c0: 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  8}.do_test like-
38d0: 32 2e 36 36 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.66.2 {.  db ev
38e0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
38f0: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
3900: 45 20 27 42 25 27 22 0a 7d 20 7b 36 36 20 39 38  E 'B%'".} {66 98
3910: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
3920: 2e 36 36 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .66.3 {.  db eva
3930: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
3940: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
3950: 20 27 61 62 63 42 25 27 22 0a 7d 20 7b 36 36 20   'abcB%'".} {66 
3960: 39 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  98}.do_test like
3970: 2d 32 2e 36 37 2e 31 20 7b 0a 20 20 64 62 20 65  -2.67.1 {.  db e
3980: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3990: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
39a0: 4b 45 20 27 43 25 27 22 0a 7d 20 7b 36 37 20 39  KE 'C%'".} {67 9
39b0: 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  9}.do_test like-
39c0: 32 2e 36 37 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.67.2 {.  db ev
39d0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
39e0: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
39f0: 45 20 27 43 25 27 22 0a 7d 20 7b 36 37 20 39 39  E 'C%'".} {67 99
3a00: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
3a10: 2e 36 37 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .67.3 {.  db eva
3a20: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
3a30: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
3a40: 20 27 61 62 63 43 25 27 22 0a 7d 20 7b 36 37 20   'abcC%'".} {67 
3a50: 39 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  99}.do_test like
3a60: 2d 32 2e 36 38 2e 31 20 7b 0a 20 20 64 62 20 65  -2.68.1 {.  db e
3a70: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3a80: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
3a90: 4b 45 20 27 44 25 27 22 0a 7d 20 7b 36 38 20 31  KE 'D%'".} {68 1
3aa0: 30 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  00}.do_test like
3ab0: 2d 32 2e 36 38 2e 32 20 7b 0a 20 20 64 62 20 65  -2.68.2 {.  db e
3ac0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3ad0: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
3ae0: 4b 45 20 27 44 25 27 22 0a 7d 20 7b 36 38 20 31  KE 'D%'".} {68 1
3af0: 30 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  00}.do_test like
3b00: 2d 32 2e 36 38 2e 33 20 7b 0a 20 20 64 62 20 65  -2.68.3 {.  db e
3b10: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
3b20: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
3b30: 4b 45 20 27 61 62 63 44 25 27 22 0a 7d 20 7b 36  KE 'abcD%'".} {6
3b40: 38 20 31 30 30 7d 0a 64 6f 5f 74 65 73 74 20 6c  8 100}.do_test l
3b50: 69 6b 65 2d 32 2e 36 39 2e 31 20 7b 0a 20 20 64  ike-2.69.1 {.  d
3b60: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
3b70: 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79   FROM t1 WHERE y
3b80: 20 4c 49 4b 45 20 27 45 25 27 22 0a 7d 20 7b 36   LIKE 'E%'".} {6
3b90: 39 20 31 30 31 7d 0a 64 6f 5f 74 65 73 74 20 6c  9 101}.do_test l
3ba0: 69 6b 65 2d 32 2e 36 39 2e 32 20 7b 0a 20 20 64  ike-2.69.2 {.  d
3bb0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
3bc0: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
3bd0: 20 4c 49 4b 45 20 27 45 25 27 22 0a 7d 20 7b 36   LIKE 'E%'".} {6
3be0: 39 20 31 30 31 7d 0a 64 6f 5f 74 65 73 74 20 6c  9 101}.do_test l
3bf0: 69 6b 65 2d 32 2e 36 39 2e 33 20 7b 0a 20 20 64  ike-2.69.3 {.  d
3c00: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
3c10: 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79   FROM t3 WHERE y
3c20: 20 4c 49 4b 45 20 27 61 62 63 45 25 27 22 0a 7d   LIKE 'abcE%'".}
3c30: 20 7b 36 39 20 31 30 31 7d 0a 64 6f 5f 74 65 73   {69 101}.do_tes
3c40: 74 20 6c 69 6b 65 2d 32 2e 37 30 2e 31 20 7b 0a  t like-2.70.1 {.
3c50: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
3c60: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
3c70: 45 20 79 20 4c 49 4b 45 20 27 46 25 27 22 0a 7d  E y LIKE 'F%'".}
3c80: 20 7b 37 30 20 31 30 32 7d 0a 64 6f 5f 74 65 73   {70 102}.do_tes
3c90: 74 20 6c 69 6b 65 2d 32 2e 37 30 2e 32 20 7b 0a  t like-2.70.2 {.
3ca0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
3cb0: 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52  T x FROM t2 WHER
3cc0: 45 20 79 20 4c 49 4b 45 20 27 46 25 27 22 0a 7d  E y LIKE 'F%'".}
3cd0: 20 7b 37 30 20 31 30 32 7d 0a 64 6f 5f 74 65 73   {70 102}.do_tes
3ce0: 74 20 6c 69 6b 65 2d 32 2e 37 30 2e 33 20 7b 0a  t like-2.70.3 {.
3cf0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
3d00: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
3d10: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 46 25 27  E y LIKE 'abcF%'
3d20: 22 0a 7d 20 7b 37 30 20 31 30 32 7d 0a 64 6f 5f  ".} {70 102}.do_
3d30: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 31 2e 31  test like-2.71.1
3d40: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
3d50: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57  LECT x FROM t1 W
3d60: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 47 25 27  HERE y LIKE 'G%'
3d70: 22 0a 7d 20 7b 37 31 20 31 30 33 7d 0a 64 6f 5f  ".} {71 103}.do_
3d80: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 31 2e 32  test like-2.71.2
3d90: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
3da0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
3db0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 47 25 27  HERE y LIKE 'G%'
3dc0: 22 0a 7d 20 7b 37 31 20 31 30 33 7d 0a 64 6f 5f  ".} {71 103}.do_
3dd0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 31 2e 33  test like-2.71.3
3de0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
3df0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57  LECT x FROM t3 W
3e00: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63  HERE y LIKE 'abc
3e10: 47 25 27 22 0a 7d 20 7b 37 31 20 31 30 33 7d 0a  G%'".} {71 103}.
3e20: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37  do_test like-2.7
3e30: 32 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  2.1 {.  db eval 
3e40: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
3e50: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
3e60: 48 25 27 22 0a 7d 20 7b 37 32 20 31 30 34 7d 0a  H%'".} {72 104}.
3e70: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37  do_test like-2.7
3e80: 32 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  2.2 {.  db eval 
3e90: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
3ea0: 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  2 WHERE y LIKE '
3eb0: 48 25 27 22 0a 7d 20 7b 37 32 20 31 30 34 7d 0a  H%'".} {72 104}.
3ec0: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37  do_test like-2.7
3ed0: 32 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  2.3 {.  db eval 
3ee0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
3ef0: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
3f00: 61 62 63 48 25 27 22 0a 7d 20 7b 37 32 20 31 30  abcH%'".} {72 10
3f10: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
3f20: 32 2e 37 33 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.73.1 {.  db ev
3f30: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
3f40: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
3f50: 45 20 27 49 25 27 22 0a 7d 20 7b 37 33 20 31 30  E 'I%'".} {73 10
3f60: 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  5}.do_test like-
3f70: 32 2e 37 33 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.73.2 {.  db ev
3f80: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
3f90: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
3fa0: 45 20 27 49 25 27 22 0a 7d 20 7b 37 33 20 31 30  E 'I%'".} {73 10
3fb0: 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  5}.do_test like-
3fc0: 32 2e 37 33 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.73.3 {.  db ev
3fd0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
3fe0: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
3ff0: 45 20 27 61 62 63 49 25 27 22 0a 7d 20 7b 37 33  E 'abcI%'".} {73
4000: 20 31 30 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   105}.do_test li
4010: 6b 65 2d 32 2e 37 34 2e 31 20 7b 0a 20 20 64 62  ke-2.74.1 {.  db
4020: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
4030: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
4040: 4c 49 4b 45 20 27 4a 25 27 22 0a 7d 20 7b 37 34  LIKE 'J%'".} {74
4050: 20 31 30 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   106}.do_test li
4060: 6b 65 2d 32 2e 37 34 2e 32 20 7b 0a 20 20 64 62  ke-2.74.2 {.  db
4070: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
4080: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
4090: 4c 49 4b 45 20 27 4a 25 27 22 0a 7d 20 7b 37 34  LIKE 'J%'".} {74
40a0: 20 31 30 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   106}.do_test li
40b0: 6b 65 2d 32 2e 37 34 2e 33 20 7b 0a 20 20 64 62  ke-2.74.3 {.  db
40c0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
40d0: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
40e0: 4c 49 4b 45 20 27 61 62 63 4a 25 27 22 0a 7d 20  LIKE 'abcJ%'".} 
40f0: 7b 37 34 20 31 30 36 7d 0a 64 6f 5f 74 65 73 74  {74 106}.do_test
4100: 20 6c 69 6b 65 2d 32 2e 37 35 2e 31 20 7b 0a 20   like-2.75.1 {. 
4110: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
4120: 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45   x FROM t1 WHERE
4130: 20 79 20 4c 49 4b 45 20 27 4b 25 27 22 0a 7d 20   y LIKE 'K%'".} 
4140: 7b 37 35 20 31 30 37 7d 0a 64 6f 5f 74 65 73 74  {75 107}.do_test
4150: 20 6c 69 6b 65 2d 32 2e 37 35 2e 32 20 7b 0a 20   like-2.75.2 {. 
4160: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
4170: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
4180: 20 79 20 4c 49 4b 45 20 27 4b 25 27 22 0a 7d 20   y LIKE 'K%'".} 
4190: 7b 37 35 20 31 30 37 7d 0a 64 6f 5f 74 65 73 74  {75 107}.do_test
41a0: 20 6c 69 6b 65 2d 32 2e 37 35 2e 33 20 7b 0a 20   like-2.75.3 {. 
41b0: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
41c0: 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45   x FROM t3 WHERE
41d0: 20 79 20 4c 49 4b 45 20 27 61 62 63 4b 25 27 22   y LIKE 'abcK%'"
41e0: 0a 7d 20 7b 37 35 20 31 30 37 7d 0a 64 6f 5f 74  .} {75 107}.do_t
41f0: 65 73 74 20 6c 69 6b 65 2d 32 2e 37 36 2e 31 20  est like-2.76.1 
4200: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
4210: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
4220: 45 52 45 20 79 20 4c 49 4b 45 20 27 4c 25 27 22  ERE y LIKE 'L%'"
4230: 0a 7d 20 7b 37 36 20 31 30 38 7d 0a 64 6f 5f 74  .} {76 108}.do_t
4240: 65 73 74 20 6c 69 6b 65 2d 32 2e 37 36 2e 32 20  est like-2.76.2 
4250: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
4260: 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48  ECT x FROM t2 WH
4270: 45 52 45 20 79 20 4c 49 4b 45 20 27 4c 25 27 22  ERE y LIKE 'L%'"
4280: 0a 7d 20 7b 37 36 20 31 30 38 7d 0a 64 6f 5f 74  .} {76 108}.do_t
4290: 65 73 74 20 6c 69 6b 65 2d 32 2e 37 36 2e 33 20  est like-2.76.3 
42a0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
42b0: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
42c0: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 4c  ERE y LIKE 'abcL
42d0: 25 27 22 0a 7d 20 7b 37 36 20 31 30 38 7d 0a 64  %'".} {76 108}.d
42e0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 37  o_test like-2.77
42f0: 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .1 {.  db eval "
4300: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31  SELECT x FROM t1
4310: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 4d   WHERE y LIKE 'M
4320: 25 27 22 0a 7d 20 7b 37 37 20 31 30 39 7d 0a 64  %'".} {77 109}.d
4330: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 37  o_test like-2.77
4340: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
4350: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
4360: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 4d   WHERE y LIKE 'M
4370: 25 27 22 0a 7d 20 7b 37 37 20 31 30 39 7d 0a 64  %'".} {77 109}.d
4380: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 37 37  o_test like-2.77
4390: 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .3 {.  db eval "
43a0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33  SELECT x FROM t3
43b0: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61   WHERE y LIKE 'a
43c0: 62 63 4d 25 27 22 0a 7d 20 7b 37 37 20 31 30 39  bcM%'".} {77 109
43d0: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
43e0: 2e 37 38 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  .78.1 {.  db eva
43f0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
4400: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
4410: 20 27 4e 25 27 22 0a 7d 20 7b 37 38 20 31 31 30   'N%'".} {78 110
4420: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
4430: 2e 37 38 2e 32 20 7b 0a 20 20 64 62 20 65 76 61  .78.2 {.  db eva
4440: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
4450: 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t2 WHERE y LIKE
4460: 20 27 4e 25 27 22 0a 7d 20 7b 37 38 20 31 31 30   'N%'".} {78 110
4470: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
4480: 2e 37 38 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  .78.3 {.  db eva
4490: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
44a0: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
44b0: 20 27 61 62 63 4e 25 27 22 0a 7d 20 7b 37 38 20   'abcN%'".} {78 
44c0: 31 31 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  110}.do_test lik
44d0: 65 2d 32 2e 37 39 2e 31 20 7b 0a 20 20 64 62 20  e-2.79.1 {.  db 
44e0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
44f0: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
4500: 49 4b 45 20 27 4f 25 27 22 0a 7d 20 7b 37 39 20  IKE 'O%'".} {79 
4510: 31 31 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  111}.do_test lik
4520: 65 2d 32 2e 37 39 2e 32 20 7b 0a 20 20 64 62 20  e-2.79.2 {.  db 
4530: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
4540: 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c  ROM t2 WHERE y L
4550: 49 4b 45 20 27 4f 25 27 22 0a 7d 20 7b 37 39 20  IKE 'O%'".} {79 
4560: 31 31 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  111}.do_test lik
4570: 65 2d 32 2e 37 39 2e 33 20 7b 0a 20 20 64 62 20  e-2.79.3 {.  db 
4580: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
4590: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
45a0: 49 4b 45 20 27 61 62 63 4f 25 27 22 0a 7d 20 7b  IKE 'abcO%'".} {
45b0: 37 39 20 31 31 31 7d 0a 64 6f 5f 74 65 73 74 20  79 111}.do_test 
45c0: 6c 69 6b 65 2d 32 2e 38 30 2e 31 20 7b 0a 20 20  like-2.80.1 {.  
45d0: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
45e0: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
45f0: 79 20 4c 49 4b 45 20 27 50 25 27 22 0a 7d 20 7b  y LIKE 'P%'".} {
4600: 38 30 20 31 31 32 7d 0a 64 6f 5f 74 65 73 74 20  80 112}.do_test 
4610: 6c 69 6b 65 2d 32 2e 38 30 2e 32 20 7b 0a 20 20  like-2.80.2 {.  
4620: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
4630: 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20  x FROM t2 WHERE 
4640: 79 20 4c 49 4b 45 20 27 50 25 27 22 0a 7d 20 7b  y LIKE 'P%'".} {
4650: 38 30 20 31 31 32 7d 0a 64 6f 5f 74 65 73 74 20  80 112}.do_test 
4660: 6c 69 6b 65 2d 32 2e 38 30 2e 33 20 7b 0a 20 20  like-2.80.3 {.  
4670: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
4680: 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20  x FROM t3 WHERE 
4690: 79 20 4c 49 4b 45 20 27 61 62 63 50 25 27 22 0a  y LIKE 'abcP%'".
46a0: 7d 20 7b 38 30 20 31 31 32 7d 0a 64 6f 5f 74 65  } {80 112}.do_te
46b0: 73 74 20 6c 69 6b 65 2d 32 2e 38 31 2e 31 20 7b  st like-2.81.1 {
46c0: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
46d0: 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45  CT x FROM t1 WHE
46e0: 52 45 20 79 20 4c 49 4b 45 20 27 51 25 27 22 0a  RE y LIKE 'Q%'".
46f0: 7d 20 7b 38 31 20 31 31 33 7d 0a 64 6f 5f 74 65  } {81 113}.do_te
4700: 73 74 20 6c 69 6b 65 2d 32 2e 38 31 2e 32 20 7b  st like-2.81.2 {
4710: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
4720: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
4730: 52 45 20 79 20 4c 49 4b 45 20 27 51 25 27 22 0a  RE y LIKE 'Q%'".
4740: 7d 20 7b 38 31 20 31 31 33 7d 0a 64 6f 5f 74 65  } {81 113}.do_te
4750: 73 74 20 6c 69 6b 65 2d 32 2e 38 31 2e 33 20 7b  st like-2.81.3 {
4760: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
4770: 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45  CT x FROM t3 WHE
4780: 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 51 25  RE y LIKE 'abcQ%
4790: 27 22 0a 7d 20 7b 38 31 20 31 31 33 7d 0a 64 6f  '".} {81 113}.do
47a0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 32 2e  _test like-2.82.
47b0: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
47c0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
47d0: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 52 25  WHERE y LIKE 'R%
47e0: 27 22 0a 7d 20 7b 38 32 20 31 31 34 7d 0a 64 6f  '".} {82 114}.do
47f0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 32 2e  _test like-2.82.
4800: 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  2 {.  db eval "S
4810: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20  ELECT x FROM t2 
4820: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 52 25  WHERE y LIKE 'R%
4830: 27 22 0a 7d 20 7b 38 32 20 31 31 34 7d 0a 64 6f  '".} {82 114}.do
4840: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 32 2e  _test like-2.82.
4850: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
4860: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
4870: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
4880: 63 52 25 27 22 0a 7d 20 7b 38 32 20 31 31 34 7d  cR%'".} {82 114}
4890: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
48a0: 38 33 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c  83.1 {.  db eval
48b0: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
48c0: 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t1 WHERE y LIKE 
48d0: 27 53 25 27 22 0a 7d 20 7b 38 33 20 31 31 35 7d  'S%'".} {83 115}
48e0: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
48f0: 38 33 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  83.2 {.  db eval
4900: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
4910: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
4920: 27 53 25 27 22 0a 7d 20 7b 38 33 20 31 31 35 7d  'S%'".} {83 115}
4930: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
4940: 38 33 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c  83.3 {.  db eval
4950: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
4960: 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t3 WHERE y LIKE 
4970: 27 61 62 63 53 25 27 22 0a 7d 20 7b 38 33 20 31  'abcS%'".} {83 1
4980: 31 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  15}.do_test like
4990: 2d 32 2e 38 34 2e 31 20 7b 0a 20 20 64 62 20 65  -2.84.1 {.  db e
49a0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
49b0: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
49c0: 4b 45 20 27 54 25 27 22 0a 7d 20 7b 38 34 20 31  KE 'T%'".} {84 1
49d0: 31 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  16}.do_test like
49e0: 2d 32 2e 38 34 2e 32 20 7b 0a 20 20 64 62 20 65  -2.84.2 {.  db e
49f0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
4a00: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
4a10: 4b 45 20 27 54 25 27 22 0a 7d 20 7b 38 34 20 31  KE 'T%'".} {84 1
4a20: 31 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  16}.do_test like
4a30: 2d 32 2e 38 34 2e 33 20 7b 0a 20 20 64 62 20 65  -2.84.3 {.  db e
4a40: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
4a50: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
4a60: 4b 45 20 27 61 62 63 54 25 27 22 0a 7d 20 7b 38  KE 'abcT%'".} {8
4a70: 34 20 31 31 36 7d 0a 64 6f 5f 74 65 73 74 20 6c  4 116}.do_test l
4a80: 69 6b 65 2d 32 2e 38 35 2e 31 20 7b 0a 20 20 64  ike-2.85.1 {.  d
4a90: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
4aa0: 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79   FROM t1 WHERE y
4ab0: 20 4c 49 4b 45 20 27 55 25 27 22 0a 7d 20 7b 38   LIKE 'U%'".} {8
4ac0: 35 20 31 31 37 7d 0a 64 6f 5f 74 65 73 74 20 6c  5 117}.do_test l
4ad0: 69 6b 65 2d 32 2e 38 35 2e 32 20 7b 0a 20 20 64  ike-2.85.2 {.  d
4ae0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
4af0: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
4b00: 20 4c 49 4b 45 20 27 55 25 27 22 0a 7d 20 7b 38   LIKE 'U%'".} {8
4b10: 35 20 31 31 37 7d 0a 64 6f 5f 74 65 73 74 20 6c  5 117}.do_test l
4b20: 69 6b 65 2d 32 2e 38 35 2e 33 20 7b 0a 20 20 64  ike-2.85.3 {.  d
4b30: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
4b40: 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79   FROM t3 WHERE y
4b50: 20 4c 49 4b 45 20 27 61 62 63 55 25 27 22 0a 7d   LIKE 'abcU%'".}
4b60: 20 7b 38 35 20 31 31 37 7d 0a 64 6f 5f 74 65 73   {85 117}.do_tes
4b70: 74 20 6c 69 6b 65 2d 32 2e 38 36 2e 31 20 7b 0a  t like-2.86.1 {.
4b80: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
4b90: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
4ba0: 45 20 79 20 4c 49 4b 45 20 27 56 25 27 22 0a 7d  E y LIKE 'V%'".}
4bb0: 20 7b 38 36 20 31 31 38 7d 0a 64 6f 5f 74 65 73   {86 118}.do_tes
4bc0: 74 20 6c 69 6b 65 2d 32 2e 38 36 2e 32 20 7b 0a  t like-2.86.2 {.
4bd0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
4be0: 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52  T x FROM t2 WHER
4bf0: 45 20 79 20 4c 49 4b 45 20 27 56 25 27 22 0a 7d  E y LIKE 'V%'".}
4c00: 20 7b 38 36 20 31 31 38 7d 0a 64 6f 5f 74 65 73   {86 118}.do_tes
4c10: 74 20 6c 69 6b 65 2d 32 2e 38 36 2e 33 20 7b 0a  t like-2.86.3 {.
4c20: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
4c30: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
4c40: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 56 25 27  E y LIKE 'abcV%'
4c50: 22 0a 7d 20 7b 38 36 20 31 31 38 7d 0a 64 6f 5f  ".} {86 118}.do_
4c60: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 37 2e 31  test like-2.87.1
4c70: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
4c80: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57  LECT x FROM t1 W
4c90: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 57 25 27  HERE y LIKE 'W%'
4ca0: 22 0a 7d 20 7b 38 37 20 31 31 39 7d 0a 64 6f 5f  ".} {87 119}.do_
4cb0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 37 2e 32  test like-2.87.2
4cc0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
4cd0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
4ce0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 57 25 27  HERE y LIKE 'W%'
4cf0: 22 0a 7d 20 7b 38 37 20 31 31 39 7d 0a 64 6f 5f  ".} {87 119}.do_
4d00: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38 37 2e 33  test like-2.87.3
4d10: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
4d20: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57  LECT x FROM t3 W
4d30: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63  HERE y LIKE 'abc
4d40: 57 25 27 22 0a 7d 20 7b 38 37 20 31 31 39 7d 0a  W%'".} {87 119}.
4d50: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38  do_test like-2.8
4d60: 38 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  8.1 {.  db eval 
4d70: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
4d80: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
4d90: 58 25 27 22 0a 7d 20 7b 38 38 20 31 32 30 7d 0a  X%'".} {88 120}.
4da0: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38  do_test like-2.8
4db0: 38 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  8.2 {.  db eval 
4dc0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
4dd0: 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  2 WHERE y LIKE '
4de0: 58 25 27 22 0a 7d 20 7b 38 38 20 31 32 30 7d 0a  X%'".} {88 120}.
4df0: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 38  do_test like-2.8
4e00: 38 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  8.3 {.  db eval 
4e10: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
4e20: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
4e30: 61 62 63 58 25 27 22 0a 7d 20 7b 38 38 20 31 32  abcX%'".} {88 12
4e40: 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  0}.do_test like-
4e50: 32 2e 38 39 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.89.1 {.  db ev
4e60: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
4e70: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
4e80: 45 20 27 59 25 27 22 0a 7d 20 7b 38 39 20 31 32  E 'Y%'".} {89 12
4e90: 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  1}.do_test like-
4ea0: 32 2e 38 39 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.89.2 {.  db ev
4eb0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
4ec0: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
4ed0: 45 20 27 59 25 27 22 0a 7d 20 7b 38 39 20 31 32  E 'Y%'".} {89 12
4ee0: 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  1}.do_test like-
4ef0: 32 2e 38 39 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.89.3 {.  db ev
4f00: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
4f10: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
4f20: 45 20 27 61 62 63 59 25 27 22 0a 7d 20 7b 38 39  E 'abcY%'".} {89
4f30: 20 31 32 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   121}.do_test li
4f40: 6b 65 2d 32 2e 39 30 2e 31 20 7b 0a 20 20 64 62  ke-2.90.1 {.  db
4f50: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
4f60: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
4f70: 4c 49 4b 45 20 27 5a 25 27 22 0a 7d 20 7b 39 30  LIKE 'Z%'".} {90
4f80: 20 31 32 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   122}.do_test li
4f90: 6b 65 2d 32 2e 39 30 2e 32 20 7b 0a 20 20 64 62  ke-2.90.2 {.  db
4fa0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
4fb0: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
4fc0: 4c 49 4b 45 20 27 5a 25 27 22 0a 7d 20 7b 39 30  LIKE 'Z%'".} {90
4fd0: 20 31 32 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   122}.do_test li
4fe0: 6b 65 2d 32 2e 39 30 2e 33 20 7b 0a 20 20 64 62  ke-2.90.3 {.  db
4ff0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
5000: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
5010: 4c 49 4b 45 20 27 61 62 63 5a 25 27 22 0a 7d 20  LIKE 'abcZ%'".} 
5020: 7b 39 30 20 31 32 32 7d 0a 64 6f 5f 74 65 73 74  {90 122}.do_test
5030: 20 6c 69 6b 65 2d 32 2e 39 31 2e 31 20 7b 0a 20   like-2.91.1 {. 
5040: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
5050: 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45   x FROM t1 WHERE
5060: 20 79 20 4c 49 4b 45 20 27 5c 5b 25 27 22 0a 7d   y LIKE '\[%'".}
5070: 20 7b 39 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {91}.do_test li
5080: 6b 65 2d 32 2e 39 31 2e 32 20 7b 0a 20 20 64 62  ke-2.91.2 {.  db
5090: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
50a0: 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20  FROM t2 WHERE y 
50b0: 4c 49 4b 45 20 27 5c 5b 25 27 22 0a 7d 20 7b 39  LIKE '\[%'".} {9
50c0: 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  1}.do_test like-
50d0: 32 2e 39 31 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.91.3 {.  db ev
50e0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
50f0: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
5100: 45 20 27 61 62 63 5c 5b 25 27 22 0a 7d 20 7b 39  E 'abc\[%'".} {9
5110: 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  1}.do_test like-
5120: 32 2e 39 32 2e 31 20 7b 0a 20 20 64 62 20 65 76  2.92.1 {.  db ev
5130: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
5140: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
5150: 45 20 27 5c 5c 25 27 22 0a 7d 20 7b 39 32 7d 0a  E '\\%'".} {92}.
5160: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 39  do_test like-2.9
5170: 32 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  2.2 {.  db eval 
5180: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
5190: 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  2 WHERE y LIKE '
51a0: 5c 5c 25 27 22 0a 7d 20 7b 39 32 7d 0a 64 6f 5f  \\%'".} {92}.do_
51b0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 39 32 2e 33  test like-2.92.3
51c0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
51d0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57  LECT x FROM t3 W
51e0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63  HERE y LIKE 'abc
51f0: 5c 5c 25 27 22 0a 7d 20 7b 39 32 7d 0a 64 6f 5f  \\%'".} {92}.do_
5200: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 39 33 2e 31  test like-2.93.1
5210: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
5220: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57  LECT x FROM t1 W
5230: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 5c 5d 25  HERE y LIKE '\]%
5240: 27 22 0a 7d 20 7b 39 33 7d 0a 64 6f 5f 74 65 73  '".} {93}.do_tes
5250: 74 20 6c 69 6b 65 2d 32 2e 39 33 2e 32 20 7b 0a  t like-2.93.2 {.
5260: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
5270: 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52  T x FROM t2 WHER
5280: 45 20 79 20 4c 49 4b 45 20 27 5c 5d 25 27 22 0a  E y LIKE '\]%'".
5290: 7d 20 7b 39 33 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {93}.do_test l
52a0: 69 6b 65 2d 32 2e 39 33 2e 33 20 7b 0a 20 20 64  ike-2.93.3 {.  d
52b0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
52c0: 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79   FROM t3 WHERE y
52d0: 20 4c 49 4b 45 20 27 61 62 63 5c 5d 25 27 22 0a   LIKE 'abc\]%'".
52e0: 7d 20 7b 39 33 7d 0a 64 6f 5f 74 65 73 74 20 6c  } {93}.do_test l
52f0: 69 6b 65 2d 32 2e 39 34 2e 31 20 7b 0a 20 20 64  ike-2.94.1 {.  d
5300: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
5310: 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79   FROM t1 WHERE y
5320: 20 4c 49 4b 45 20 27 5e 25 27 22 0a 7d 20 7b 39   LIKE '^%'".} {9
5330: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
5340: 32 2e 39 34 2e 32 20 7b 0a 20 20 64 62 20 65 76  2.94.2 {.  db ev
5350: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
5360: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
5370: 45 20 27 5e 25 27 22 0a 7d 20 7b 39 34 7d 0a 64  E '^%'".} {94}.d
5380: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 39 34  o_test like-2.94
5390: 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .3 {.  db eval "
53a0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33  SELECT x FROM t3
53b0: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61   WHERE y LIKE 'a
53c0: 62 63 5e 25 27 22 0a 7d 20 7b 39 34 7d 0a 64 6f  bc^%'".} {94}.do
53d0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 39 36 2e  _test like-2.96.
53e0: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
53f0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
5400: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 60 25  WHERE y LIKE '`%
5410: 27 22 0a 7d 20 7b 39 36 7d 0a 64 6f 5f 74 65 73  '".} {96}.do_tes
5420: 74 20 6c 69 6b 65 2d 32 2e 39 36 2e 32 20 7b 0a  t like-2.96.2 {.
5430: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
5440: 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52  T x FROM t2 WHER
5450: 45 20 79 20 4c 49 4b 45 20 27 60 25 27 22 0a 7d  E y LIKE '`%'".}
5460: 20 7b 39 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   {96}.do_test li
5470: 6b 65 2d 32 2e 39 36 2e 33 20 7b 0a 20 20 64 62  ke-2.96.3 {.  db
5480: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
5490: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
54a0: 4c 49 4b 45 20 27 61 62 63 60 25 27 22 0a 7d 20  LIKE 'abc`%'".} 
54b0: 7b 39 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  {96}.do_test lik
54c0: 65 2d 32 2e 39 37 2e 31 20 7b 0a 20 20 64 62 20  e-2.97.1 {.  db 
54d0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
54e0: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
54f0: 49 4b 45 20 27 61 25 27 22 0a 7d 20 7b 36 35 20  IKE 'a%'".} {65 
5500: 39 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  97}.do_test like
5510: 2d 32 2e 39 37 2e 32 20 7b 0a 20 20 64 62 20 65  -2.97.2 {.  db e
5520: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
5530: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
5540: 4b 45 20 27 61 25 27 22 0a 7d 20 7b 36 35 20 39  KE 'a%'".} {65 9
5550: 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  7}.do_test like-
5560: 32 2e 39 37 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.97.3 {.  db ev
5570: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
5580: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
5590: 45 20 27 61 62 63 61 25 27 22 0a 7d 20 7b 36 35  E 'abca%'".} {65
55a0: 20 39 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b   97}.do_test lik
55b0: 65 2d 32 2e 39 38 2e 31 20 7b 0a 20 20 64 62 20  e-2.98.1 {.  db 
55c0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
55d0: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
55e0: 49 4b 45 20 27 62 25 27 22 0a 7d 20 7b 36 36 20  IKE 'b%'".} {66 
55f0: 39 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  98}.do_test like
5600: 2d 32 2e 39 38 2e 32 20 7b 0a 20 20 64 62 20 65  -2.98.2 {.  db e
5610: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
5620: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
5630: 4b 45 20 27 62 25 27 22 0a 7d 20 7b 36 36 20 39  KE 'b%'".} {66 9
5640: 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  8}.do_test like-
5650: 32 2e 39 38 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.98.3 {.  db ev
5660: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
5670: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
5680: 45 20 27 61 62 63 62 25 27 22 0a 7d 20 7b 36 36  E 'abcb%'".} {66
5690: 20 39 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b   98}.do_test lik
56a0: 65 2d 32 2e 39 39 2e 31 20 7b 0a 20 20 64 62 20  e-2.99.1 {.  db 
56b0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
56c0: 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c  ROM t1 WHERE y L
56d0: 49 4b 45 20 27 63 25 27 22 0a 7d 20 7b 36 37 20  IKE 'c%'".} {67 
56e0: 39 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  99}.do_test like
56f0: 2d 32 2e 39 39 2e 32 20 7b 0a 20 20 64 62 20 65  -2.99.2 {.  db e
5700: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
5710: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
5720: 4b 45 20 27 63 25 27 22 0a 7d 20 7b 36 37 20 39  KE 'c%'".} {67 9
5730: 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  9}.do_test like-
5740: 32 2e 39 39 2e 33 20 7b 0a 20 20 64 62 20 65 76  2.99.3 {.  db ev
5750: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
5760: 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b  M t3 WHERE y LIK
5770: 45 20 27 61 62 63 63 25 27 22 0a 7d 20 7b 36 37  E 'abcc%'".} {67
5780: 20 39 39 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b   99}.do_test lik
5790: 65 2d 32 2e 31 30 30 2e 31 20 7b 0a 20 20 64 62  e-2.100.1 {.  db
57a0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
57b0: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
57c0: 4c 49 4b 45 20 27 64 25 27 22 0a 7d 20 7b 36 38  LIKE 'd%'".} {68
57d0: 20 31 30 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   100}.do_test li
57e0: 6b 65 2d 32 2e 31 30 30 2e 32 20 7b 0a 20 20 64  ke-2.100.2 {.  d
57f0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
5800: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
5810: 20 4c 49 4b 45 20 27 64 25 27 22 0a 7d 20 7b 36   LIKE 'd%'".} {6
5820: 38 20 31 30 30 7d 0a 64 6f 5f 74 65 73 74 20 6c  8 100}.do_test l
5830: 69 6b 65 2d 32 2e 31 30 30 2e 33 20 7b 0a 20 20  ike-2.100.3 {.  
5840: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
5850: 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20  x FROM t3 WHERE 
5860: 79 20 4c 49 4b 45 20 27 61 62 63 64 25 27 22 0a  y LIKE 'abcd%'".
5870: 7d 20 7b 36 38 20 31 30 30 7d 0a 64 6f 5f 74 65  } {68 100}.do_te
5880: 73 74 20 6c 69 6b 65 2d 32 2e 31 30 31 2e 31 20  st like-2.101.1 
5890: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
58a0: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
58b0: 45 52 45 20 79 20 4c 49 4b 45 20 27 65 25 27 22  ERE y LIKE 'e%'"
58c0: 0a 7d 20 7b 36 39 20 31 30 31 7d 0a 64 6f 5f 74  .} {69 101}.do_t
58d0: 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 31 2e 32  est like-2.101.2
58e0: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
58f0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
5900: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 65 25 27  HERE y LIKE 'e%'
5910: 22 0a 7d 20 7b 36 39 20 31 30 31 7d 0a 64 6f 5f  ".} {69 101}.do_
5920: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 31 2e  test like-2.101.
5930: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
5940: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
5950: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
5960: 63 65 25 27 22 0a 7d 20 7b 36 39 20 31 30 31 7d  ce%'".} {69 101}
5970: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
5980: 31 30 32 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  102.1 {.  db eva
5990: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
59a0: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
59b0: 20 27 66 25 27 22 0a 7d 20 7b 37 30 20 31 30 32   'f%'".} {70 102
59c0: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
59d0: 2e 31 30 32 2e 32 20 7b 0a 20 20 64 62 20 65 76  .102.2 {.  db ev
59e0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
59f0: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
5a00: 45 20 27 66 25 27 22 0a 7d 20 7b 37 30 20 31 30  E 'f%'".} {70 10
5a10: 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  2}.do_test like-
5a20: 32 2e 31 30 32 2e 33 20 7b 0a 20 20 64 62 20 65  2.102.3 {.  db e
5a30: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
5a40: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
5a50: 4b 45 20 27 61 62 63 66 25 27 22 0a 7d 20 7b 37  KE 'abcf%'".} {7
5a60: 30 20 31 30 32 7d 0a 64 6f 5f 74 65 73 74 20 6c  0 102}.do_test l
5a70: 69 6b 65 2d 32 2e 31 30 33 2e 31 20 7b 0a 20 20  ike-2.103.1 {.  
5a80: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
5a90: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
5aa0: 79 20 4c 49 4b 45 20 27 67 25 27 22 0a 7d 20 7b  y LIKE 'g%'".} {
5ab0: 37 31 20 31 30 33 7d 0a 64 6f 5f 74 65 73 74 20  71 103}.do_test 
5ac0: 6c 69 6b 65 2d 32 2e 31 30 33 2e 32 20 7b 0a 20  like-2.103.2 {. 
5ad0: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
5ae0: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
5af0: 20 79 20 4c 49 4b 45 20 27 67 25 27 22 0a 7d 20   y LIKE 'g%'".} 
5b00: 7b 37 31 20 31 30 33 7d 0a 64 6f 5f 74 65 73 74  {71 103}.do_test
5b10: 20 6c 69 6b 65 2d 32 2e 31 30 33 2e 33 20 7b 0a   like-2.103.3 {.
5b20: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
5b30: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
5b40: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 67 25 27  E y LIKE 'abcg%'
5b50: 22 0a 7d 20 7b 37 31 20 31 30 33 7d 0a 64 6f 5f  ".} {71 103}.do_
5b60: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 34 2e  test like-2.104.
5b70: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
5b80: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
5b90: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 68 25  WHERE y LIKE 'h%
5ba0: 27 22 0a 7d 20 7b 37 32 20 31 30 34 7d 0a 64 6f  '".} {72 104}.do
5bb0: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 34  _test like-2.104
5bc0: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
5bd0: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
5be0: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 68   WHERE y LIKE 'h
5bf0: 25 27 22 0a 7d 20 7b 37 32 20 31 30 34 7d 0a 64  %'".} {72 104}.d
5c00: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30  o_test like-2.10
5c10: 34 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  4.3 {.  db eval 
5c20: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
5c30: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
5c40: 61 62 63 68 25 27 22 0a 7d 20 7b 37 32 20 31 30  abch%'".} {72 10
5c50: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
5c60: 32 2e 31 30 35 2e 31 20 7b 0a 20 20 64 62 20 65  2.105.1 {.  db e
5c70: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
5c80: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
5c90: 4b 45 20 27 69 25 27 22 0a 7d 20 7b 37 33 20 31  KE 'i%'".} {73 1
5ca0: 30 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  05}.do_test like
5cb0: 2d 32 2e 31 30 35 2e 32 20 7b 0a 20 20 64 62 20  -2.105.2 {.  db 
5cc0: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
5cd0: 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c  ROM t2 WHERE y L
5ce0: 49 4b 45 20 27 69 25 27 22 0a 7d 20 7b 37 33 20  IKE 'i%'".} {73 
5cf0: 31 30 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  105}.do_test lik
5d00: 65 2d 32 2e 31 30 35 2e 33 20 7b 0a 20 20 64 62  e-2.105.3 {.  db
5d10: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
5d20: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
5d30: 4c 49 4b 45 20 27 61 62 63 69 25 27 22 0a 7d 20  LIKE 'abci%'".} 
5d40: 7b 37 33 20 31 30 35 7d 0a 64 6f 5f 74 65 73 74  {73 105}.do_test
5d50: 20 6c 69 6b 65 2d 32 2e 31 30 36 2e 31 20 7b 0a   like-2.106.1 {.
5d60: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
5d70: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
5d80: 45 20 79 20 4c 49 4b 45 20 27 6a 25 27 22 0a 7d  E y LIKE 'j%'".}
5d90: 20 7b 37 34 20 31 30 36 7d 0a 64 6f 5f 74 65 73   {74 106}.do_tes
5da0: 74 20 6c 69 6b 65 2d 32 2e 31 30 36 2e 32 20 7b  t like-2.106.2 {
5db0: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
5dc0: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
5dd0: 52 45 20 79 20 4c 49 4b 45 20 27 6a 25 27 22 0a  RE y LIKE 'j%'".
5de0: 7d 20 7b 37 34 20 31 30 36 7d 0a 64 6f 5f 74 65  } {74 106}.do_te
5df0: 73 74 20 6c 69 6b 65 2d 32 2e 31 30 36 2e 33 20  st like-2.106.3 
5e00: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
5e10: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
5e20: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 6a  ERE y LIKE 'abcj
5e30: 25 27 22 0a 7d 20 7b 37 34 20 31 30 36 7d 0a 64  %'".} {74 106}.d
5e40: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30  o_test like-2.10
5e50: 37 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  7.1 {.  db eval 
5e60: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
5e70: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
5e80: 6b 25 27 22 0a 7d 20 7b 37 35 20 31 30 37 7d 0a  k%'".} {75 107}.
5e90: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31  do_test like-2.1
5ea0: 30 37 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  07.2 {.  db eval
5eb0: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
5ec0: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
5ed0: 27 6b 25 27 22 0a 7d 20 7b 37 35 20 31 30 37 7d  'k%'".} {75 107}
5ee0: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
5ef0: 31 30 37 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  107.3 {.  db eva
5f00: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
5f10: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
5f20: 20 27 61 62 63 6b 25 27 22 0a 7d 20 7b 37 35 20   'abck%'".} {75 
5f30: 31 30 37 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  107}.do_test lik
5f40: 65 2d 32 2e 31 30 38 2e 31 20 7b 0a 20 20 64 62  e-2.108.1 {.  db
5f50: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
5f60: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
5f70: 4c 49 4b 45 20 27 6c 25 27 22 0a 7d 20 7b 37 36  LIKE 'l%'".} {76
5f80: 20 31 30 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   108}.do_test li
5f90: 6b 65 2d 32 2e 31 30 38 2e 32 20 7b 0a 20 20 64  ke-2.108.2 {.  d
5fa0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
5fb0: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
5fc0: 20 4c 49 4b 45 20 27 6c 25 27 22 0a 7d 20 7b 37   LIKE 'l%'".} {7
5fd0: 36 20 31 30 38 7d 0a 64 6f 5f 74 65 73 74 20 6c  6 108}.do_test l
5fe0: 69 6b 65 2d 32 2e 31 30 38 2e 33 20 7b 0a 20 20  ike-2.108.3 {.  
5ff0: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
6000: 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20  x FROM t3 WHERE 
6010: 79 20 4c 49 4b 45 20 27 61 62 63 6c 25 27 22 0a  y LIKE 'abcl%'".
6020: 7d 20 7b 37 36 20 31 30 38 7d 0a 64 6f 5f 74 65  } {76 108}.do_te
6030: 73 74 20 6c 69 6b 65 2d 32 2e 31 30 39 2e 31 20  st like-2.109.1 
6040: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
6050: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
6060: 45 52 45 20 79 20 4c 49 4b 45 20 27 6d 25 27 22  ERE y LIKE 'm%'"
6070: 0a 7d 20 7b 37 37 20 31 30 39 7d 0a 64 6f 5f 74  .} {77 109}.do_t
6080: 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 39 2e 32  est like-2.109.2
6090: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
60a0: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
60b0: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 6d 25 27  HERE y LIKE 'm%'
60c0: 22 0a 7d 20 7b 37 37 20 31 30 39 7d 0a 64 6f 5f  ".} {77 109}.do_
60d0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 30 39 2e  test like-2.109.
60e0: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
60f0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
6100: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
6110: 63 6d 25 27 22 0a 7d 20 7b 37 37 20 31 30 39 7d  cm%'".} {77 109}
6120: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
6130: 31 31 30 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  110.1 {.  db eva
6140: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
6150: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
6160: 20 27 6e 25 27 22 0a 7d 20 7b 37 38 20 31 31 30   'n%'".} {78 110
6170: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
6180: 2e 31 31 30 2e 32 20 7b 0a 20 20 64 62 20 65 76  .110.2 {.  db ev
6190: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
61a0: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
61b0: 45 20 27 6e 25 27 22 0a 7d 20 7b 37 38 20 31 31  E 'n%'".} {78 11
61c0: 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  0}.do_test like-
61d0: 32 2e 31 31 30 2e 33 20 7b 0a 20 20 64 62 20 65  2.110.3 {.  db e
61e0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
61f0: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
6200: 4b 45 20 27 61 62 63 6e 25 27 22 0a 7d 20 7b 37  KE 'abcn%'".} {7
6210: 38 20 31 31 30 7d 0a 64 6f 5f 74 65 73 74 20 6c  8 110}.do_test l
6220: 69 6b 65 2d 32 2e 31 31 31 2e 31 20 7b 0a 20 20  ike-2.111.1 {.  
6230: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
6240: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
6250: 79 20 4c 49 4b 45 20 27 6f 25 27 22 0a 7d 20 7b  y LIKE 'o%'".} {
6260: 37 39 20 31 31 31 7d 0a 64 6f 5f 74 65 73 74 20  79 111}.do_test 
6270: 6c 69 6b 65 2d 32 2e 31 31 31 2e 32 20 7b 0a 20  like-2.111.2 {. 
6280: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
6290: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
62a0: 20 79 20 4c 49 4b 45 20 27 6f 25 27 22 0a 7d 20   y LIKE 'o%'".} 
62b0: 7b 37 39 20 31 31 31 7d 0a 64 6f 5f 74 65 73 74  {79 111}.do_test
62c0: 20 6c 69 6b 65 2d 32 2e 31 31 31 2e 33 20 7b 0a   like-2.111.3 {.
62d0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
62e0: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
62f0: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 6f 25 27  E y LIKE 'abco%'
6300: 22 0a 7d 20 7b 37 39 20 31 31 31 7d 0a 64 6f 5f  ".} {79 111}.do_
6310: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31 32 2e  test like-2.112.
6320: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
6330: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
6340: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 70 25  WHERE y LIKE 'p%
6350: 27 22 0a 7d 20 7b 38 30 20 31 31 32 7d 0a 64 6f  '".} {80 112}.do
6360: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31 32  _test like-2.112
6370: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
6380: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
6390: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 70   WHERE y LIKE 'p
63a0: 25 27 22 0a 7d 20 7b 38 30 20 31 31 32 7d 0a 64  %'".} {80 112}.d
63b0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31  o_test like-2.11
63c0: 32 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  2.3 {.  db eval 
63d0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
63e0: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
63f0: 61 62 63 70 25 27 22 0a 7d 20 7b 38 30 20 31 31  abcp%'".} {80 11
6400: 32 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  2}.do_test like-
6410: 32 2e 31 31 33 2e 31 20 7b 0a 20 20 64 62 20 65  2.113.1 {.  db e
6420: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
6430: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
6440: 4b 45 20 27 71 25 27 22 0a 7d 20 7b 38 31 20 31  KE 'q%'".} {81 1
6450: 31 33 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  13}.do_test like
6460: 2d 32 2e 31 31 33 2e 32 20 7b 0a 20 20 64 62 20  -2.113.2 {.  db 
6470: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
6480: 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c  ROM t2 WHERE y L
6490: 49 4b 45 20 27 71 25 27 22 0a 7d 20 7b 38 31 20  IKE 'q%'".} {81 
64a0: 31 31 33 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  113}.do_test lik
64b0: 65 2d 32 2e 31 31 33 2e 33 20 7b 0a 20 20 64 62  e-2.113.3 {.  db
64c0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
64d0: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
64e0: 4c 49 4b 45 20 27 61 62 63 71 25 27 22 0a 7d 20  LIKE 'abcq%'".} 
64f0: 7b 38 31 20 31 31 33 7d 0a 64 6f 5f 74 65 73 74  {81 113}.do_test
6500: 20 6c 69 6b 65 2d 32 2e 31 31 34 2e 31 20 7b 0a   like-2.114.1 {.
6510: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
6520: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
6530: 45 20 79 20 4c 49 4b 45 20 27 72 25 27 22 0a 7d  E y LIKE 'r%'".}
6540: 20 7b 38 32 20 31 31 34 7d 0a 64 6f 5f 74 65 73   {82 114}.do_tes
6550: 74 20 6c 69 6b 65 2d 32 2e 31 31 34 2e 32 20 7b  t like-2.114.2 {
6560: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
6570: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
6580: 52 45 20 79 20 4c 49 4b 45 20 27 72 25 27 22 0a  RE y LIKE 'r%'".
6590: 7d 20 7b 38 32 20 31 31 34 7d 0a 64 6f 5f 74 65  } {82 114}.do_te
65a0: 73 74 20 6c 69 6b 65 2d 32 2e 31 31 34 2e 33 20  st like-2.114.3 
65b0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
65c0: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
65d0: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 72  ERE y LIKE 'abcr
65e0: 25 27 22 0a 7d 20 7b 38 32 20 31 31 34 7d 0a 64  %'".} {82 114}.d
65f0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31  o_test like-2.11
6600: 35 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  5.1 {.  db eval 
6610: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
6620: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
6630: 73 25 27 22 0a 7d 20 7b 38 33 20 31 31 35 7d 0a  s%'".} {83 115}.
6640: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31  do_test like-2.1
6650: 31 35 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  15.2 {.  db eval
6660: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
6670: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
6680: 27 73 25 27 22 0a 7d 20 7b 38 33 20 31 31 35 7d  's%'".} {83 115}
6690: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
66a0: 31 31 35 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  115.3 {.  db eva
66b0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
66c0: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
66d0: 20 27 61 62 63 73 25 27 22 0a 7d 20 7b 38 33 20   'abcs%'".} {83 
66e0: 31 31 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  115}.do_test lik
66f0: 65 2d 32 2e 31 31 36 2e 31 20 7b 0a 20 20 64 62  e-2.116.1 {.  db
6700: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
6710: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
6720: 4c 49 4b 45 20 27 74 25 27 22 0a 7d 20 7b 38 34  LIKE 't%'".} {84
6730: 20 31 31 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69   116}.do_test li
6740: 6b 65 2d 32 2e 31 31 36 2e 32 20 7b 0a 20 20 64  ke-2.116.2 {.  d
6750: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
6760: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
6770: 20 4c 49 4b 45 20 27 74 25 27 22 0a 7d 20 7b 38   LIKE 't%'".} {8
6780: 34 20 31 31 36 7d 0a 64 6f 5f 74 65 73 74 20 6c  4 116}.do_test l
6790: 69 6b 65 2d 32 2e 31 31 36 2e 33 20 7b 0a 20 20  ike-2.116.3 {.  
67a0: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
67b0: 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20  x FROM t3 WHERE 
67c0: 79 20 4c 49 4b 45 20 27 61 62 63 74 25 27 22 0a  y LIKE 'abct%'".
67d0: 7d 20 7b 38 34 20 31 31 36 7d 0a 64 6f 5f 74 65  } {84 116}.do_te
67e0: 73 74 20 6c 69 6b 65 2d 32 2e 31 31 37 2e 31 20  st like-2.117.1 
67f0: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
6800: 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48  ECT x FROM t1 WH
6810: 45 52 45 20 79 20 4c 49 4b 45 20 27 75 25 27 22  ERE y LIKE 'u%'"
6820: 0a 7d 20 7b 38 35 20 31 31 37 7d 0a 64 6f 5f 74  .} {85 117}.do_t
6830: 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31 37 2e 32  est like-2.117.2
6840: 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45   {.  db eval "SE
6850: 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57  LECT x FROM t2 W
6860: 48 45 52 45 20 79 20 4c 49 4b 45 20 27 75 25 27  HERE y LIKE 'u%'
6870: 22 0a 7d 20 7b 38 35 20 31 31 37 7d 0a 64 6f 5f  ".} {85 117}.do_
6880: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 31 37 2e  test like-2.117.
6890: 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  3 {.  db eval "S
68a0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20  ELECT x FROM t3 
68b0: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62  WHERE y LIKE 'ab
68c0: 63 75 25 27 22 0a 7d 20 7b 38 35 20 31 31 37 7d  cu%'".} {85 117}
68d0: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
68e0: 31 31 38 2e 31 20 7b 0a 20 20 64 62 20 65 76 61  118.1 {.  db eva
68f0: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
6900: 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t1 WHERE y LIKE
6910: 20 27 76 25 27 22 0a 7d 20 7b 38 36 20 31 31 38   'v%'".} {86 118
6920: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
6930: 2e 31 31 38 2e 32 20 7b 0a 20 20 64 62 20 65 76  .118.2 {.  db ev
6940: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
6950: 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b  M t2 WHERE y LIK
6960: 45 20 27 76 25 27 22 0a 7d 20 7b 38 36 20 31 31  E 'v%'".} {86 11
6970: 38 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  8}.do_test like-
6980: 32 2e 31 31 38 2e 33 20 7b 0a 20 20 64 62 20 65  2.118.3 {.  db e
6990: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
69a0: 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c 49  OM t3 WHERE y LI
69b0: 4b 45 20 27 61 62 63 76 25 27 22 0a 7d 20 7b 38  KE 'abcv%'".} {8
69c0: 36 20 31 31 38 7d 0a 64 6f 5f 74 65 73 74 20 6c  6 118}.do_test l
69d0: 69 6b 65 2d 32 2e 31 31 39 2e 31 20 7b 0a 20 20  ike-2.119.1 {.  
69e0: 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20  db eval "SELECT 
69f0: 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20  x FROM t1 WHERE 
6a00: 79 20 4c 49 4b 45 20 27 77 25 27 22 0a 7d 20 7b  y LIKE 'w%'".} {
6a10: 38 37 20 31 31 39 7d 0a 64 6f 5f 74 65 73 74 20  87 119}.do_test 
6a20: 6c 69 6b 65 2d 32 2e 31 31 39 2e 32 20 7b 0a 20  like-2.119.2 {. 
6a30: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
6a40: 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45   x FROM t2 WHERE
6a50: 20 79 20 4c 49 4b 45 20 27 77 25 27 22 0a 7d 20   y LIKE 'w%'".} 
6a60: 7b 38 37 20 31 31 39 7d 0a 64 6f 5f 74 65 73 74  {87 119}.do_test
6a70: 20 6c 69 6b 65 2d 32 2e 31 31 39 2e 33 20 7b 0a   like-2.119.3 {.
6a80: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
6a90: 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48 45 52  T x FROM t3 WHER
6aa0: 45 20 79 20 4c 49 4b 45 20 27 61 62 63 77 25 27  E y LIKE 'abcw%'
6ab0: 22 0a 7d 20 7b 38 37 20 31 31 39 7d 0a 64 6f 5f  ".} {87 119}.do_
6ac0: 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 32 30 2e  test like-2.120.
6ad0: 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53  1 {.  db eval "S
6ae0: 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 31 20  ELECT x FROM t1 
6af0: 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 78 25  WHERE y LIKE 'x%
6b00: 27 22 0a 7d 20 7b 38 38 20 31 32 30 7d 0a 64 6f  '".} {88 120}.do
6b10: 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 32 30  _test like-2.120
6b20: 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c 20 22  .2 {.  db eval "
6b30: 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74 32  SELECT x FROM t2
6b40: 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27 78   WHERE y LIKE 'x
6b50: 25 27 22 0a 7d 20 7b 38 38 20 31 32 30 7d 0a 64  %'".} {88 120}.d
6b60: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 32  o_test like-2.12
6b70: 30 2e 33 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  0.3 {.  db eval 
6b80: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
6b90: 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  3 WHERE y LIKE '
6ba0: 61 62 63 78 25 27 22 0a 7d 20 7b 38 38 20 31 32  abcx%'".} {88 12
6bb0: 30 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  0}.do_test like-
6bc0: 32 2e 31 32 31 2e 31 20 7b 0a 20 20 64 62 20 65  2.121.1 {.  db e
6bd0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
6be0: 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49  OM t1 WHERE y LI
6bf0: 4b 45 20 27 79 25 27 22 0a 7d 20 7b 38 39 20 31  KE 'y%'".} {89 1
6c00: 32 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  21}.do_test like
6c10: 2d 32 2e 31 32 31 2e 32 20 7b 0a 20 20 64 62 20  -2.121.2 {.  db 
6c20: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
6c30: 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c  ROM t2 WHERE y L
6c40: 49 4b 45 20 27 79 25 27 22 0a 7d 20 7b 38 39 20  IKE 'y%'".} {89 
6c50: 31 32 31 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  121}.do_test lik
6c60: 65 2d 32 2e 31 32 31 2e 33 20 7b 0a 20 20 64 62  e-2.121.3 {.  db
6c70: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
6c80: 46 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20  FROM t3 WHERE y 
6c90: 4c 49 4b 45 20 27 61 62 63 79 25 27 22 0a 7d 20  LIKE 'abcy%'".} 
6ca0: 7b 38 39 20 31 32 31 7d 0a 64 6f 5f 74 65 73 74  {89 121}.do_test
6cb0: 20 6c 69 6b 65 2d 32 2e 31 32 32 2e 31 20 7b 0a   like-2.122.1 {.
6cc0: 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43    db eval "SELEC
6cd0: 54 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52  T x FROM t1 WHER
6ce0: 45 20 79 20 4c 49 4b 45 20 27 7a 25 27 22 0a 7d  E y LIKE 'z%'".}
6cf0: 20 7b 39 30 20 31 32 32 7d 0a 64 6f 5f 74 65 73   {90 122}.do_tes
6d00: 74 20 6c 69 6b 65 2d 32 2e 31 32 32 2e 32 20 7b  t like-2.122.2 {
6d10: 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45  .  db eval "SELE
6d20: 43 54 20 78 20 46 52 4f 4d 20 74 32 20 57 48 45  CT x FROM t2 WHE
6d30: 52 45 20 79 20 4c 49 4b 45 20 27 7a 25 27 22 0a  RE y LIKE 'z%'".
6d40: 7d 20 7b 39 30 20 31 32 32 7d 0a 64 6f 5f 74 65  } {90 122}.do_te
6d50: 73 74 20 6c 69 6b 65 2d 32 2e 31 32 32 2e 33 20  st like-2.122.3 
6d60: 7b 0a 20 20 64 62 20 65 76 61 6c 20 22 53 45 4c  {.  db eval "SEL
6d70: 45 43 54 20 78 20 46 52 4f 4d 20 74 33 20 57 48  ECT x FROM t3 WH
6d80: 45 52 45 20 79 20 4c 49 4b 45 20 27 61 62 63 7a  ERE y LIKE 'abcz
6d90: 25 27 22 0a 7d 20 7b 39 30 20 31 32 32 7d 0a 64  %'".} {90 122}.d
6da0: 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31 32  o_test like-2.12
6db0: 33 2e 31 20 7b 0a 20 20 64 62 20 65 76 61 6c 20  3.1 {.  db eval 
6dc0: 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20 74  "SELECT x FROM t
6dd0: 31 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20 27  1 WHERE y LIKE '
6de0: 5c 31 37 33 25 27 22 0a 7d 20 7b 31 32 33 7d 0a  \173%'".} {123}.
6df0: 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e 31  do_test like-2.1
6e00: 32 33 2e 32 20 7b 0a 20 20 64 62 20 65 76 61 6c  23.2 {.  db eval
6e10: 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d 20   "SELECT x FROM 
6e20: 74 32 20 57 48 45 52 45 20 79 20 4c 49 4b 45 20  t2 WHERE y LIKE 
6e30: 27 5c 31 37 33 25 27 22 0a 7d 20 7b 31 32 33 7d  '\173%'".} {123}
6e40: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
6e50: 31 32 33 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  123.3 {.  db eva
6e60: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
6e70: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
6e80: 20 27 61 62 63 5c 31 37 33 25 27 22 0a 7d 20 7b   'abc\173%'".} {
6e90: 31 32 33 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b  123}.do_test lik
6ea0: 65 2d 32 2e 31 32 34 2e 31 20 7b 0a 20 20 64 62  e-2.124.1 {.  db
6eb0: 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20   eval "SELECT x 
6ec0: 46 52 4f 4d 20 74 31 20 57 48 45 52 45 20 79 20  FROM t1 WHERE y 
6ed0: 4c 49 4b 45 20 27 7c 25 27 22 0a 7d 20 7b 31 32  LIKE '|%'".} {12
6ee0: 34 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  4}.do_test like-
6ef0: 32 2e 31 32 34 2e 32 20 7b 0a 20 20 64 62 20 65  2.124.2 {.  db e
6f00: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
6f10: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
6f20: 4b 45 20 27 7c 25 27 22 0a 7d 20 7b 31 32 34 7d  KE '|%'".} {124}
6f30: 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32 2e  .do_test like-2.
6f40: 31 32 34 2e 33 20 7b 0a 20 20 64 62 20 65 76 61  124.3 {.  db eva
6f50: 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f 4d  l "SELECT x FROM
6f60: 20 74 33 20 57 48 45 52 45 20 79 20 4c 49 4b 45   t3 WHERE y LIKE
6f70: 20 27 61 62 63 7c 25 27 22 0a 7d 20 7b 31 32 34   'abc|%'".} {124
6f80: 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d 32  }.do_test like-2
6f90: 2e 31 32 35 2e 31 20 7b 0a 20 20 64 62 20 65 76  .125.1 {.  db ev
6fa0: 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52 4f  al "SELECT x FRO
6fb0: 4d 20 74 31 20 57 48 45 52 45 20 79 20 4c 49 4b  M t1 WHERE y LIK
6fc0: 45 20 27 5c 31 37 35 25 27 22 0a 7d 20 7b 31 32  E '\175%'".} {12
6fd0: 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65 2d  5}.do_test like-
6fe0: 32 2e 31 32 35 2e 32 20 7b 0a 20 20 64 62 20 65  2.125.2 {.  db e
6ff0: 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46 52  val "SELECT x FR
7000: 4f 4d 20 74 32 20 57 48 45 52 45 20 79 20 4c 49  OM t2 WHERE y LI
7010: 4b 45 20 27 5c 31 37 35 25 27 22 0a 7d 20 7b 31  KE '\175%'".} {1
7020: 32 35 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  25}.do_test like
7030: 2d 32 2e 31 32 35 2e 33 20 7b 0a 20 20 64 62 20  -2.125.3 {.  db 
7040: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
7050: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
7060: 49 4b 45 20 27 61 62 63 5c 31 37 35 25 27 22 0a  IKE 'abc\175%'".
7070: 7d 20 7b 31 32 35 7d 0a 64 6f 5f 74 65 73 74 20  } {125}.do_test 
7080: 6c 69 6b 65 2d 32 2e 31 32 36 2e 31 20 7b 0a 20  like-2.126.1 {. 
7090: 20 64 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54   db eval "SELECT
70a0: 20 78 20 46 52 4f 4d 20 74 31 20 57 48 45 52 45   x FROM t1 WHERE
70b0: 20 79 20 4c 49 4b 45 20 27 7e 25 27 22 0a 7d 20   y LIKE '~%'".} 
70c0: 7b 31 32 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69  {126}.do_test li
70d0: 6b 65 2d 32 2e 31 32 36 2e 32 20 7b 0a 20 20 64  ke-2.126.2 {.  d
70e0: 62 20 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78  b eval "SELECT x
70f0: 20 46 52 4f 4d 20 74 32 20 57 48 45 52 45 20 79   FROM t2 WHERE y
7100: 20 4c 49 4b 45 20 27 7e 25 27 22 0a 7d 20 7b 31   LIKE '~%'".} {1
7110: 32 36 7d 0a 64 6f 5f 74 65 73 74 20 6c 69 6b 65  26}.do_test like
7120: 2d 32 2e 31 32 36 2e 33 20 7b 0a 20 20 64 62 20  -2.126.3 {.  db 
7130: 65 76 61 6c 20 22 53 45 4c 45 43 54 20 78 20 46  eval "SELECT x F
7140: 52 4f 4d 20 74 33 20 57 48 45 52 45 20 79 20 4c  ROM t3 WHERE y L
7150: 49 4b 45 20 27 61 62 63 7e 25 27 22 0a 7d 20 7b  IKE 'abc~%'".} {
7160: 31 32 36 7d 0a 0a 0a 66 69 6e 69 73 68 5f 74 65  126}...finish_te
7170: 73 74 0a                                         st.