[MCOL-4548] Regression: expression in HAVING clause not working right abs(avg()) Created: 2021-02-19 Updated: 2021-04-21 Resolved: 2021-03-12 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 6.1.1 |
| Fix Version/s: | 6.1.1 |
| Type: | Bug | Priority: | Blocker |
| Reporter: | David Hall (Inactive) | Assignee: | Leonid Fedorov |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | regression | ||
| Issue Links: |
|
||||||||
| Sprint: | 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:
---------
---------
---------
--------- |
| Comments |
| Comment by Roman [ 2021-02-24 ] |
|
gdorman You can safely tell that everything in 6.x is related to decimal b/c the change impacted almost all of the facilities. |
| Comment by Roman [ 2021-03-12 ] |
|
This one will go away with |