Add unit tests for scalar subquery.