[jira] [Resolved] (ASTERIXDB-1230) Scalar average returns incorrect results

["Yingyi Bu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yingyi Bu resolved ASTERIXDB-1230.
----------------------------------
    Resolution: Fixed

> Scalar average returns incorrect results
> ----------------------------------------
>
>                 Key: ASTERIXDB-1230
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1230
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Ildar Absalyamov
>            Assignee: Yingyi Bu
>            Priority: Critical
>
> The following query, which uses scalar version of average function returns incorrect result:
> {noformat}
> drop dataverse test if exists;
> create dataverse test
> use dataverse test
> create type listType as {
>   "id": int64,
>   "list": [int64]
> }
> create dataset listDS(listType) primary key id
> insert into dataset listDS({"id":1, "list":[1,2,3]})
>  for $x in dataset listDS
> return  avg($x.list)
> {noformat}
> Result:
> {noformat}
> 4611686018427387904
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)