0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-12 13:59:27 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/temptable3.test
2024-05-27 12:59:10 +02:00

20 lines
423 B
Plaintext

PRAGMA cache_size = 1;
PRAGMA page_size = 1024;
PRAGMA auto_vacuum = 2;
CREATE TABLE t1(x);
INSERT INTO t1 VALUES( randomblob(800) );
INSERT INTO t1 VALUES( randomblob(800) );
CREATE TABLE t2(x);
PRAGMA integrity_check;
PRAGMA cache_size = 1;
PRAGMA auto_vacuum = 2;
CREATE TABLE t1(x);
CREATE TABLE t2(x UNIQUE);
INSERT INTO t2 VALUES(1), (2), (3);
DROP TABLE t1;
PRAGMA integrity_check;