[#SQL-6] Handle multiple result sets - Atlassian Developer Network JIRA

Confluence SQL Plugin

Handle multiple result sets

Created: 18/Mar/06 12:51 PM Updated: 08/Jan/07 11:56 PM

Component/s:

SQL macro

Affects Version/s:

None

Fix Version/s:

3.1

Time Tracking:

Not Specified

Labels:

Description

« Hide

Jeff Hatfield made this request:
Another feature I'd like to see is the ability to handle multiple result sets, as when you use a COMPUTE statement. That would make it the one SQL macro that does everything!

All

Comments

Work Log

Change History

FishEye

Crucible

Related Builds

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Bob Swift - 30/Dec/06 12:28 PM

The code has been updated to handle multiple results sets. However, various databases have non-standard support it this area, in particular the COMPUTE statement is MS SQL server specific, so cannot be tested specifically.

[ Permlink | « Hide ]

Bob Swift - 08/Jan/07 11:56 PM

This means there is support for running multiple SQL statements (semi-colon separated) within a single macro body. This works for postgresql and any other database with similar support for multiple statements on a jdbc statement.