You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (Jira)" <ji...@apache.org> on 2022/02/26 00:52:00 UTC

[jira] [Resolved] (ASTERIXDB-3015) avg() returns incorrect result if first value is not a number

     [ 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)