On 7/29/21 10:40 AM, He Jingxuan wrote: > Any updates on these bugs? If James agrees, I suggest to remove all of the cost based optimizer code (which would fix both of the current issues), because:
- CBO violates POSIX regarding strict the left-to-right processing rule. - Apparently no one ever measured whether this optimization really has any benefit, i.e., positive (or negative?) effect on performance. - CBO code is hard to maintain; ~1200-1500 lines of code could be removed. - Removing CBO would also solve a couple of other open issue we have in our bug tracker. @James: do you agree? Maybe we could work together on this ... as you have the better insight. Have a nice day, Berny