> I believe it reevaluates the subquery for each row of the outer...

No. See <http://www.sqlite.org/omitted.html>.

Regards

Reply via email to