Fix the alias partition detecting problem. Add the support for promoting sp info from subquery to parent level