Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3054

Counting zero null rows returns an empty result set

    XMLWordPrintableJSON

    Details

      Description

      Execute the following query on a table with zero null cells.

      select count(*) from table where column1 = null
      

      The result set should consist of one cell with the value `0` but the result set is empty.

        Attachments

        1. PHOENIX-3054_v1.patch
          8 kB
          Ankit Singhal
        2. PHOENIX-3054.patch
          3 kB
          Ankit Singhal

          Activity

            People

            • Assignee:
              ankit@apache.org Ankit Singhal
              Reporter:
              kliew Kevin Liew
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: