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 (#1408)
* add tests

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

19 lines
461 B
Plaintext

CREATE TABLE blobs(k INTEGER PRIMARY KEY, v BLOB);
INSERT INTO blobs VALUES(1, zeroblob(100));
INSERT INTO blobs VALUES(2, zeroblob(100));
INSERT INTO blobs VALUES(3, 42);
INSERT INTO blobs VALUES(4, 54.4);
INSERT INTO blobs VALUES(5, NULL);
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
ATTACH 'test.db2' AS aux;
CREATE TABLE aux.t1(a INTEGER PRIMARY KEY, b);
INSERT INTO t1 VALUES(4, 'hello');
INSERT INTO aux.t1 VALUES(4, 'world');