[MCOL-1207] The max values for Decimal data type is 18, how can store more bigger Created: 2018-02-07  Updated: 2018-02-07  Resolved: 2018-02-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: chenxinglong Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS 6.5+ MariaDB ColumnStore 1.1.2

Issue Links:
Duplicate
is duplicated by MCOL-641 Full DECIMAL support in ColumnStore Closed

 Description   

MariaDB [dba_info]> CREATE TABLE tb_test
-> (
-> id BIGINT ,
-> amount DECIMAL(36, 18) NULL,
-> create_time INT NULL
-> )
-> ENGINE = columnstore;
ERROR 1815 (HY000): 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 Thompson (Inactive) [ 2018-02-07 ]

ColumnStore currently is limited to what can be stored in 8 bytes in the column files. There is an existing enhancement to support a larger range. One question to ask is if you really need this range and second could double fulfil your needs (still limited precision but range can be higher).

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