From the community side you could re-test the scenario using a the community bits or local build.

Processor is not exiting the join as soon as it's determined one side contains 0 rows ------------------------------------------------------------------------------------- Key: TEIID-4812 URL: https://issues.jboss.org/browse/TEIID-4812 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.12.8.6_3, 8.7.11.6_2 Reporter: Debbie Steigner Assignee: Steven Hawkins Fix For: 9.3, 9.2.2 There is an issue with the processor during a join, it doesn't exit the join as soon as it's determined that one side of the join returns 0 rows.