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

Bug 878038

Summary: TEIID returns wrong count of data when using inner join from two separately sourced tables
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: vijay nagar <vijay.nagar>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED INSUFFICIENT_DATA QA Contact:
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 5.1.0 GACC: soa-p-jira, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Windows   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-07 14:58:50 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:
Attachments:
Description Flags
VDB that was used none

Description vijay nagar 2012-11-19 14:03:14 UTC 
Description of problem:


I have the following setup:

TEIID= 7.7.0
JBOSS= 5.1.0.GA

TEIID returns wrong count of data when using inner join from two separately sourced tables.


The query is sourced from two sql server databases, the join and the nested query give different results. The nested query result matches with while running the inner join query.

INNER JOIN QUERY:WRONG COUNT

SELECT s.CUSIP FROM "NewMixedModel"."Tranche" T, 
"NewMixedModel"."BondStatic" S 
where T.CUSIP = S.CUSIP 

NESTED QUERY: CORRECT DATA BUT TOO SLOW

select count(CUSIP) FROM "NewMixedModel"."BondStatic" 
where cusip in (
select cusip from "NewMixedModel"."Tranche")
Comment 3 vijay nagar 2012-11-19 17:26:02 UTC 
Created attachment 647900 [details]
VDB that was used