[teiid-issues] [JBoss JIRA] (TEIID-2983) MongoDB: Function "count()" returns sum instead of number of rows

Van Halbert (JIRA) issues at jboss.org
Wed Jun 4 08:26:15 EDT 2014


Van Halbert created TEIID-2983:
----------------------------------

             Summary: MongoDB: Function "count()" returns sum instead of number of rows
                 Key: TEIID-2983
                 URL: https://issues.jboss.org/browse/TEIID-2983
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
    Affects Versions: 8.7.1
            Reporter: Van Halbert
            Assignee: Steven Hawkins


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



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)


More information about the teiid-issues mailing list