Re: [sqlite] unable to use function MATCH in requested context

[E. Timothy Uy]

In fact, it does not work in a nested query - the issue is actually
multiple inner joins. When I LEFT JOIN the rest of the tables, it works
fine. This must have been a change in the last year or so.


On Tue, Dec 31, 2013 at 3:15 PM, E. Timothy Uy  wrote:

> Hi, as a sanity check, did something change in the use of MATCH with JOINs?
>
> I used to do
>
> SELECT ...
> FROM Entries e
> INNER JOIN Combos c ON e.Entries MATCH c.combo
> INNER JOIN Entries_content ec ON ec.docid = e.docid
>
> but now I get "unable to use function MATCH in the requested context". I
> can pull it off in a nested query with the MATCH by itself, but I feel like
> this totally used to work. Here Entries is an FTS3 table and
> Entries_content is associated content.
>
> Thank you in advance.
>
> Respectfully
> Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] unable to use function MATCH in requested context

[E. Timothy Uy]

Hi, as a sanity check, did something change in the use of MATCH with JOINs?

I used to do

SELECT ...
FROM Entries e
INNER JOIN Combos c ON e.Entries MATCH c.combo
INNER JOIN Entries_content ec ON ec.docid = e.docid

but now I get "unable to use function MATCH in the requested context". I
can pull it off in a nested query with the MATCH by itself, but I feel like
this totally used to work. Here Entries is an FTS3 table and
Entries_content is associated content.

Thank you in advance.

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