0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-09-18 21:39:44 +00:00
Files
libsql/libsql-wal/tests/assets/fixtures/where8.test

7 lines
247 B
Plaintext
Raw Permalink Normal View History

CREATE TABLE t600(a PRIMARY KEY, b) WITHOUT rowid;
CREATE INDEX t600b ON t600(b);
INSERT INTO t600 VALUES('state','screen'),('exact','dolphin'),('green','mercury');
SELECT a, b, '|' FROM t600 WHERE a=='state' OR b='mercury' ORDER BY +a;