Issue 114314 - Base only retreives first result set when MySQL procedure returns multiple result sets
Summary: Base only retreives first result set when MySQL procedure returns multiple re...
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m12
Hardware: Unknown Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-05 03:09 UTC by prune
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description prune 2010-09-05 03:09:08 UTC 
When I run a query that simply calls a MySQL stored procedure (I'm using ODBC)
which returns multiple result sets, Base only displays the first result set. 
Using DataPilot in Calc to try to use the database as a source likewise only
gets the first result set.
Comment 1 marc.neumann 2010-09-13 12:39:53 UTC 
hi, yes this is because base can only handle 1 result set yet. I set this issue
to Feature and send to the right team.
Comment 2 Ariel Constenla-Haile 2012-09-08 21:12:08 UTC 
Changing component.
The reporter is using ODBC, not the MySQL Connector/OOo