Full DECIMAL support in ColumnStore (MCOL-641)

[MCOL-4172] Add support for wide-DECIMAL into statistical aggregate and regr_ UDAF functions Created: 2020-07-13  Updated: 2020-11-18  Resolved: 2020-11-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: None
Fix Version/s: 5.4.1

Type: Sub-Task Priority: Major
Reporter: Roman Assignee: Roman
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7, 2021-1, 2021-2, 2021-3, 2021-4, 2021-5, 2021-6, 2021-7, 2021-8, 2021-9

 Comments   
Comment by David Hall (Inactive) [ 2020-07-29 ]

Something to look into:
InnoDB:
MariaDB [dhall]> SELECT "avg(38)_test2", avg(d1),avg(d2),avg(d3) FROM cs2;
----------------------------------------------------------------------------------------------------------------------+

avg(38)_test2 avg(d1) avg(d2) avg(d3)

----------------------------------------------------------------------------------------------------------------------+

avg(38)_test2 2255892235599326597959.1818 224466889113357793635.80022446687273 0.10101010010101010037373725644743325455

----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.010 sec)

Columnstore:
MariaDB [tpch1]> SELECT "avg(38)_test2", avg(d1),avg(d2),avg(d3) FROM cs2;
----------------------------------------------------------------------------------------------------------------------+

avg(38)_test2 avg(d1) avg(d2) avg(d3)

----------------------------------------------------------------------------------------------------------------------+

avg(38)_test2 2255892235599326597959.1818 224466889113357793635.80022446687272 0.10101010010101010037373725644743325454

----------------------------------------------------------------------------------------------------------------------+

This can happen signed or unsigned

Comment by Roman [ 2020-09-03 ]

David.Hall Thanks for putting a note. It is a known and still open issue.

Comment by Roman [ 2020-09-17 ]

Plz review.

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