Hello!
В сообщении от Wednesday 06 August 2008 17:42:19 Alexandre Courbot написал(а):
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
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