[teiid-issues] [JBoss JIRA] Commented: (TEIID-43) command deterministic subqueries without from clauses should be merged if possible

[ https://issues.jboss.org/browse/TEIID-43?page=com.atlassian.jira.plugin.s... ] Steven Hawkins commented on TEIID-43: ------------------------------------- The original customer issue I believe was around using views that were defined as a select without a from were inhibiting pushdown. That will no longer happen as an uncorrelated scalar subqueries, since they are eligible for evalaution prior to pushdown. Introducing a broad fix to enhance the usage of a select without a from as an inline view in a join does not seem necessary. There will only be an issue if that join is below a higher level outer join, and thus can't be rearranged properly for pushdown. One fix would be to allow ruleraiseaccess to see if a join child without a model can support the source/project nodes so that the access node can be raised (specific to select without a from). Another fix (which doesn't preclude the first) would be to do more analysis to group joins under outer joins more appropriately based upon the join criteria used. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira