[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. One thing to note is that the same query on 7.7 works when the databases are on DB2 (using DB2 translator) but not when they are on Datacom (different translator). Is this possibly a translator issue maybe not being able to support multiple join criteria? 8/15: Confirmed the problem occurs for both DB2 and Datacom translators. Any advice would be appreciated as this is affected a customer installation. Thanks! Jeff