Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5386

Bitwise aggregation functions do not work with wide decimals (internal error)

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • 2025-3

    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.

      Attachments

        Activity

          People

            drrtuy Roman
            sergey.zefirov Sergey Zefirov
            Roman Roman
            Aleksei Bukhalov Aleksei Bukhalov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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