Hello everybody, Using sqlite 3.6.0 with fts3 enabled:
create table indexes(docid int); create virtual table texts using fts3(reading); insert into texts values("text1"); insert into indexes values(last_insert_rowid()); select * from indexes join texts on texts.docid == indexes.docid where texts.reading match "text1"; Last line outputs: SQL error: unable to use function MATCH in the requested context I first noticed that behavior in a much larger query with plenty of joins. Reordering them gives me a query that works. Is there any reason for this? I don't know sqlite enough to affirm this is a bug, but this looks suspicious to me. Shall I fill in a trac ticket? Alex. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users