On Fri, Aug 15, 2008 at 9:13 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: >> I would like to generate Snippets from MATCHes in two columns, >> however, I get the following error: "unable to use function MATCH in >> the requested context" with the following query -- > > I think you ran into the same problem as I did: > > http://www.nabble.com/Fts3-and-JOIN-sometimes-results-in-inability-to-use-MATCH-operator-td18851478.html > > Unfortunately there is no solution right now. I've discussed that on > the development mailing list as well where I have been confirmed this > is a bug. I have also opened a trac ticket about it: > > http://www.sqlite.org/cvstrac/tktview?tn=3281,3 > > There is a workaround, which is to used nested queries instead of > joins (i.e. "where x in (select ...)" instead of "join"). I've met the > Snippet function for the first time in your mail and failed to find > any documentation about (mind to give me a pointer here? it looks > interesting) so I cannot convert your example query but I'm confident > it can be fixed this way.
http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex The above is the only location known to me where Snippet is documented (other than inside the source code files perhaps). > > Alex. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
