Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Duplicate
-
6.1.1
-
2021-4, 2021-5
Description
from test working_tpch1_compareLogOnly/having/having2.sql
select cinteger, abs(avg(cinteger)) from DataTypeTestm group by cinteger having abs(avg(cinteger)) > 7483645 order by 1;
should result in:
cinteger | abs(avg(cinteger)) |
----------------------------+
-7483646 | 7483646.0000 |
7483646 | 7483646.0000 |
7483647 | 7483647.0000 |
----------------------------+
But we get
cinteger | abs(avg(cinteger)) |
----------------------------+
7483646 | 7483646.0000 |
7483647 | 7483647.0000 |
----------------------------+
Attachments
Issue Links
- is part of
-
MCOL-4603 Replace long double with wide/narrow-decimal for avg() and sum() result type for all numerical datatypesdecimal result
- Closed