mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
ad79ef48a2
* add tests * add bench
20 lines
327 B
Plaintext
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 '""""';
|
|
|