[teiid-issues] [JBoss JIRA] (TEIID-3139) Common table expressions are not pre-evaluated

[Steven Hawkins (JIRA)]

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

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


Ensured that queries with pushdown common table expressions are always pre-evaluated.

> Common table expressions are not pre-evaluated
> ----------------------------------------------
>
>                 Key: TEIID-3139
>                 URL: https://issues.jboss.org/browse/TEIID-3139
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.4
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.7.1, 8.9
>
>
> With sql such as:
> {code}
>     with test as (  
>           select CURDATE() as startDate  
>             from schema.table)  
>     select startDate from test  
> {code}
> The curdate function will be pushed to the source regardless of whether it is supported.  It should be pre-evaluated prior to pushdown.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)