0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 19:09:41 +00:00
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

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

93 lines
2.4 KiB
Plaintext

CREATE TABLE cc(a, b, c);
SELECT name FROM sqlite_master
DROP TABLE t1
CREATE VIRTUAL TABLE t2 USING fts4(x, y, notindexed=x);
SELECT x FROM t2 WHERE t2 MATCH '2'
SELECT x FROM t2 WHERE t2 MATCH '1'
SELECT x FROM t2 WHERE t2 MATCH 'x'
SELECT x FROM t2 WHERE t2 MATCH 'x 1'
DROP TABLE t2
CREATE VIRTUAL TABLE t2 USING fts4(poi, addr, notindexed=poi);
INSERT INTO t2 VALUES(114, 'x x x');
INSERT INTO t2 VALUES(X'1234', 'y y y');
INSERT INTO t2 VALUES(NULL, 'z z z');
INSERT INTO t2 VALUES(113.2, 'w w w');
INSERT INTO t2 VALUES('poi', 'v v v');
SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'x'
SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'y'
SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'z'
SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'w'
SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'v'
DROP TABLE t2
CREATE VIRTUAL TABLE t2 USING fts4(
notindexed="three", one, two, three, notindexed="one",
);
INSERT INTO t2 VALUES('a', 'b', 'c');
INSERT INTO t2 VALUES('c', 'a', 'b');
INSERT INTO t2 VALUES('b', 'c', 'a');
SELECT docid FROM t2 WHERE t2 MATCH 'a'
SELECT docid FROM t2 WHERE t2 MATCH 'b'
SELECT docid FROM t2 WHERE t2 MATCH 'c'
DROP TABLE t2
CREATE VIRTUAL TABLE t1 USING fts4(
poiCategory, poiCategoryId, notindexed=poiCategoryId
);
INSERT INTO t1(poiCategory, poiCategoryId) values ('Restaurant', 6021);
SELECT * FROM t1 WHERE t1 MATCH 'restaurant';
SELECT * FROM t1 WHERE t1 MATCH 're*';
SELECT * FROM t1 WHERE t1 MATCH '6021';
SELECT * FROM t1 WHERE t1 MATCH '60*';
DROP TABLE t1;
CREATE VIRTUAL TABLE t1 USING fts4(
poiCategory, poiCategoryId, notindexed=poiCategory
);
INSERT INTO t1(poiCategory, poiCategoryId) values ('Restaurant', 6021);
SELECT * FROM t1 WHERE t1 MATCH 'restaurant';
SELECT * FROM t1 WHERE t1 MATCH 're*';
SELECT * FROM t1 WHERE t1 MATCH '6021';
SELECT * FROM t1 WHERE t1 MATCH '60*';
DROP TABLE t1;
CREATE VIRTUAL TABLE t1 USING fts4(abc, ab, a, notindexed=abc);
CREATE VIRTUAL TABLE t2 USING fts4(a, ab, abc, notindexed=abc);
INSERT INTO t1 VALUES('no', 'yes', 'yep');
INSERT INTO t2 VALUES('yep', 'yes', 'no');
SELECT count(*) FROM t1 WHERE t1 MATCH 'no';
SELECT count(*) FROM t1 WHERE t1 MATCH 'yes';
SELECT count(*) FROM t1 WHERE t1 MATCH 'yep';
SELECT count(*) FROM t2 WHERE t2 MATCH 'no';
SELECT count(*) FROM t2 WHERE t2 MATCH 'yes';
SELECT count(*) FROM t2 WHERE t2 MATCH 'yep';