Bug 780991 (SOA-3467)

Summary:	Cross source join reduced to cross join returns the wrong data
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Paul Nittel <pnittel>
Component:	EDS	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	5.2.0.ER4	Keywords:	Regression
Target Milestone:	---
Target Release:	5.2.0.ER5
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-3467
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	JBDS 4.1.1 M2, SOA-P 5.2 ER4
Last Closed:	2011-10-21 14:12:59 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:

Description Paul Nittel 2011-10-07 14:44:22 UTC

project_key: SOA

A cross source join of the form "select x.e2 from pm1.g2 y, pm2.g1 x where x.e1 = y.e1 and x.e1 = 'a'"

will incorrectly return the dummy results from y.  If the join order is reversed the correct results are returned.

Comment 1 Van Halbert 2011-10-07 14:44:24 UTC

Link: Added: This issue Cloned from TEIID-1778

Comment 2 Van Halbert 2011-10-07 14:45:33 UTC

Affects Testing: Added: Regression
Security: Added: Public

Comment 4 Paul Nittel 2011-10-21 14:12:59 UTC

Tested with E2E Virtual Procedures and closed.

Comment 5 Van Halbert 2011-10-24 15:26:59 UTC

Link: Added: This issue is duplicated by SOA-3497