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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3139:
-------------------------------------

             Summary: 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)