[MCOL-5386] Bitwise aggregation functions do not work with wide decimals (internal error) Created: 2023-01-10  Updated: 2023-02-01

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Sergey Zefirov Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

The code:

use test;
 
drop table if exists t;
 
create table t(c decimal(19));
 
insert into t(c) values (-2);
 
select bit_or(c) from t;
 
drop table if exists t;
 
create table t(c decimal(19)) engine=columnstore;
 
insert into t(c) values (-2);
 
select bit_or(c) from t;

First SELECT from InnoDB returns some big number (0xfffffffffffffffe) and second SELECT from Columnstore produces internal error exception.
Generated at Thu Feb 08 02:57:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.