Return to fts3first.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

Annotation of embedaddon/sqlite3/test/fts3first.test, revision 1.1.1.1

1.1       misho       1: # 2011 October 18
                      2: #
                      3: # The author disclaims copyright to this source code.  In place of
                      4: # a legal notice, here is a blessing:
                      5: #
                      6: #    May you do good and not evil.
                      7: #    May you find forgiveness for yourself and forgive others.
                      8: #    May you share freely, never taking more than you give.
                      9: #
                     10: #***********************************************************************
                     11: 
                     12: set testdir [file dirname $argv0]
                     13: source $testdir/tester.tcl
                     14: source $testdir/malloc_common.tcl
                     15: 
                     16: ifcapable !fts3 {
                     17:   finish_test
                     18:   return
                     19: }
                     20: 
                     21: set testprefix fts3first
                     22: 
                     23: proc lreverse {L} {
                     24:   set res [list]
                     25:   for {set ii [expr [llength $L]-1]} {$ii>=0} {incr ii -1} {
                     26:     lappend res [lindex $L $ii]
                     27:   }
                     28:   set res
                     29: }
                     30: 
                     31: proc mit {blob} {
                     32:   set scan(littleEndian) i*
                     33:   set scan(bigEndian) I*
                     34:   binary scan $blob $scan($::tcl_platform(byteOrder)) r
                     35:   return $r
                     36: }
                     37: db func mit mit
                     38: 
                     39: do_execsql_test 1.0 {
                     40:   CREATE VIRTUAL TABLE x1 USING FTS4(a, b, c);
                     41:   INSERT INTO x1(docid,a,b,c) VALUES(0, 'K H D S T', 'V M N Y K', 'S Z N Q S');
                     42:   INSERT INTO x1(docid,a,b,c) VALUES(1, 'K N J L W', 'S Z W J Q', 'D U W S E');
                     43:   INSERT INTO x1(docid,a,b,c) VALUES(2, 'B P M O I', 'R P H W S', 'R J L L E');
                     44:   INSERT INTO x1(docid,a,b,c) VALUES(3, 'U R Q M L', 'M J K A V', 'Q W J T J');
                     45:   INSERT INTO x1(docid,a,b,c) VALUES(4, 'N J C Y N', 'R U D X V', 'B O U A Q');
                     46:   INSERT INTO x1(docid,a,b,c) VALUES(5, 'Q L X L U', 'I F N X S', 'U Q A N Y');
                     47:   INSERT INTO x1(docid,a,b,c) VALUES(6, 'M R G U T', 'U V I Q P', 'X Y D L S');
                     48:   INSERT INTO x1(docid,a,b,c) VALUES(7, 'D Y P O I', 'X J P K R', 'V O T H V');
                     49:   INSERT INTO x1(docid,a,b,c) VALUES(8, 'R Y D L R', 'U U E S J', 'N W L M R');
                     50:   INSERT INTO x1(docid,a,b,c) VALUES(9, 'Z P F N P', 'W A X D U', 'V A E Q A');
                     51:   INSERT INTO x1(docid,a,b,c) VALUES(10, 'Q I A Q M', 'N D K H C', 'A H T Q Z');
                     52:   INSERT INTO x1(docid,a,b,c) VALUES(11, 'T E R Q B', 'C I B C B', 'F Z U W R');
                     53:   INSERT INTO x1(docid,a,b,c) VALUES(12, 'E S V U W', 'T P F W H', 'A M D J Q');
                     54:   INSERT INTO x1(docid,a,b,c) VALUES(13, 'X S B X Y', 'U D N D P', 'X Z Y G F');
                     55:   INSERT INTO x1(docid,a,b,c) VALUES(14, 'K H A B L', 'S R C C Z', 'D W E H J');
                     56:   INSERT INTO x1(docid,a,b,c) VALUES(15, 'C E U C C', 'W F M N M', 'T Z U X T');
                     57:   INSERT INTO x1(docid,a,b,c) VALUES(16, 'Q G C G H', 'H N N B H', 'B Q I H Y');
                     58:   INSERT INTO x1(docid,a,b,c) VALUES(17, 'Q T S K B', 'W B D Y N', 'V J P E C');
                     59:   INSERT INTO x1(docid,a,b,c) VALUES(18, 'A J M O Q', 'L G Y Y A', 'G N M R N');
                     60:   INSERT INTO x1(docid,a,b,c) VALUES(19, 'T R Y P Y', 'N V Y B X', 'L Z T N T');
                     61: 
                     62:   CREATE VIRTUAL TABLE x2 USING FTS4(a, b, c, order=DESC);
                     63:   INSERT INTO x2(docid, a, b, c) SELECT docid, a, b, c FROM x1;
                     64: }
                     65: 
                     66: 
                     67: # Test queries.
                     68: #
                     69: foreach x {1 2} {
                     70:   foreach {tn match res} {
                     71:     1  "^K"              {0 1 14}
                     72:     2  "^S"              {0 1 14}
                     73:     3  "^W"              {9 15 17}
                     74:     4  "^J"              {}
                     75:     5  "^E"              {12}
                     76:     6  "V ^-E"           {0 3 4 6 7 9 17 19}
                     77:     7  "V -^E"           {0 3 4 6 7 9 17 19}
                     78:     8  "^-E V"           {0 3 4 6 7 9 17 19}
                     79:     9  "-^E V"           {0 3 4 6 7 9 17 19}
                     80:     10 "V"               {0 3 4 6 7 9 12 17 19}
                     81: 
                     82:     11 {"^K H"}          {0 14}
                     83:     12 {"K H"}           {0 10 14}
                     84:     13 {"K ^H"}          {}
                     85:   } {
                     86:     set rev [lreverse $res]
                     87:     do_execsql_test 1.$x.$tn.1 {SELECT docid FROM x1 WHERE x1 MATCH $match} $res
                     88:     do_execsql_test 1.$x.$tn.2 {SELECT docid FROM x2 WHERE x2 MATCH $match} $rev
                     89:   }
                     90: 
                     91:   do_execsql_test 1.$x.[expr $tn+1] { 
                     92:     INSERT INTO x1(x1) VALUES('optimize');
                     93:     INSERT INTO x2(x2) VALUES('optimize');
                     94:   } {}
                     95: }
                     96: 
                     97: # Test the snippet() function.
                     98: #
                     99: foreach {tn match res} {
                    100:   1  {^K}    {{[K] H D S T} {[K] N J L W} {[K] H A B L}}
                    101:   2  {^X}    {{[X] Y D L S} {[X] J P K R} {[X] S B X Y}}
                    102:   3  {^X Y}  {{[X] [Y] D L S} {D [Y] P O I...[X] J P K R} {[X] S B X [Y]}}
                    103: } {
                    104:   set rev [lreverse $res]
                    105: 
                    106:   do_execsql_test 1.3.$tn.1 {
                    107:     SELECT snippet(x1, '[', ']', '...') FROM x1 WHERE x1 MATCH $match
                    108:   } $res
                    109: 
                    110:   do_execsql_test 1.3.$tn.2 {
                    111:     SELECT snippet(x2, '[', ']', '...') FROM x2 WHERE x2 MATCH $match
                    112:   } $rev
                    113: }
                    114: 
                    115: # Test matchinfo().
                    116: #
                    117: foreach {tn match res} {
                    118:   1  {^K}    {
                    119:                 {1 3 3 0 0 0 0 0 0}
                    120:                 {1 3 3 0 0 0 0 0 0}
                    121:                 {1 3 3 0 0 0 0 0 0}
                    122:              }
                    123:   2  {^X}    {
                    124:                 {0 1 1 0 1 1 1 2 2}
                    125:                 {0 1 1 1 1 1 0 2 2}
                    126:                 {1 1 1 0 1 1 1 2 2}
                    127:              }
                    128:   3  {^X Y}  {
                    129:                 {0 1 1 0 1 1 1 2 2 0 6 5 0 5 4 1 4 4} 
                    130:                 {0 1 1 1 1 1 0 2 2 1 6 5 0 5 4 0 4 4} 
                    131:                 {1 1 1 0 1 1 1 2 2 1 6 5 0 5 4 1 4 4}
                    132:              }
                    133: } {
                    134:   set rev [lreverse $res]
                    135: 
                    136:   do_execsql_test 1.3.$tn.1 {
                    137:     SELECT mit(matchinfo(x1, 'x')) FROM x1 WHERE x1 MATCH $match
                    138:   } $res
                    139:   do_execsql_test 1.3.$tn.2 {
                    140:     SELECT mit(matchinfo(x2, 'x')) FROM x2 WHERE x2 MATCH $match
                    141:   } $rev
                    142: }
                    143: 
                    144: # Test that ^ is ignored for FTS3 tables.
                    145: #
                    146: do_execsql_test 2.1 {
                    147:   CREATE VIRTUAL TABLE x3 USING fts3;
                    148:   INSERT INTO x3 VALUES('A B C');
                    149:   INSERT INTO x3 VALUES('B A C');
                    150: 
                    151:   CREATE VIRTUAL TABLE x4 USING fts4;
                    152:   INSERT INTO x4 VALUES('A B C');
                    153:   INSERT INTO x4 VALUES('B A C');
                    154: }
                    155: 
                    156: do_execsql_test 2.2.1 {
                    157:   SELECT * FROM x3 WHERE x3 MATCH '^A';
                    158: } {{A B C} {B A C}}
                    159: do_execsql_test 2.2.2 {
                    160:   SELECT * FROM x4 WHERE x4 MATCH '^A';
                    161: } {{A B C}}
                    162: 
                    163: finish_test