Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Critical
 - 
    Resolution: Fixed
 - 
    6.2.3
 - 
    None
 - 
    None
 
- 
        2021-17
 
Description
In a simple query like:
MariaDB [(none)]> sELECT 'AAA' MONDO, ri_mo_id OTHIS_RIMOID, MODA(ri_prezzo) OTHISPRMODA, COUNT(DISTINCT ri_id) OTHISNRI FROM dms_dg_ita_4570.rilevazione WHERE ri_data BETWEEN "2021-09-10" AND "2021-09-17" AND ri_in_id !=3 AND ri_prezzo IS NOT NULL GROUP BY MONDO, OTHIS_RIMOID;
results in a error:
ERROR 1815 (HY000): Internal error: TupleAnnexStep::executeNoOrderBy() IDB-2035: An internal error occurred.  Check the error log file & contact support.
Customer cant go ahead
Issue appears to be related to the alias defined on a constant and then the alias is used for the GROUP BY,