Fix a performance regression in the query planner associated with rearranging the order of FROM clause terms in the presences of a LEFT JOIN.

Apply fixes for CVE-2022-35737 and other minor problems discovered by internal testing.