[ https://issues.apache.org/jira/browse/ASTERIXDB-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lychagin resolved ASTERIXDB-3015. ---------------------------------------- Resolution: Fixed > avg() returns incorrect result if first value is not a number > ------------------------------------------------------------- > > Key: ASTERIXDB-3015 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-3015 > Project: Apache AsterixDB > Issue Type: Bug > Components: FUN - Functions > Affects Versions: 0.9.6 > Reporter: Dmitry Lychagin > Assignee: Dmitry Lychagin > Priority: Major > Fix For: 0.9.8 > > > avg() function returns incorrect result if it receives a first value of a > non-numeric type. > {noformat} > select value avg(x) from ["a", 1, 2, 3] x; > {noformat} > returns NULL, while it should return 2. -- This message was sent by Atlassian Jira (v8.20.1#820001)