Bug 780991 (SOA-3467) - Cross source join reduced to cross join returns the wrong data
Summary: Cross source join reduced to cross join returns the wrong data
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3467
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER4
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 5.2.0.ER5
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
: 781017 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-07 14:44 UTC by Paul Nittel
Modified: 2011-10-24 15:26 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
JBDS 4.1.1 M2, SOA-P 5.2 ER4
Last Closed: 2011-10-21 14:12:59 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3467 0 Blocker Closed Cross source join reduced to cross join returns the wrong data 2012-11-19 13:03:11 UTC

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
Note You need to log in before you can comment on or make changes to this bug.