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,
>
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
2 matches
Mail list logo