Re: [sqlite] MATCH with punctuation in parenthesis causing error

[Dan Kennedy]

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

Re: [sqlite] MATCH with punctuation in parenthesis causing error

[David de Regt]

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

Re: [sqlite] MATCH with punctuation in parenthesis causing error

[Kevin Benson]

On Mon, Nov 4, 2013 at 1:38 AM, David de Regt  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] MATCH with punctuation in parenthesis causing error

[David de Regt]

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