[
https://issues.jboss.org/browse/TEIID-3654?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-3654.
-----------------------------------
Resolution: Done
This doesn't affect all subquery situations, just ones in which the parent projection
was pushed, it's a join child, and there's no intervening select node. Corrected
by adding a NO_PROJECTION capability to indicate that the system source performs no
projection.
Exception with system table subquery
------------------------------------
Key: TEIID-3654
URL:
https://issues.jboss.org/browse/TEIID-3654
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.12
Issuing a subquery against a system table such as:
SELECT t.Name FROM SYS.Tables as t, (SELECT DISTINCT c.TableName FROM SYS.Columns AS c)
AS X__1 WHERE t.Name = X__1.TableName
Results in the exception: TEIID30328 Unable to evaluate X__2.TableName: No value was
available
This is due to the project not being pushed and the project columns not being updated
appropriately.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)