[teiid-issues] [JBoss JIRA] (TEIID-1377) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

Tue Aug 6 14:18:26 EDT 2013

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

Steven Hawkins resolved TEIID-1377.
-----------------------------------

    Resolution: Deferred

Marking as deferred:
* this has been addressed for DTP
* this is not standard behavior (some databases support it, others do not)
* the change to support multiple result sets would be quite extensive as we have quite a bit of built in assumptions in the RequestWorkItem (and even in the driver client/server messaging).

A somewhat related issue is TEIID-2614 - but the statements need to be called in a block and can only return a single resultset.

> Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1377
>                 URL: https://issues.jboss.org/browse/TEIID-1377
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.1.1
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle).
> At present, no exceptions are thrown, but the queries fail to execute.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira