Issue

• We get the above error code when our application attempts to execute the following SQL against a model in which the SourceCM.PARENT_CHILD view table is populated via a Teiid Virtual Procedure. If we instead model this table by selecting data directly from a base table then the SQL is successful.

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