mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 07:29:41 +00:00
18 lines
391 B
Plaintext
18 lines
391 B
Plaintext
|
|
PRAGMA automatic_index = 0;
|
|
CREATE TABLE t1(a, x);
|
|
CREATE TABLE t2(b, y);
|
|
WITH s(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<100
|
|
)
|
|
INSERT INTO t1 SELECT (i%50), NULL FROM s;
|
|
WITH s(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<100
|
|
)
|
|
INSERT INTO t2 SELECT (CASE WHEN i<95 THEN 44 ELSE i END), NULL FROM s;
|
|
|
|
|
|
CREATE INDEX t2b ON t2(b);
|
|
ANALYZE;
|
|
|