mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-06-06 11:01:52 +00:00
14 lines
384 B
Plaintext
14 lines
384 B
Plaintext
|
|
||
|
|
CREATE TABLE t1(a, b);
|
||
|
|
CREATE INDEX i1 ON t1(a);
|
||
|
|
INSERT INTO t1 VALUES(1, 'xxx');
|
||
|
|
INSERT INTO t1 SELECT a+1, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+2, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+4, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+8, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+16, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+32, b FROM t1;
|
||
|
|
INSERT INTO t1 SELECT a+64, b FROM t1;
|
||
|
|
ANALYZE;
|
||
|
|
|