mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 09:49:40 +00:00
7 lines
196 B
Plaintext
7 lines
196 B
Plaintext
|
|
CREATE TABLE t1(a INT, b INT);
|
|
INSERT INTO t1(a,b) VALUES(1,null),(null,null),(1,null);
|
|
CREATE UNIQUE INDEX t1b ON t1(abs(b));
|
|
SELECT quote(a), quote(b), '|' FROM t1 GROUP BY a, abs(b);
|
|
|