mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
30 lines
719 B
Plaintext
30 lines
719 B
Plaintext
|
|
CREATE TABLE t1(a, b);
|
|
CREATE TABLE t2(a, b);
|
|
CREATE TABLE t3(b COLLATE nocase);
|
|
|
|
INSERT INTO t1 VALUES(2, 'B');
|
|
INSERT INTO t1 VALUES(1, 'A');
|
|
INSERT INTO t1 VALUES(4, 'D');
|
|
INSERT INTO t1 VALUES(NULL, NULL);
|
|
INSERT INTO t1 VALUES(3, NULL);
|
|
|
|
INSERT INTO t2 VALUES(1, 'A');
|
|
INSERT INTO t2 VALUES(2, NULL);
|
|
INSERT INTO t2 VALUES(5, 'E');
|
|
INSERT INTO t2 VALUES(NULL, NULL);
|
|
INSERT INTO t2 VALUES(3, 'C');
|
|
|
|
INSERT INTO t3 VALUES('a');
|
|
INSERT INTO t3 VALUES('c');
|
|
INSERT INTO t3 VALUES('b');
|
|
|
|
|
|
CREATE TABLE t4(x TEXT COLLATE nocase);
|
|
CREATE TABLE t5(y INTEGER, z TEXT COLLATE binary);
|
|
|
|
INSERT INTO t4 VALUES('2.0');
|
|
INSERT INTO t4 VALUES('TWO');
|
|
INSERT INTO t5 VALUES(2, 'two');
|
|
|