Bug 780986 (SOA-3461) - EDS Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results
Summary: EDS Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results
Keywords:
Status: CLOSED WONTFIX
Alias: SOA-3461
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER4
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-06 19:06 UTC by Warren Gibson
Modified: 2011-12-07 22:14 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-12-07 22:14:57 UTC
Type: Bug

Attachments (Terms of Use)
QT_Ingres10_Push.vdb (218.20 KB, application/octet-stream)
2011-10-06 19:07 UTC, Warren Gibson 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3461 0 None None None Never
Red Hat Issue Tracker TEIID-1777 0 None None None Never

Description Warren Gibson 2011-10-06 19:06:57 UTC 
project_key: SOA

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
Comment 1 Warren Gibson 2011-10-06 19:07:39 UTC 
Attachment: Added: QT_Ingres10_Push.vdb
Comment 2 Van Halbert 2011-10-06 19:11:50 UTC 
Link: Added: This issue Cloned to SOA-3463
Comment 5 Van Halbert 2011-11-15 18:20:04 UTC 
The project has deferred this with no target.
Note You need to log in before you can comment on or make changes to this bug.