mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
30 lines
819 B
Plaintext
30 lines
819 B
Plaintext
|
|
CREATE TABLE t1(i INTEGER PRIMARY KEY, a, b INTEGER);
|
|
|
|
INSERT INTO t1 VALUES(1, 1, 1);
|
|
INSERT INTO t1 VALUES(2, 1, 1);
|
|
INSERT INTO t1 VALUES(3, 1, 2);
|
|
INSERT INTO t1 VALUES(4, 1, 2);
|
|
INSERT INTO t1 VALUES(5, 1, 2);
|
|
INSERT INTO t1 VALUES(6, 1, 3);
|
|
INSERT INTO t1 VALUES(7, 1, 3);
|
|
|
|
INSERT INTO t1 VALUES(8, 2, 1);
|
|
INSERT INTO t1 VALUES(9, 2, 1);
|
|
INSERT INTO t1 VALUES(10, 2, 2);
|
|
INSERT INTO t1 VALUES(11, 2, 2);
|
|
INSERT INTO t1 VALUES(12, 2, 2);
|
|
INSERT INTO t1 VALUES(13, 2, 3);
|
|
INSERT INTO t1 VALUES(14, 2, 3);
|
|
|
|
INSERT INTO t1 VALUES(15, 2, 1);
|
|
INSERT INTO t1 VALUES(16, 2, 1);
|
|
INSERT INTO t1 VALUES(17, 2, 2);
|
|
INSERT INTO t1 VALUES(18, 2, 2);
|
|
INSERT INTO t1 VALUES(19, 2, 2);
|
|
INSERT INTO t1 VALUES(20, 2, 3);
|
|
INSERT INTO t1 VALUES(21, 2, 3);
|
|
|
|
CREATE INDEX i1 ON t1(a, b);
|
|
|