[teiid-issues] [JBoss JIRA] (TEIID-2370) Pushdown LIMIT in cross product joins

Mark Addleman created TEIID-2370: ------------------------------------ Summary: Pushdown LIMIT in cross product joins Key: TEIID-2370 URL: https://issues.jboss.org/browse/TEIID-2370 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.1 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Critical Pushdown LIMIT clause in cross product joins. Queries of form SELECT t1.a FROM t1, t2 LIMIT 10 Produce a plan like this: LIMIT 10 CROSS JOIN Access: SELECT t1.a FROM t1 LIMIT 10 Access: SELECT 1 FROM t2 LIMIT 10 See https://community.jboss.org/thread/220834?tstart=0 for a little more detail -- 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