mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
118 lines
3.2 KiB
Plaintext
118 lines
3.2 KiB
Plaintext
|
|
CREATE VIRTUAL TABLE t1 USING fts4(a, b, languageid=lang_id);
|
|
|
|
|
|
SELECT sql FROM sqlite_master WHERE name = 't1_content';
|
|
|
|
SELECT docid FROM t1
|
|
SELECT lang_id FROM t1
|
|
INSERT INTO t1(a, b) VALUES('aaa', 'bbb')
|
|
SELECT lang_id FROM t1
|
|
INSERT INTO t1(a, b, lang_id) VALUES('aaa', 'bbb', 4)
|
|
SELECT lang_id FROM t1
|
|
SELECT lang_id FROM t1
|
|
|
|
CREATE VIRTUAL TABLE t2 USING fts4;
|
|
INSERT INTO t2 VALUES('abc');
|
|
|
|
SELECT rowid FROM t2 WHERE content MATCH 'abc'
|
|
|
|
DROP TABLE t1;
|
|
CREATE VIRTUAL TABLE t1 USING fts4(languageid=lang_id);
|
|
INSERT INTO t1(content) VALUES('a b c');
|
|
INSERT INTO t1(content, lang_id) VALUES('a b c', 1);
|
|
|
|
|
|
SELECT rowid FROM t1 WHERE t1 MATCH 'b';
|
|
|
|
|
|
SELECT rowid FROM t1 WHERE t1 MATCH 'b' AND lang_id = 0;
|
|
|
|
|
|
SELECT rowid FROM t1 WHERE t1 MATCH 'b' AND lang_id = 1;
|
|
|
|
|
|
DROP TABLE t1;
|
|
CREATE VIRTUAL TABLE t1 USING fts4(languageid=lang_id);
|
|
INSERT INTO t1(content, lang_id) VALUES('A', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('B', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('C', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('D', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('E', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('F', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('G', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('H', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('I', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('J', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('K', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('L', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('M', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('N', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('O', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('P', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('Q', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('R', 13);
|
|
INSERT INTO t1(content, lang_id) VALUES('S', 13);
|
|
SELECT rowid FROM t1 WHERE t1 MATCH 'A';
|
|
|
|
|
|
INSERT INTO t2(t2) VALUES('optimize');
|
|
SELECT count(*) FROM t2_segdir;
|
|
|
|
|
|
CREATE VIRTUAL TABLE t2 USING fts4(content=t3_data, languageid=l);
|
|
INSERT INTO t2(t2) VALUES('rebuild');
|
|
|
|
|
|
DROP TABLE t2;
|
|
CREATE VIRTUAL TABLE t2 USING fts4(x, y, languageid=l, content=nosuchtable);
|
|
|
|
|
|
INSERT INTO t2(docid, x, y, l) SELECT rowid, x, y, l FROM t3_data;
|
|
|
|
|
|
DROP TABLE t3_data;
|
|
|
|
|
|
CREATE TABLE t8c(a, b);
|
|
CREATE VIRTUAL TABLE t8 USING fts4(content=t8c, languageid=langid);
|
|
INSERT INTO t8(docid, a, b) VALUES(-1, 'one two three', 'x y z');
|
|
SELECT docid FROM t8 WHERE t8 MATCH 'one x' AND langid=0
|
|
|
|
|
|
SELECT docid FROM t4 WHERE t4 MATCH 'quick';
|
|
|
|
|
|
SELECT docid FROM t4 WHERE t4 MATCH 'quick' AND lid=1;
|
|
|
|
|
|
SELECT docid FROM t4 WHERE t4 MATCH 'Quick' AND lid=1;
|
|
|
|
|
|
SELECT level FROM t5_segdir;
|
|
|
|
SELECT docid FROM t5 WHERE t5 MATCH 'language'
|
|
|
|
CREATE VIRTUAL TABLE t6 USING fts4(languageid=lid);
|
|
INSERT INTO t6 VALUES('I belong to language 0!');
|
|
|
|
INSERT INTO t6(t6) VALUES('optimize')
|
|
SELECT docid FROM t6 WHERE t6 MATCH 'belong'
|
|
|
|
SELECT docid FROM t6 WHERE t6 MATCH 'belong' AND lid=$lid
|
|
|
|
|
|
CREATE VIRTUAL TABLE vt0 USING fts4(c0, languageid="lid");
|
|
INSERT INTO vt0 VALUES ('a'), ('b');
|
|
BEGIN;
|
|
UPDATE vt0 SET lid = 1 WHERE lid=0;
|
|
|
|
|
|
INSERT INTO vt0(vt0) VALUES('integrity-check');
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
COMMIT;
|
|
INSERT INTO vt0(vt0) VALUES('integrity-check');
|
|
|