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.