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] [Commented] (ASTERIXDB-1278) Incorrect result from avg
Date Wed, 27 Jan 2016 19:11:40 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15119991#comment-15119991
] 

Ildar Absalyamov commented on ASTERIXDB-1278:
---------------------------------------------

Yeah, I've encountered this problem before and have half-way done solution for it

> Incorrect result from avg
> -------------------------
>
>                 Key: ASTERIXDB-1278
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1278
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Functions - AQL
>            Reporter: James Fang
>
> I was investigating aggregation functions on a list of records and found a bug when an
incorrect result was returned. From what I have tested, it only affects avg and sql-avg.
> Query: 
> let $w:=[{"item":1, "price":1},{"item":1, "price":2},{"item":2, "price":3}]
> return avg(for $x in $w return $x.price)
> Result:
> 4611686018427387904



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

Mime
View raw message