On 12 Nov 2013, at 9:41pm, Igor Korot <[email protected]> wrote:

> I don't see what is wrong. It should be using foreign key constraints
> on the last two searches, but it looks like it does not.

Did you actually create the indexes which would be useful for those 
constraints, or did you just specify the constraints ?

<http://www.sqlite.org/foreignkeys.html#fk_indexes>

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to