mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-14 06:45:21 +00:00
27 lines
503 B
Plaintext
27 lines
503 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($doc1);
|
|
INSERT INTO t2 VALUES($doc2);
|
|
INSERT INTO t2 VALUES($doc3);
|
|
COMMIT;
|
|
|
|
|
|
SELECT quote(root) from t2_segdir;
|
|
|