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

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

19 lines
436 B
Plaintext

PRAGMA auto_vacuum = 0;
CREATE TABLE t1(a, b);
PRAGMA journal_mode = wal;
WITH s(i) AS (
SELECT 1 UNION ALL SELECT i+1 FROM s LIMIT 30
)
INSERT INTO t1 SELECT randomblob(400), randomblob(400) FROM s;
PRAGMA auto_vacuum = 0;
CREATE TABLE t1(a, b);
PRAGMA journal_mode = wal;
WITH s(i) AS (
SELECT 1 UNION ALL SELECT i+1 FROM s LIMIT 30
)
INSERT INTO t1 SELECT randomblob(400), randomblob(400) FROM s;