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,