Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Duplicate
 - 
    None
 - 
    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
- is duplicated by
 - 
                    
MCOL-162 CS does not support same DECIMAL precision as other MySQL storage engines
-         
 - Closed
 
 -