[teiid-issues] [JBoss JIRA] Resolved: (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 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