[CALCITE-2094] Druid adapter: Count(*) returns null instead of 0 when condition filters all rows

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: druid-adapter
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 18/Dec/17 15:09
• Updated: 27/Feb/24 22:23
• Resolved: 19/Dec/17 23:11

Description

Druid adapter returns nothing for

 Select count(*) from table where condition_is_false 

According to SQL standard the result need to be zero.

Issue Links

• contains: CALCITE-2095 Druid adapter: Push always true and always true expressions as Expression Filters
• contains: CALCITE-2096 Druid adapter: Remove extra dummy_aggregator