Jeff Hayes created TEIID-2625: --------------------------------- Summary: 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 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira