Fix Bug in Push-Down Predicate Optimization Leading to Incorrect Results

Fix complicated bug in push-down predicate optimization which leads to wrong results. This fixes a lot of issues on push-down predicate optimization. #8503 (Winter Zhang)