An unmatched double-quote the right-hand argument to MATCH causes an error in FTS3. Example:
CREATE VIRTUAL TABLE t1 USING fts3(x);
INSERT INTO t1 VALUES('abc"def"123');
SELECT * FROM t1 WHERE t1 MATCH '"*';
The SELECT statement above returns: "malformed MATCH expression: ["*].
Can this feature be supported in the future?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
