SQLite

Check-in [5030ba2e30]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add extra tests for parsing of whitespace in tokenizer declarations,.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5030ba2e308df6aeef2ed6b2e153f7baf2c81262
User & Date: dan 2009-12-07 16:23:43.000
Context
2009-12-07
16:26
Remove a redundant line from fts3. (check-in: cd50acf37f user: dan tags: trunk)
16:23
Add extra tests for parsing of whitespace in tokenizer declarations,. (check-in: 5030ba2e30 user: dan tags: trunk)
16:18
Move some SQLITE_TEST code down to avoid mixing code and variable declarations. Fix a test for high-order bit handling in sqlite3Fts3InitTokenizer(). (check-in: fad43d290f user: shaneh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/fts3ad.test.
︙︙
56
57
58
59
60
61
62









































63
64
65

  }
} {3 {The value is <b>123456789</b>}}
do_test fts3ad-1.6 {
  execsql {
    SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
  }
} {3 {The value is <b>123456789</b>}}











































finish_test








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>




56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106

  }
} {3 {The value is <b>123456789</b>}}
do_test fts3ad-1.6 {
  execsql {
    SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
  }
} {3 {The value is <b>123456789</b>}}

do_test fts3ad-2.1 {
  execsql {
    DROP TABLE t1;
    CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize    porter);
    INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
    SELECT rowid FROM t1 WHERE content MATCH 'run jump';
  }
} {1}
do_test fts3ad-2.2 {
  execsql {
    DROP TABLE t1;
    CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize=   porter);
    INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
    SELECT rowid FROM t1 WHERE content MATCH 'run jump';
  }
} {1}
do_test fts3ad-2.3 {
  execsql {
    DROP TABLE t1;
    CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize=   simple);
    INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
    SELECT rowid FROM t1 WHERE content MATCH 'run jump';
  }
} {}
do_test fts3ad-2.4 {
  execsql {
    DROP TABLE t1;
    CREATE VIRTUAL TABLE t1 USING fts3(content,   tokenize=   porter);
    INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
    SELECT rowid FROM t1 WHERE content MATCH 'run jump';
  }
} {1}
do_test fts3ad-2.5 {
  execsql {
    DROP TABLE t1;
    CREATE VIRTUAL TABLE t1 USING fts3(content,	   tokenize =   porter);
    INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
    SELECT rowid FROM t1 WHERE content MATCH 'run jump';
  }
} {1}


finish_test