mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-12 20:59:34 +00:00
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 '""""';
|
|
|