[
https://issues.apache.org/jira/browse/ASTERIXDB-1230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu reassigned ASTERIXDB-1230:
------------------------------------
Assignee: Yingyi Bu (was: Ildar Absalyamov)
> 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)
