[jira] [Commented] (CASSANDRA-8229) Aggregate functions do not return expected values or metadata

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

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

Benjamin Lerer commented on CASSANDRA-8229:
-------------------------------------------

[~thobbs] can you review the second patch?

> Aggregate functions do not return expected values or metadata
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-8229
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8229
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>             Fix For: 3.0
>
>         Attachments: CASSANDRA-8229-V2.txt, CASSANDRA-8229.txt
>
>
> Aggregrate functions do not behave as expected on the following points:
> * If no row is selected the resultset returned is empty whereas in the case of aggregates it should returns some default values (e.g. {{SELECT count(*) ...}} should return 0 if no row is returned).
> * The column name returned for {{max(a)}} when a is an int is {{max(int -> int)}} and should be {{max(a)}} if no alias is used.
> * When used with limit the value returned is not always the expected one. It sometimes include an extra row.



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