It's hard to accept this conclusion... it seems like a simple justification.
If you say so, why is "select from v order by id" not doing a sort (with
the data from view)?
Obviously it "sees" the id is the primary key and uses it for sorting.
I read here lots of messages about complex query optimizations, and
there is a whole chapter about this here:
http://www.sqlite.org/optoverview.html#flattening
I will obviously handle this somehow, but I hoped it was either a slip
or would be relatively simple to implement.
I have the feeling (at least for this case) that a simple rule (for the
optimizer) is, only the last sort should be honored.
That means, ignore the sort from the view; and because this case seems
to be correctly handled....
Regards,
Gabriel
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
