mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
42 lines
1.0 KiB
Plaintext
42 lines
1.0 KiB
Plaintext
|
|
PRAGMA page_size=1024;
|
|
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
|
|
INSERT INTO t1 VALUES(1, 'one');
|
|
INSERT INTO t1 VALUES(2, 'two');
|
|
|
|
CREATE TABLE t2(x);
|
|
INSERT INTO t2 VALUES(randomblob(200));
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
INSERT INTO t2 SELECT randomblob(200) FROM t2;
|
|
|
|
|
|
PRAGMA auto_vacuum=0;
|
|
PRAGMA page_size=1024;
|
|
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
|
|
INSERT INTO t1 VALUES(1, 'one');
|
|
INSERT INTO t1 VALUES(2, 'two');
|
|
|
|
CREATE TABLE t3(x);
|
|
|
|
CREATE TABLE t2(x PRIMARY KEY) WITHOUT ROWID;
|
|
INSERT INTO t2 VALUES(randomblob(100));
|
|
|
|
DROP TABLE t3;
|
|
|
|
|
|
PRAGMA page_size=1024;
|
|
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
|
|
INSERT INTO t1 VALUES(1, 'one');
|
|
INSERT INTO t1 VALUES(2, 'two');
|
|
|
|
CREATE TABLE t2(c INTEGER PRAGMA KEY, d);
|
|
INSERT INTO t2 VALUES(1, randomblob(1100));
|
|
|