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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users