[MCOL-164] DECIMAL does not support full range of values Created: 2016-06-22  Updated: 2016-10-07  Resolved: 2016-10-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-162 CS does not support same DECIMAL prec... Closed

 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



 Comments   
Comment by David Hall (Inactive) [ 2016-08-09 ]

Is this a duplicate of 162?

Comment by Justin Swanhart (Inactive) [ 2016-08-09 ]

yes. sorry about that.

Generated at Thu Feb 08 02:18:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.