[teiid-issues] [JBoss JIRA] (TEIID-2625) Part of join criteria is getting ignored

Part of join criteria is getting ignored ---------------------------------------- Key: TEIID-2625 URL: https://issues.jboss.org/browse/TEIID-2625 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7.1 Environment: z/OS JZOS Reporter: Jeff Hayes Assignee: Steven Hawkins Attachments: 7.7_Teiid_SHOWPLAN The second part of the join criteria (and CHORUS_J0.userid = CHORUS_B.evtuserid) appears to be getting ignored. The result has same results as when only the first criteria (CHORUS_J0.sysid = cx2.sysid) is provided. Same query works are 8.1 with query plan listing both criteria in joinNode however for 7.7 only shows first criteria. Please see attached query plan. Is there a fix for this or workaround for the query? Thanks! Jeff