Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2, 1.2.5
-
None
-
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 |
Attachments
Issue Links
- is part of
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | David Hall [ david.hall ] |
| Component/s | ExeMgr [ 13506 ] | |
| Component/s | PrimProc [ 13700 ] | |
| Fix Version/s | 1.2.6 [ 23734 ] | |
| Fix Version/s | 1.4.1 [ 23812 ] | |
| Sprint | 2019-06 [ 332 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
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
| Assignee | David Hall [ david.hall ] | Jose Rojas [ jrojas ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Needs Feedback [ 10501 ] |
| Status | Needs Feedback [ 10501 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Needs Feedback [ 10501 ] |
| Status | Needs Feedback [ 10501 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Assignee | Jose Rojas [ jrojas ] | Daniel Lee [ dleeyh ] |
| Rank | Ranked higher |
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
| Fix Version/s | 1.4.1 [ 23812 ] |
The fix for 1.4.1-1 will be tracked in a different ticket. Closing this one.
| issue.field.resolutiondate | 2019-11-25 21:52:35.0 | 2019-11-25 21:52:35.843 |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Zendesk Related Tickets | 191397 |
workarround:
select log10(CAST(sum(a) as decimal)) from log10test;