[CASSANDRA-8214] Select Count(*) on empty table does not return 0 in trunk

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Fix Version/s: 2.2.0 beta 1
• Severity: Normal
• Since Version: 2.2.0 beta 1
• Assignee: Benjamin Lerer
• Reporter: Philip Thompson

Authors

Benjamin Lerer

• Tester: Philip Thompson
• Created: 29/Oct/14 18:55
• Updated: 16/Apr/19 09:31
• Resolved: 31/Oct/14 08:58

Description

The test cql_tests.py:TestCQL.bug_6612_test is failing when performing a

 select count (*) 

on an empty table. It is expecting to have [0] returned, but instead [] is returned. 2.1.1 shows the expected behavior, with trunk HEAD deviating.

With cqlsh I can see a change in how select count(*) changes on an empty table as well:
http://aep.appspot.com/display/xnJyEP7iOBMY6YvFNQdk8vofvsE/

Issue Links

• duplicates: CASSANDRA-8229 Aggregate functions do not return expected values or metadata
• relates to: CASSANDRA-4914 Aggregation functions in CQL