When running a correlated subquery (a.k.a. type-II nested qu…