v.23.10Bug Fix

Fix missing scalar issue in subqueries for table functions

Fix missing scalar issue when evaluating subqueries inside table functions #56057 (Amos Bird).