[ https://issues.jboss.org/browse/TEIID-2048?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2048: ---------------------------------- Description: 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

[ https://issues.jboss.org/browse/TEIID-2048?page=com.atlassian.jira.plugin... ] 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.) -- 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

[ https://issues.jboss.org/browse/TEIID-2048?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2048: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823653 -- 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

[ https://issues.jboss.org/browse/TEIID-2048?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2048: ------------------------------------------------ jolee(a)redhat.com made a private comment on [bug 823653|https://bugzilla.redhat.com/show_bug.cgi?id=823653] -- 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