mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
21 lines
351 B
Plaintext
21 lines
351 B
Plaintext
|
|
CREATE TABLE t1(a, b COLLATE nocase, PRIMARY KEY(a, a, b)) WITHOUT ROWID;
|
|
|
|
|
|
CREATE TABLE t2(a, b, PRIMARY KEY(a COLLATE nocase, a)) WITHOUT ROWID;
|
|
|
|
|
|
INSERT INTO t2 VALUES(1, 'one');
|
|
SELECT b FROM t2;
|
|
|
|
|
|
PRAGMA index_info(t2);
|
|
|
|
|
|
PRAGMA index_xinfo(t2);
|
|
|
|
|
|
CREATE TABLE t3(a, b, PRIMARY KEY(a COLLATE nocase, a));
|
|
PRAGMA index_info(t3);
|
|
|