Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
22.08.7
-
None
-
2022-23
Description
The mentioned GROUP BY pushdown proved to be error-prone, e.g. its execution starts after optimize phase so MDB optimizer might has rewritten JOIN conditions dropping some of them. The optimized conditions forces the query to error-out. Moreover this pushdown method are rarely called b/c it is the last in the precedence of pushdown methods available:
- select handler
- derived handler
- group by handler
- table scan with conditions
Deactivation of GBH might implicitly affects the variety of queries that MCS can process so at least full test001 should be run with the patch.
4QA regression tests must pass.