asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ildar Absalyamov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ASTERIXDB-1230) Scalar average returns incorrect results
Date Tue, 15 Dec 2015 03:17:46 GMT
Ildar Absalyamov created ASTERIXDB-1230:
-------------------------------------------

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

Mime
View raw message