| Summary: | EDS Ingres as source - 3 VQT Queries using COUNT(*) returning unexpected results | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Warren Gibson <wgibson> | ||||
| Component: | EDS | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED WONTFIX | QA Contact: | |||||
| Severity: | high | Docs Contact: | |||||
| Priority: | high | ||||||
| Version: | 5.2.0.ER4 | CC: | vhalbert | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| URL: | http://jira.jboss.org/jira/browse/SOA-3461 | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2011-12-07 22:14:57 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: | |||||
| Attachments: |
|
||||||
Attachment: Added: QT_Ingres10_Push.vdb Link: Added: This issue Cloned to SOA-3463 The project has deferred this with no target. |
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