[
https://jira.jboss.org/jira/browse/TEIID-124?page=com.atlassian.jira.plug...
]
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