[MCOL-162] CS does not support same DECIMAL precision as other MySQL storage engines Created: 2016-06-22  Updated: 2017-06-05  Resolved: 2017-06-05

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
duplicates MCOL-164 DECIMAL does not support full range o... Closed
PartOf
is part of MCOL-641 Full DECIMAL support in ColumnStore Closed

 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



 Comments   
Comment by David Thompson (Inactive) [ 2017-06-05 ]

MCOL-641 tracks the improvement to fully support decima.

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