Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2396

count of column returns null instead of 0 over join

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 8.3
    • 7.0
    • Query Engine
    • None
    • Workaround Exists
    • Hide

      Use ifnull(count(col)) instead of just count(col)

      Show
      Use ifnull(count(col)) instead of just count(col)

    Description

      The aggregate pushing logic will decompose a count as a sum of count, which can be null if no rows are returned by the join.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: