handle view resolution when the schema is not defined in SELECT stmt

handle view resolution when the schema is not defined in SELECT stmt #11974