mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
27 lines
506 B
Plaintext
27 lines
506 B
Plaintext
|
|
PRAGMA page_size = 512;
|
|
CREATE VIRTUAL TABLE t1 USING fts3;
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES('one');
|
|
INSERT INTO t1 VALUES('one');
|
|
INSERT INTO t1 VALUES('one');
|
|
COMMIT;
|
|
|
|
|
|
SELECT quote(root) from t1_segdir;
|
|
|
|
|
|
UPDATE t1_segdir SET root = X'00036F6E650EFFFFFFFFFFFFFFFFFFFFFFFF0200';
|
|
|
|
|
|
CREATE VIRTUAL TABLE t2 USING fts3;
|
|
BEGIN;
|
|
INSERT INTO t2 VALUES("foobar");
|
|
INSERT INTO t2 VALUES("foo");
|
|
INSERT INTO t2 VALUES("bar");
|
|
COMMIT;
|
|
|
|
|
|
SELECT quote(root) from t2_segdir;
|
|
|