mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
19 lines
358 B
Plaintext
19 lines
358 B
Plaintext
|
|
CREATE TABLE t1(a, b);
|
|
CREATE INDEX t1a ON t1(a);
|
|
CREATE INDEX t1b ON t1(b);
|
|
PRAGMA journal_mode = wal;
|
|
|
|
WITH ii(i) AS ( VALUES(1) UNION ALL SELECT i+1 FROM ii WHERE i<1000 )
|
|
INSERT INTO t1 SELECT i, i FROM ii;
|
|
|
|
|
|
CREATE TEMP TABLE z1(a, b);
|
|
INSERT INTO z1 SELECT * FROM t1;
|
|
|
|
|
|
SELECT count(*) FROM t1
|
|
UNION ALL
|
|
SELECT count(*) FROM z1
|
|
|