Fix Partition Pruning Issue for Constant Comparisons in WHERE Clause

Fix partition pruning in case of comparison with constant in WHERE. If column and constant had different types, overflow was possible. Query could return an incorrect empty result. This fixes #35304. #35334 (Amos Bird).