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

CS does not support same DECIMAL precision as other MySQL storage engines

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      None

      Description

      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
      

      1815Internal 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:
              jswanhart Justin Swanhart
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: