mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
14 lines
317 B
Plaintext
14 lines
317 B
Plaintext
|
|
PRAGMA journal_mode = WAL;
|
|
CREATE TABLE t1(x);
|
|
CREATE INDEX i1 ON t1(x);
|
|
|
|
|
|
PRAGMA page_size=512;
|
|
PRAGMA journal_mode=WAL;
|
|
CREATE TABLE t1(a,b);
|
|
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<8200)
|
|
INSERT INTO t1(a,b) SELECT x, zeroblob(300) FROM c;
|
|
PRAGMA integrity_check;
|
|
|