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

Steven Hawkins (JIRA) issues at jboss.org
Mon Apr 25 16:09:00 EDT 2016


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

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


Added an attempt to resolve the group prior to assuming the statement defines the implicit temp table.

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


More information about the teiid-issues mailing list