[teiid-issues] [JBoss JIRA] (TEIID-3526) Issues with insert and query expression with a common table expression
Steven Hawkins (JIRA)
issues at jboss.org
Mon Jul 6 10:22:03 EDT 2015
[ https://issues.jboss.org/browse/TEIID-3526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-3526.
-----------------------------------
Resolution: Done
The logic was not generally correct in the insert case and the with clause was not getting associated. That has been corrected.
Also added a new capability to describe if WITH is supported in subqueries. Insert with a query expression and a common table expression is still pushed and it's up to the translator to move the clause to the beginning of the source command - this may be modified by TEIID-3560
> Issues with insert and query expression with a common table expression
> ----------------------------------------------------------------------
>
> Key: TEIID-3526
> URL: https://issues.jboss.org/browse/TEIID-3526
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> SQL Server will not support a source query of the form:
> insert into tbl with ...
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
More information about the teiid-issues
mailing list