don't evaluate subqueries during statement prepare, even if they
are not correlated.
With post-review fixes.