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
-
-
- Closed
-
Activity
| 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: bux 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. |
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. |
I tagged this as a duplicate of MCOL-4234, but it isn't quite. It's probable that the fix is the same, but both ways to the problem must be tested.
| Summary | MariaDB Columnstore with views: reading a CS table via a view using "count" crashes when the view has "order by" in definition | Reading a CS table via a view using "count" errors when the view has "order by" in definition |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Rank | Ranked higher |
| Rank | Ranked lower |
| Rank | Ranked higher |
| Fix Version/s | Icebox [ 22302 ] |
| Affects Version/s | 23.02.3 [ 28901 ] |
| Summary | Reading a CS table via a view using "count" errors when the view has "order by" in definition | Reading a CS table via a view using "count" crashes when the view has "order by" in definition |
| Summary | Reading a CS table via a view using "count" crashes when the view has "order by" in definition | Reading a Columnstore table via a view using "count" crashes when the view has "order by" in definition |
| Assignee | Sergey Zefirov [ JIRAUSER47362 ] |
| Fix Version/s | 23.10 [ 28540 ] | |
| Fix Version/s | Icebox [ 22302 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Sprint | 2024-1 [ 755 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Zendesk Related Tickets | 201991 |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 23.10.3 [ 29862 ] | |
| Fix Version/s | 23.10 [ 28540 ] |
create view Columnstore with group by is a workaround but not a valid solution for us.