Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1104614

Summary: MongoDB: Function "count()" returns sum instead of number of rows
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: atangrin, dlesage, vhalbert
Target Milestone: ER1Keywords: QA-Closed
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
In MongoDB, the "count()" function returned a sum instead of a number of rows. This has now been corrected so it returns the expected result.
 Story Points: ---
Clone Of: Environment:
DV 6.0 + rollup
Last Closed: 2016-02-10 08:49:02 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Filip Elias 2014-06-04 10:57:03 UTC 
Description of problem:

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
Comment 1 JBoss JIRA Server 2014-06-04 21:11:59 UTC 
Ramesh Reddy <rareddy> updated the status of jira TEIID-2983 to Resolved
Comment 2 JBoss JIRA Server 2015-04-07 13:35:16 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-2983 to Closed