[MCOL-1747] Case and Bit_or in same query caused error Created: 2018-09-24  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.1.5, 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: kain Assignee: Unassigned
Resolution: Won't Do Votes: 1
Labels: None
Environment:

Debian 9



 Description   

When running a query with

1. Group by based on a subquery + bit_or
2. Case when or IF()

It causes the error: Error Code: 1815. Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support.

Errorlog: Calpont[126444]: 58.965545 |0|0|0| E 00 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/utils/rowgroup/rowgroup.h@814: assertion '0' failed

When removing the case when part or the bit_or, the query is working

simplified query:

select grouped_column,
case when count(distinct not_grouped_column1) = 1 then
min(not_grouped_column1)
else
count(distinct not_grouped_column1)*-1
end as not_grouped_column1,
bit_or(not_grouped_column2 )
from ( select grouped_column,not_grouped_column,not_grouped_column2 from....) subQuery

group by grouped_column



 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:31:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.