[teiid-issues] [JBoss JIRA] (TEIID-3259) dynamic sql cannot use into with updates

[Steven Hawkins (JIRA)]

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

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


Added backwards compatibility and updated the docs / sqladmin materialization procs to use rowcount instead.

> dynamic sql cannot use into with updates
> ----------------------------------------
>
>                 Key: TEIID-3259
>                 URL: https://issues.jboss.org/browse/TEIID-3259
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 8.9
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.10
>
>
> TEIID-3198 refined the dynamic sql handling such that the use of AS columns required a result set from the query.  However our materialization logic in SYSADMIN and our documentation indicated that the approach should be used.  We may need to offer backward compatibility and at the very least should update the materialization sql.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)