0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 19:09:41 +00:00
libsql/libsql-wal/tests/assets/fixtures/tkt-385a5b56b9.test
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00:00

15 lines
340 B
Plaintext

CREATE TABLE t1(x, y);
INSERT INTO t1 VALUES(1, NULL);
INSERT INTO t1 VALUES(2, NULL);
INSERT INTO t1 VALUES(1, NULL);
SELECT DISTINCT x, y FROM t1 ;
CREATE UNIQUE INDEX i1 ON t1(x, y) ;
SELECT DISTINCT x, y FROM t1 ;
CREATE TABLE t2(x, y NOT NULL);
CREATE UNIQUE INDEX t2x ON t2(x);
CREATE UNIQUE INDEX t2y ON t2(y);