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

29 lines
672 B
Plaintext

CREATE TABLE t1(a,b,c);
INSERT INTO t1 VALUES(2,3,5);
CREATE INDEX t1a ON t1(a);
SELECT run, sql FROM sqlite_stmt ORDER BY 1;
INSERT INTO t1 VALUES(7,11,13);
SELECT reprep,run,SQL FROM sqlite_stmt WHERE sql LIKE '%INSERT%' AND NOT busy;
INSERT INTO t1 VALUES(17,19,23);
SELECT reprep,run,SQL FROM sqlite_stmt WHERE sql LIKE '%INSERT%' AND NOT busy;
CREATE INDEX t1b ON t1(b);
INSERT INTO t1 VALUES(29, 31, 37);
SELECT reprep,run,SQL FROM sqlite_stmt WHERE sql LIKE '%INSERT%' AND NOT busy;
SELECT count(*) FROM sqlite_stmt WHERE NOT busy;
SELECT count(*) FROM sqlite_stmt WHERE mem>5000;
SELECT * FROM sqlite_stmt WHERE NOT busy;