mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 07:29:41 +00:00
91 lines
2.2 KiB
Plaintext
91 lines
2.2 KiB
Plaintext
|
|
CREATE VIRTUAL TABLE t1 USING fts4(a, b, languageid=l);
|
|
INSERT INTO t1(a, b, l) VALUES
|
|
('zero zero', 'zero zero', 0),
|
|
('one two', 'three four', 1),
|
|
('five six', 'seven eight', 2)
|
|
;
|
|
CREATE VIRTUAL TABLE terms USING fts4aux(t1);
|
|
|
|
|
|
SELECT term, documents, occurrences, languageid FROM terms WHERE col = '*';
|
|
|
|
|
|
SELECT * FROM terms;
|
|
|
|
|
|
SELECT * FROM terms WHERE languageid='';
|
|
|
|
|
|
SELECT * FROM terms WHERE languageid=-1;
|
|
|
|
|
|
SELECT * FROM terms WHERE languageid=9223372036854775807;
|
|
|
|
|
|
SELECT * FROM terms WHERE languageid=-9223372036854775808;
|
|
|
|
|
|
SELECT * FROM terms WHERE languageid=NULL;
|
|
|
|
|
|
SELECT term, documents, occurrences, languageid
|
|
FROM terms WHERE col = '*' AND languageid=1;
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid=1;
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid=1 AND term='zero'
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid='1' AND term='two'
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid='+1' AND term>'four'
|
|
|
|
|
|
SELECT term, documents, occurrences, languageid
|
|
FROM terms WHERE col = '*' AND languageid=2;
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid=2;
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE languageid=2 AND term='five';
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE term='five' AND languageid=2
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE term>='seven' AND languageid=2
|
|
|
|
|
|
SELECT term, col, documents, occurrences, languageid
|
|
FROM terms WHERE term>='e' AND term<'seven' AND languageid=2
|
|
|
|
|
|
CREATE VIRTUAL TABLE ft USING fts3();
|
|
INSERT INTO ft VALUES('a_234567890123456789');
|
|
INSERT INTO ft VALUES('b_234567890123456789');
|
|
INSERT INTO ft VALUES('c_234567890123456789');
|
|
CREATE VIRTUAL TABLE t2 USING fts4aux(ft);
|
|
|
|
|
|
SELECT term FROM t2 WHERE term=X'625f323334353637383930313233343536373839';
|
|
|
|
|
|
SELECT term FROM t2 WHERE term<X'625f003334353637383930313233343536373839';
|
|
|
|
|
|
SELECT term FROM t2 WHERE term=X'625f003334353637383930313233343536373839';
|
|
|