[MCOL-5386] Bitwise aggregation functions do not work with wide decimals (internal error) - Jira

XML

Word

Printable

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.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.