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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.16.0
    • druid-adapter
    • 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

              bslim Slim Bouguerra
              bslim Slim Bouguerra
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: