mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-12 23:15:20 +00:00
27 lines
624 B
Plaintext
27 lines
624 B
Plaintext
INSERT INTO t2 VALUES(456)
|
|
SELECT * FROM t1, t2
|
|
PRAGMA locking_mode=NORMAL
|
|
PRAGMA journal_mode=PERSIST
|
|
PRAGMA journal_mode=TRUNCATE
|
|
PRAGMA journal_mode=PERSIST
|
|
PRAGMA journal_mode=DELETE
|
|
PRAGMA journal_mode=TRUNCATE
|
|
PRAGMA locking_mode=EXCLUSIVE
|
|
CREATE TABLE t3(z)
|
|
BEGIN IMMEDIATE
|
|
PRAGMA journal_mode=DELETE
|
|
COMMIT
|
|
PRAGMA journal_mode=DELETE
|
|
PRAGMA journal_mode=TRUNCATE
|
|
PRAGMA locking_mode=NORMAL
|
|
CREATE TABLE t4(w)
|
|
BEGIN IMMEDIATE
|
|
PRAGMA journal_mode=DELETE
|
|
COMMIT
|
|
PRAGMA journal_mode=DELETE
|
|
|
|
PRAGMA locking_mode = exclusive;
|
|
CREATE TABLE tx(a);
|
|
PRAGMA journal_mode = off;
|
|
|