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

Full support for DECIMAL(65, 38) in ColumnStore

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 22.08.8
    • Icebox
    • None
    • None

    Description

      The maximum supported precision for DECIMAL data type in ColumnStore is currently 38 digits (this was accomplished in MCOL-641 where the DECIMAL precision was increased from 18 to 38 digits). However, MariaDB server supports upto 65 digits of precision. For parity with the server, ColumnStore should also support the maximum allowable digits to 65 and 38 for precision and scale respectively.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5215 UNION on DECIMAL returns incorrect results

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            tntnatbry Gagan Goel (Inactive) added a comment -

            Once this is fixed, we need to remove the following error currently thrown to users:

            ERROR 42000: The storage engine for the table doesn't support MCS-2060: Union operation exceeds maximum DECIMAL precision of 38.

            tntnatbry Gagan Goel (Inactive) added a comment - Once this is fixed, we need to remove the following error currently thrown to users: ERROR 42000: The storage engine for the table doesn't support MCS-2060: Union operation exceeds maximum DECIMAL precision of 38.
            tntnatbry Gagan Goel (Inactive) added a comment -

            Ref file for the legacy regression test001 test case: working_tpch1_compareLogOnly/misc/sumavgoverflow.sql also needs to be updated, once this is fixed.

            tntnatbry Gagan Goel (Inactive) added a comment - Ref file for the legacy regression test001 test case: working_tpch1_compareLogOnly/misc/sumavgoverflow.sql also needs to be updated, once this is fixed.

            People

              allen.herrera Allen Herrera
              tntnatbry Gagan Goel (Inactive)
              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.