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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-43.
---------------------------------

    Fix Version/s:     (was: 7.4)
       Resolution: Won't Fix


In thinking about this more, the handling of uncorrelated subqueries should be sufficient to cover this issue for now.

The other more general approaches including more aggressive join reordering or more pervasive constant propagation from literal view projections would be more beneficial for similar amounts of work.

> command deterministic subqueries without from clauses should be merged if possible
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-43
>                 URL: https://issues.jboss.org/browse/TEIID-43
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Priority: Optional
>
> Defect Tracker #24752: command deterministic subqueries without from clauses should be merged if possible:
> i.e. select e1, a from pm1.g1, (select 1 a) x <=> select e1, 1 from pm1.g1
> i.e. select e1, (select 1 a)  from pm1.g1  <=> select e1, 1 from pm1.g1

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira