On 11/04/2013 01:58 PM, David de Regt wrote:
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.
It's a bug I think. Thanks for reporting it. Now
fixed here:
http://www.sqlite.org/src/info/49be646cd9
Dan.
-----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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
