0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-12 18:39:44 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/snapshot_up.test
2024-05-27 12:59:10 +02:00

23 lines
276 B
Plaintext

CREATE TABLE t1(a, b, c);
PRAGMA journal_mode = wal;
INSERT INTO t1 VALUES(1, 2, 3);
INSERT INTO t1 VALUES(4, 5, 6);
INSERT INTO t1 VALUES(7, 8, 9);
BEGIN;
SELECT * FROM t1
SELECT * FROM t1
SELECT * FROM t1
BEGIN;
SELECT * FROM t1
COMMIT