0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 22:39:05 +00:00
ad hoc ad79ef48a2
libsql wal tests ()
* add tests

* add bench
2024-05-24 13:59:17 +00:00

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';