On Mon, Nov 4, 2013 at 1:38 AM, David de Regt <dav...@mylollc.com> wrote:
> I've worked around this issue a separate way, but I'd like to understand > what went wrong in the first place here. I have an FTS3 table, and if I > query with the following: > > SELECT * FROM table WHERE keywords MATCH '(blah!)' > > I get the following error: > malformed MATCH expression:_[(blah!)] > > If I remove either the parenthesis or the exclamation point, or add quotes > around the parenthesis, the error disappears. I've read over all of the > FTS docs and I don't see any reason why it shouldn't work (though it should > ignore it with the default tokenizer -- but if I have a custom tokenizer, > it should support the !, in theory). Any ideas? > > Thanks! > -David > I believe (for backward compatibility reasons) the SQLITE_ENABLE_FTS3_PARENTHESIS option comes into your considerations as described in Compiling and Enabling FTS3 and FTS4 at: http://www.sqlite.org/fts3.html#section_2 2 -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users