Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02.3
-
None
-
RHEL 8 , MDB 10.6.9 CS 6.4.3
-
2024-1
Description
Trying to use a view on the relational test database of EBI-711 crashes with MariaDB 10.6 (EBI05) , when the "OrderRow" table is a columnstore table:
Error Code: 1815. Internal error: MCS-2021: 'OrderID' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause.
If the view is created from InnoDB tables only, everything works as expected.
Steps to reproduce (see attached):
execute EBI-713_simple_bug_exposal.sql
execute EBI-711_SampleData_relational.sql
execute EBI-713_yet_another_CS_bug.sql
TODO:
simplify bug exposal as much as possible ==> DONE.
test MariaDB 10.5 ==> UPDATE: bug exposed also on 10.5.
UPDATE: the reason for the bug is the ORDER BY in the view definition. See the simple_bug_exposal file
Additional note:
on MariaDB 10.3, the bug couldn't be exposed, because when trying to create the orderrow_CS table via a "create table ... select" crashes with the error:
EBI01 MariaDB 10.3: Error Code: 1178. The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
This error also occurs when the used "decimal" column is NOT part of the create table / select, see the attached SQL EBI-713_yet_another_CS_bug.sql.
create view Columnstore with group by is a workaround but not a valid solution for us.
Attachments
Issue Links
- is blocked by
-
MCOL-4234 ORDER BY clause if not included in the GROUP BY clause fails
-
- Closed
-