mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
69 lines
1.3 KiB
Plaintext
69 lines
1.3 KiB
Plaintext
|
|
SELECT * FROM t1;
|
|
|
|
|
|
PRAGMA auto_vacuum = off;
|
|
VACUUM;
|
|
|
|
|
|
CREATE TABLE t2(x, y);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
|
|
INSERT INTO t2(x, y) SELECT x, randomblob(1000) FROM c;
|
|
DROP TABLE t2;
|
|
PRAGMA page_count;
|
|
|
|
|
|
VACUUM;
|
|
PRAGMA page_count;
|
|
|
|
|
|
CREATE TABLE t3(x, y);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<400)
|
|
INSERT INTO t3(x, y) SELECT x, randomblob(1000) FROM c;
|
|
PRAGMA quick_check;
|
|
|
|
|
|
CREATE TABLE t3(x, y);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<400)
|
|
INSERT INTO t3(x, y) SELECT x, randomblob(1000) FROM c;
|
|
PRAGMA quick_check;
|
|
|
|
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
CREATE TABLE t4(a,b);
|
|
INSERT INTO t4 VALUES('hello','world!');
|
|
PRAGMA integrity_check;
|
|
SELECT * FROM t4;
|
|
|
|
|
|
PRAGMA journal_mode=TRUNCATE;
|
|
PRAGMA journal_mode=OFF;
|
|
PRAGMA journal_mode=DELETE;
|
|
PRAGMA journal_mode=WAL;
|
|
PRAGMA journal_mode=PERSIST;
|
|
PRAGMA journal_mode=MEMORY;
|
|
PRAGMA journal_mode=OFF;
|
|
PRAGMA journal_mode=DELETE;
|
|
|
|
|
|
CREATE TABLE t1(a, b);
|
|
PRAGMA schema_version = 0;
|
|
|
|
|
|
PRAGMA auto_vacuum = 0;
|
|
PRAGMA page_size = 8192;
|
|
PRAGMA journal_mode = wal;
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
CREATE TABLE t2(x, y);
|
|
|
|
|
|
SELECT * FROM t1
|
|
|
|
|
|
INSERT INTO t1 VALUES(3, 4);
|
|
SELECT * FROM t1;
|
|
|