mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 14:23:38 +00:00
25 lines
626 B
Plaintext
25 lines
626 B
Plaintext
|
|
CREATE TABLE t1(a, b);
|
|
PRAGMA journal_mode = WAL;
|
|
ATTACH 'test.db2' AS two;
|
|
CREATE TABLE two.t2(a, b);
|
|
|
|
PRAGMA main.journal_mode
|
|
PRAGMA two.journal_mode
|
|
PRAGMA two.journal_mode = DELETE
|
|
INSERT INTO t1 DEFAULT VALUES
|
|
PRAGMA main.journal_mode
|
|
PRAGMA journal_mode
|
|
PRAGMA journal_mode = WAL
|
|
ATTACH 'test.db2' AS two
|
|
PRAGMA main.journal_mode
|
|
PRAGMA two.journal_mode
|
|
INSERT INTO two.t2 DEFAULT VALUES
|
|
PRAGMA two.journal_mode
|
|
PRAGMA journal_mode = DELETE
|
|
PRAGMA main.journal_mode
|
|
PRAGMA two.journal_mode
|
|
PRAGMA journal_mode = WAL
|
|
PRAGMA main.journal_mode
|
|
PRAGMA two.journal_mode
|