[teiid-issues] [JBoss JIRA] (TEIID-4168) Odd resolving error with implicit temp groups

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4168:
-------------------------------------

             Summary: Odd resolving error with implicit temp groups
                 Key: TEIID-4168
                 URL: https://issues.jboss.org/browse/TEIID-4168
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 9.0


If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table.  For example:

insert into #tmp_dates ... defines the temp table ...
insert into #tmp_dates select <some expression>

Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)