Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2277

COUNT(*) should return 0 instead of an empty result set when there are no records

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 1.0.0
    • Functions - Drill
    • None

    Description

      git.commit.id.abbrev=6676f2d

      Data Set :

      {
       "id":1
      }
      

      Query :

      select count(*) from `temp.json` where uid < 1;
      +------------+
      |   EXPR$0   |
      +------------+
      +------------+
      

      Postgres returns 0 in this case.

      Marking it as critical since we return an incorrect result

      Attachments

        1. DRILL-2277.patch
          8 kB
          Mehant Baid

        Issue Links

          Activity

            People

              mehant Mehant Baid
              rkins Rahul Kumar Challapalli
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: