[yunqa.de] Re: DiSqlite FTS: how to query using MATCH and rowid?
- From: Edwin Yip <edwin.yip@xxxxxxxxxxxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Wed, 3 Mar 2010 13:06:40 +0800
Hi Ralf,
With version 1.6.1 the FTS select statement does not return matching lines
when the search criteria contains column prefix, for example:
select rowid from MyFTSTable where (MyFTSTable MATCH 'title:bbb')
But no problem if the criteria does not contain column prefix or executing
the SQL in the latest version of SqliteSpy.
Are you sure this has been fixed in the latest version of DiSqlite3?
On Fri, Feb 26, 2010 at 1:56 AM, Delphi Inspiration <delphi@xxxxxxxx> wrote:
> At 16:36 25.02.2010, Edwin Yip wrote:
>
> >This trick worked. Any possible side effect?
>
> None. It just tricks the optimizer away from an invalid over-optimization.
>
> >BTW, can you list the FTS3 improvements since v1.6.1? Thank you..
>
> Some of the recent FTS3 improvements include:
>
> * Bug fixes, including wrong and missing matches.
> * Stability and error handling improvements.
> * snippets() should return more relevant results.
> * New matchinfo() function to provide details of a match that may be used
> for result ranking and other purposes (yet undocumented).
> * New optional parenthesis query syntax (disabled in DISQLite3 for
> backwards compatibility, requires recompile to enable).
>
> Ralf
>
> _______________________________________________
> Delphi Inspiration mailing list
> yunqa@xxxxxxxxxxxxx
> //www.freelists.org/list/yunqa
>
>
>
>
--
Best Regards,
Edwin Yip
Mind Mapping is as Effortless as Typing
http://www.InnovationGear.com
Other related posts:
