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

Wednesday, 4 June 2014

    [
https://issues.jboss.org/browse/TEIID-2983?page=com.atlassian.jira.plugin...
] 

Steven Hawkins commented on TEIID-2983:
---------------------------------------

Or even just:

select count(foo1), count(foo2) from bar

If they both contribute to the where clause the counts can be incorrect.

...
 Can suggest what may be better? 
It seems like only count\(*) is supported and not count in general.

...
 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: Ramesh Reddy
              Labels: Beta1
             Fix For: 8.7.1, 8.8

 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)

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009