mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
27 lines
839 B
Plaintext
27 lines
839 B
Plaintext
|
|
CREATE VIRTUAL TABLE t4 USING fts4(a, b, c, notindexed=b);
|
|
INSERT INTO t4 VALUES('text one', 'text two', 'text three');
|
|
INSERT INTO t4(t4) VALUES('integrity-check');
|
|
|
|
|
|
PRAGMA writable_schema = 1;
|
|
UPDATE sqlite_master
|
|
SET sql = 'CREATE VIRTUAL TABLE t4 USING fts4(a, b, c)'
|
|
WHERE name = 't4';
|
|
|
|
|
|
BEGIN;
|
|
CREATE VIRTUAL TABLE t5 USING fts4(a, prefix="1,2,3");
|
|
INSERT INTO t5 VALUES('And down by Kosiosko, where the reed-banks sweep');
|
|
INSERT INTO t5 VALUES('and sway, and the rolling plains are wide, the');
|
|
INSERT INTO t5 VALUES('man from snowy river is a household name today,');
|
|
INSERT INTO t5 VALUES('and the stockmen tell the story of his ride');
|
|
|
|
|
|
INSERT INTO t5(t5) VALUES('integrity-check');
|
|
|
|
|
|
CREATE VIRTUAL TABLE t5 USING fts4(a, prefix="1,2,3");
|
|
INSERT INTO t5(t5) VALUES('integrity-check');
|
|
|