mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-15 21:15:19 +00:00
12 lines
235 B
Plaintext
12 lines
235 B
Plaintext
|
|
PRAGMA journal_mode = memory;
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE);
|
|
|
|
|
|
BEGIN;
|
|
WITH s(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<$nRow
|
|
)
|
|
INSERT INTO t1 SELECT NULL, randomblob(700) FROM s;
|
|
|