[teiid-issues] [JBoss JIRA] (TEIID-1777) Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results

[Warren Gibson (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12632896#comment-12632896 ] 

Warren Gibson commented on TEIID-1777:
--------------------------------------

Number 1/3 are getting 1 row back but the count in the row is wrong.  Number 1/3 should get back a count of 47 and they are getting a count of 1.

                
> Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-1777
>                 URL: https://issues.jboss.org/browse/TEIID-1777
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 7.4.1
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>
> EDS Query Testing is getting unexpected results on the following queries:
> 3 queries involving COUNT(*) 
>                    
> QUERY:  SELECT COUNT(*) FROM VQT.Agg1	
> COMMENT:  Expected count of 47 rows but got count of 1.    
>           Agg1 transformation:  SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA  GROUP BY BQT1.SmallA.StringNum
> QUERY:  SELECT COUNT(*) FROM VQT.Agg3
> COMMENT:  Expected count of 1 but got count of 50.
>           Agg3 transformation: SELECT   COUNT(*)  FROM   BQT1.SmallA
> QUERY:  SELECT COUNT(*) FROM VQT.Agg4
> COMMENT:  Expected count of 47 but got count of 1.
>           Agg4 transformation:  SELECT   MIN(BQT1.SmallA.StringNum), SUM(BQT1.SmallA.IntKey), AVG(BQT1.SmallA.IntKey)  FROM   BQT1.SmallA  GROUP BY BQT1.SmallA.StringNum

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira