[teiid-issues] [JBoss JIRA] (TEIID-3046) Add support for recursive common table expressions

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-3046.
-----------------------------------
    Resolution: Done


No checking the session variable teiid.maxRecursion to control how many recursions/iterations processing can make prior to throwing an exception.  This will default to 10000.  

Ideally we'd allow the common table to be incrementally used so that it doesn't need to be fully processed all of the time, but currently we lack a good infrastructure to do that (we now use actual temp tables rather than just a linear tuple buffer as in the old days such that we can just append have the logic block appropriately).

> Add support for recursive common table expressions
> --------------------------------------------------
>
>                 Key: TEIID-3046
>                 URL: https://issues.jboss.org/browse/TEIID-3046
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.10
>
>
> We should add support for recursive CTE.



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)