mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-06-14 13:32:58 +00:00
11 lines
253 B
Plaintext
11 lines
253 B
Plaintext
|
|
||
|
|
PRAGMA cache_size = 10;
|
||
|
|
CREATE TABLE t1(a, b);
|
||
|
|
INSERT INTO t1 VALUES(1, randomblob(400));
|
||
|
|
PRAGMA journal_mode = wal;
|
||
|
|
WITH s(i) AS (
|
||
|
|
SELECT 2 UNION ALL SELECT i+1 FROM s WHERE i<100
|
||
|
|
)
|
||
|
|
INSERT INTO t1 SELECT i, randomblob(400) FROM s;
|
||
|
|
|