| Index: third_party/sqlite/src/test/fts3ad.test
|
| diff --git a/third_party/sqlite/src/test/fts3ad.test b/third_party/sqlite/src/test/fts3ad.test
|
| index 420b5b27453f4b2bbdad63da5012bc6ae6160cc5..e373339d4e74b10991efac46192c1e00c397a475 100644
|
| --- a/third_party/sqlite/src/test/fts3ad.test
|
| +++ b/third_party/sqlite/src/test/fts3ad.test
|
| @@ -61,5 +61,46 @@ do_test fts3ad-1.6 {
|
| }
|
| } {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
|
|
|