Limit cannot be pushed to the left side of a sideways correlated join --------------------------------------------------------------------- Key: TEIID-2899 URL: https://issues.jboss.org/browse/TEIID-2899 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.7 This is a regression from TEIID-2370. When pushing a limit below a join we need to check if there is a sideways correlation. Otherwise pushing to the left side may result in too few results.