[MCOL-3607] ERROR 1815 with log10 and aggregation functions Created: 2019-11-12  Updated: 2019-12-04  Resolved: 2019-11-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: 1.2, 1.2.5
Fix Version/s: 1.2.6

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-3647 Merge develop-1.2 into develop Closed
Sprint: 2019-06

 Description   

To reproduce

create table log10test (a double) engine=columnstore;
 
insert into log10test (a) values(123);
 
select log10(sum(a)) from log10test;
 
ERROR 1815 (HY000): Internal error: log10: datatype of long double



 Comments   
Comment by Richard Stracke [ 2019-11-12 ]

workarround:

select log10(CAST(sum(a) as decimal)) from log10test;

Comment by David Hall (Inactive) [ 2019-11-12 ]

Added long double support to math functions

Comment by David Hall (Inactive) [ 2019-11-12 ]

For QA, the following math functions are involved:
acos, asin, atan, cos, cot, log, log2, log10, sin, sqrt, tan, radians, degrees

Special cases of atan and log take an optional second parameter.

The test is to use sum(v1) or avg(v1) as the argument

Comment by Daniel Lee (Inactive) [ 2019-11-19 ]

Build verified: 1.2.6-1

MariaDB [mytest]> select log10(sum(a)) from log10test;
-------------------

log10(sum(a))

-------------------

2.089905111439398

-------------------
1 row in set (0.065 sec)

Also verified other functions in the last comment.

Fixed has not yet been up merged to 1.4.1-1

Comment by Daniel Lee (Inactive) [ 2019-11-25 ]

The fix for 1.4.1-1 will be tracked in a different ticket. Closing this one.

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