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/15 18:11:00 UTC

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

Dmitry Lychagin created ASTERIXDB-3015:
------------------------------------------

             Summary: 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
             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)