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

MongoDB: Function "count()" returns sum instead of number of rows

    XMLWordPrintable

Details

    Description

      Function "count()" returns sum of rows instead of number of rows

      Query [1] returns sum of values of all rows of IntKey column.
      Query [2] correctly returns number of rows

      [1] SELECT COUNT(IntKey) FROM BQT1.SmallA
      [2] SELECT COUNT FROM BQT1.SmallA

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: