[
https://issues.jboss.org/browse/TEIID-4168?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-4168:
----------------------------------
Fix Version/s: 8.13.4
Actually this does introduce the possibility of an issue whereby we are misinterpretting
an implicit insert:
create temporary table #x (x string, y string)
insert into #x select 'x' as y, 'y' as x
would result in an y,x row - rather than the expected x,y row. So this will be needed in
older branches as well.
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, 8.13.4
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)