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

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

36 lines
681 B
Plaintext

CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2);
CREATE TABLE t1(x, y);
INSERT INTO t1 VALUES(1, 2);
SELECT name FROM sqlite_master ORDER BY 1;
SELECT * FROM t1;
SELECT * FROM rt;
SELECT name FROM sqlite_master ORDER BY 1;
CREATE VIRTUAL TABLE ft USING fts5(x);
CREATE TABLE t1(x, y);
INSERT INTO t1 VALUES(1, 2);
SELECT name FROM sqlite_master ORDER BY 1;
SELECT name FROM sqlite_master ORDER BY 1;
CREATE VIRTUAL TABLE ft USING fts3(x);
CREATE TABLE t1(x, y);
INSERT INTO t1 VALUES(1, 2);
SELECT name FROM sqlite_master ORDER BY 1;
SELECT name FROM sqlite_master ORDER BY 1;