[MCOL-5417] Full support for DECIMAL(65, 38) in ColumnStore Created: 2023-02-07  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 22.08.8
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Gagan Goel (Inactive) Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-5215 UNION on DECIMAL returns incorrect re... Closed

 Description   

The maximum supported precision for DECIMAL data type in ColumnStore is currently 38 digits (this was accomplished in MCOL-641 where the DECIMAL precision was increased from 18 to 38 digits). However, MariaDB server supports upto 65 digits of precision. For parity with the server, ColumnStore should also support the maximum allowable digits to 65 and 38 for precision and scale respectively.

 Comments   
Comment by Gagan Goel (Inactive) [ 2023-02-27 ]

Once this is fixed, we need to remove the following error currently thrown to users:

ERROR 42000: The storage engine for the table doesn't support MCS-2060: Union operation exceeds maximum DECIMAL precision of 38.

Comment by Gagan Goel (Inactive) [ 2023-02-27 ]

Ref file for the legacy regression test001 test case: working_tpch1_compareLogOnly/misc/sumavgoverflow.sql also needs to be updated, once this is fixed.

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