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 <t...@loqu8.com> 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