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

The max values for Decimal data type is 18, how can store more bigger

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.1.2
    • Fix Version/s: Icebox
    • Component/s: MariaDB Server
    • Labels:
      None
    • Environment:
      CentOS 6.5+ MariaDB ColumnStore 1.1.2

      Description

      MariaDB [dba_info]> CREATE TABLE tb_test
      -> (
      -> id BIGINT ,
      -> amount DECIMAL(36, 18) NULL,
      -> create_time INT NULL
      -> )
      -> ENGINE = columnstore;
      ERROR 1815 (HY000): Internal error: CAL0009: (3)Create table failed due to Syntax error: The maximum precision (total number of digits) that can be specified is 18

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              xinglong chenxinglong
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: