[CASSANDRA-8229] Aggregate functions do not return expected values or metadata

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 beta 1
• Component/s: Legacy/CQL
• Severity: Normal
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Created: 31/Oct/14 08:55
• Updated: 16/Apr/19 09:31
• Resolved: 13/Nov/14 17:35

Description

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.

Issue Links

• is duplicated by: CASSANDRA-8214 Select Count(*) on empty table does not return 0 in trunk