Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2094

Druid adapter: Count(*) returns null instead of 0 when condition filters all rows

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 1.16.0
          • Component/s: druid
          • Labels:
            None

            Description

            Druid adapter returns nothing for 

             Select count(*) from table where condition_is_false

            According to SQL standard the result need to be zero.

              Attachments

                Issue Links

                contains

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-2095 Druid adapter: Push always true and always true expressions as Expression Filters

                • Major - Major loss of function.
                • Closed

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-2096 Druid adapter: Remove extra dummy_aggregator

                • Major - Major loss of function.
                • Closed

                  Activity

                    People

                    • Assignee:
                      bslim slim bouguerra
                      Reporter:
                      bslim slim bouguerra
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: