62
62
} {3 {The value is <b>123456789</b>}}
67
CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);
68
INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
69
SELECT rowid FROM t1 WHERE content MATCH 'run jump';
75
CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter);
76
INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
77
SELECT rowid FROM t1 WHERE content MATCH 'run jump';
83
CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= simple);
84
INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
85
SELECT rowid FROM t1 WHERE content MATCH 'run jump';
91
CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter);
92
INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
93
SELECT rowid FROM t1 WHERE content MATCH 'run jump';
99
CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize = porter);
100
INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
101
SELECT rowid FROM t1 WHERE content MATCH 'run jump';