0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-12 15:33:44 +00:00
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

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

20 lines
327 B
Plaintext

CREATE VIRTUAL TABLE t0 USING fts3(x);
SELECT rowid FROM t0 WHERE x MATCH '';
SELECT rowid FROM t0 WHERE x MATCH '""';
SELECT rowid FROM t0 WHERE x MATCH '"" ""';
SELECT rowid FROM t0 WHERE x MATCH '"" OR ""';
SELECT rowid FROM t0 WHERE x MATCH '"" NOT ""';
SELECT rowid FROM t0 WHERE x MATCH '""""';