panbingkun
panbingkun
Wait, I'm checking the cause of UT failure
> Wait, I'm checking the cause of UT failure Done
> I'm wondering why `PushProjectThroughLimit` does not optimize your query. It should push project through limit. Actually, it can complete the above optimization, and pass all GAs Maybe worried`PushProjectThroughLimit` this...
> PushProjectThroughLimit Hmm..., `PushProjectThroughLimit` was added in my first version of pr.
> Ah sorry I misread the code. Let's add this rule then. I think it's beneficial, as it kinds of "normalize" the order of project and limit operator, so that...
> thanks, merging to master! should we backport the changes to branch-3.3 ? @cloud-fan
> This is a perf improvement, usually we don't backport. Okay！
> We have an optimizer rule `UnwrapCastInBinaryComparison`, does it solve your problem? And can you give some code pointers to explain why we have inconsistency between data and partition filters...
> UnwrapCastInBinaryComparison I will try with UnwrapCastInBinaryComparison