v.25.6Bug Fix (user-visible misbehavior in an official stable release)

Make scalar correlated subqueries return a nullable

Make scalar correlated subqueries return a nullable result of the projection expression. Fix the case when a correlated subquery produces an empty result set. #81632 (Dmitry Novik).