[teiid-issues] [JBoss JIRA] (TEIID-2048) Error during dependent procedure execution

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-2048:
----------------------------------

    Steps to Reproduce: SimpleRecursion.vdb attached in SFDC ticket. Can replicate by deploying VDB to server, and running the query [1] against the VDB. Related -ds.xml will be attached here.  (was: SimpleRecursion.vdb attached in SFDC ticket. Can replicate by deploying VDB to server, and running the query [1] against the VDB. Related -ds.xml will be attached here.

[1]
SELECT E0.ID AS C0,
	R.ID AS C1 
FROM SourceCM.DEPENDANTS AS R 
LEFT JOIN (SourceCM.PARENT_CHILD AS E0 
		JOIN SourceCM.TOP AS E1 
		ON E0.PARENT_ID=E1.ID) 
ON R.PARENT_ID=E0.ID
WHERE E1.NAME='Tree 1' 
GROUP BY E0.ID,R.ID ORDER BY C1 LIMIT 0,5000

The PARENT_CHILD table is derived by a simple virtual procedure, if he switches this to a table there are no issues, so it's seem to be something with the input parameter and the procedure. Testing with his query if you just remove the WHERE clause it succeeds.  If you add the E1.NAME to the SELECT list, you'll see that there are values for this column.)

    
> Error during dependent procedure execution
> ------------------------------------------
>
>                 Key: TEIID-2048
>                 URL: https://issues.jboss.org/browse/TEIID-2048
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.4.1
>            Reporter: Johnathon Lee
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1, 8.1
>
>
> Execution of steps below result in "Unable to evaluate $dsc/id1: No value was available"

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira