Re: [sqlite] FTS3 - operator

[Mike Marshall]

Thanks Dan, didn't realize that NOT completely replaced -, thought you could
use them side by side.

All OK now

Mike

> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Dan
> Sent: 21 January 2009 17:14
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] FTS3 - operator
> 
> 
> On Jan 21, 2009, at 11:43 PM, Mike Marshall wrote:
> 
> > Hi all
> >
> >
> >
> > Quick question
> >
> >
> >
> > Should the - operator work in FTS in conjunction with the phrase
> > operator
> >
> >
> >
> > i.e. router -"ip address"
> > sqlite3_step returns SQLITE_ERROR which leads me to believe its
> > invalid but
> > the question is should it be invalid, it seems a perfectly valid use
> > of the
> > syntax to me.
> 
> Hi,
> 
> I don't think that has ever worked. The documentation has:
> 
>A token that is not part of a quoted phrase may be preceded by a '-'
>character, which indicates that matching rows must not contain the
>specified term.
> 
> See here for more:
> 
>http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/
> README.syntax
> 
> Also, new versions of Fts3 support two different syntaxes. The legacy
> syntax that is enabled by default and the enhanced syntax that is
> enabled by defining SQLITE_ENABLE_FTS3_PARENTHESIS at compile time.
> 
> The enhanced syntax does not support the '-' operator at all. Instead,
> it uses the binary operator NOT. When using the enhanced syntax, you
> can do:
> 
> MATCH 'router NOT "ip address"'
> 
> and things will work as expected.
> 
> Dan.
> 
> 
> 
> 
> >
> >
> >
> >
> > My code is
> >
> >
> >
> > sqlite3_stmt* pStatement;
> >
> > char* acSQLQuery = sqlite3_mprintf("SELECT * FROM data WHERE story
> > MATCH
> > '%q'",acQuery);
> >
> > nRet = sqlite3_prepare_v2(pDB,acSQLQuery,-1,&pStatement,0);
> >
> > nRet = sqlite3_step(pStatement);
> >
> >
> >
> > Thanks for any help or pointers, or even just letting me know it's a
> > bug so
> > I can raise a ticket.
> >
> >
> >
> > Mike
> >
> >
> >
> >
> >
> > ___
> > 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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS3 - operator

[Dan]

On Jan 21, 2009, at 11:43 PM, Mike Marshall wrote:

> Hi all
>
>
>
> Quick question
>
>
>
> Should the - operator work in FTS in conjunction with the phrase  
> operator
>
>
>
> i.e. router -"ip address"
> sqlite3_step returns SQLITE_ERROR which leads me to believe its  
> invalid but
> the question is should it be invalid, it seems a perfectly valid use  
> of the
> syntax to me.

Hi,

I don't think that has ever worked. The documentation has:

   A token that is not part of a quoted phrase may be preceded by a '-'
   character, which indicates that matching rows must not contain the
   specified term.

See here for more:

   http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/ 
README.syntax

Also, new versions of Fts3 support two different syntaxes. The legacy
syntax that is enabled by default and the enhanced syntax that is
enabled by defining SQLITE_ENABLE_FTS3_PARENTHESIS at compile time.

The enhanced syntax does not support the '-' operator at all. Instead,
it uses the binary operator NOT. When using the enhanced syntax, you
can do:

MATCH 'router NOT "ip address"'

and things will work as expected.

Dan.




>
>
>
>
> My code is
>
>
>
> sqlite3_stmt* pStatement;
>
> char* acSQLQuery = sqlite3_mprintf("SELECT * FROM data WHERE story  
> MATCH
> '%q'",acQuery);
>
> nRet = sqlite3_prepare_v2(pDB,acSQLQuery,-1,&pStatement,0);
>
> nRet = sqlite3_step(pStatement);
>
>
>
> Thanks for any help or pointers, or even just letting me know it's a  
> bug so
> I can raise a ticket.
>
>
>
> Mike
>
>
>
>
>
> ___
> 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

[sqlite] FTS3 - operator

[Mike Marshall]

Hi all

 

Quick question

 

Should the - operator work in FTS in conjunction with the phrase operator

 

i.e. router -"ip address"

 

sqlite3_step returns SQLITE_ERROR which leads me to believe its invalid but
the question is should it be invalid, it seems a perfectly valid use of the
syntax to me.

 

My code is 

 

sqlite3_stmt* pStatement;

char* acSQLQuery = sqlite3_mprintf("SELECT * FROM data WHERE story MATCH
'%q'",acQuery);

nRet = sqlite3_prepare_v2(pDB,acSQLQuery,-1,&pStatement,0);

nRet = sqlite3_step(pStatement);

 

Thanks for any help or pointers, or even just letting me know it's a bug so
I can raise a ticket.

 

Mike

 

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users