[teiid-issues] [JBoss JIRA] Commented: (TEIID-124) insert with query should be supported at the connector level

[Steven Hawkins (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12463869#action_12463869 ] 

Steven Hawkins commented on TEIID-124:
--------------------------------------

This is just a different varient of insert support.  For example we use the table metadata to determine basic support and we currently have a capability to indicate bulk insert support.  There would be an additional capability supportsInsertQueryExpression, when true we would allow the push of queries in the form of "insert into table <query expression>", such that the query expression is pushable and the table is a valid insert target.  If the capability is not supported we would degrade to our normal handling that will first check for bulk insert, then batched update, then a single insert at a time. 

> insert with query should be supported at the connector level
> ------------------------------------------------------------
>
>                 Key: TEIID-124
>                 URL: https://jira.jboss.org/jira/browse/TEIID-124
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 6.x
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 6.1.0
>
>
> Defect Tracker #25005: Insert into with a query is now supported at the query level and is the ANSI standard way of representing select into.  Insert with a query should become the dominant concept rather than select into, and it should be supported through the connector layer so that same source operations do not have the overhead of a select into.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira