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

DECIMAL does not support full range of values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • Icebox
    • DDLProc
    • None

    Description

      https://mariadb.com/kb/en/mariadb/decimal/

      create table fact (
      i1 tinyint,
      i2 smallint,
      – i3 mediumint,
      i4 int,
      i8 bigint,
      i1u tinyint unsigned,
      i2u smallint unsigned,
      – i3u mediumint unsigned,
      i4u int unsigned,
      i8u bigint unsigned,
      *d1 decimal(65),
      d2 decimal(65,1),
      d3 decimal(65,30),*
      d5 decimal(5,5),
      f1 float,
      f2 float(2,1),
      – f23 float(23,4),
      – f24 float(24,10),
      – f53 float(53,20),
      r1 real,
      – r23 real(23,4),
      – r24 real(24,10),
      – r53 real(53,20),

      – dp1 double precision,
      – b0 bit(0),
      – b1 bit(1),
      – b64 bit(64),

      d date,
      dt datetime,
      – ts timestamp,
      – t time,
      – y2 year(2),
      – y4 year(4),
      c0 char(0),
      c1 char(1),
      c2 char(255),
      vc0 varchar(0),
      vc1 varchar(1),
      vc2 varchar(255)
      – vb0 varbinary(0),
      – vb1 varbinary(1),
      – vb2 varbinary(255),
      – bi0 binary(0),
      – bi1 binary(1),
      – bi2 binary(255)
      – bl0 blob(0),
      – bl1 blob(1),
      – bl2 blob(255),
      – tx0 text(0),
      – tx1 text(1),
      – tx2 text(255),
      – e1 enum('a'),
      – e2 enum(' ', 'a'),
      – e3 enum(' ', 'a', 'abc'),
      – s1 set('a'),
      – s2 set(' ', 'a'),
      – s3 set(' ', 'a', 'abc')
      ) ENGINE=COLUMNSTORE

      1815 - 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

              Unassigned Unassigned
              jswanhart Justin Swanhart (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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