mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
46 lines
1.1 KiB
Plaintext
46 lines
1.1 KiB
Plaintext
|
|
CREATE TABLE t1(a,b,c,d);
|
|
CREATE INDEX t1abc ON t1(a,b,c);
|
|
CREATE INDEX t1bc ON t1(b,c);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d);
|
|
CREATE INDEX t1bc ON t1(b,c);
|
|
CREATE INDEX t1abc ON t1(a,b,c);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1(a,b,c,d,e);
|
|
CREATE INDEX t1abcd ON t1(a,b,c,d);
|
|
CREATE INDEX t1cd ON t1(c,d);
|
|
CREATE INDEX t1bcd ON t1(b,c,d);
|