I realize that the query is being parsed with the enhanced query syntax since I added parenthesis (and have that compile flag enabled), but why does the exclamation point at the end cause an error? It seems like it should be just ignored, given the default tokenizer.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kevin Benson Sent: Sunday, November 3, 2013 10:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MATCH with punctuation in parenthesis causing error 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users