Bug #24783 | Commands out of sync error when calling stored procedures from PHP and Perl | ||
---|---|---|---|
Submitted: | 4 Dec 2006 0:35 | Modified: | 4 Dec 2006 12:35 |
Reporter: | Edoardo Serra | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.27 | OS: | |
Assigned to: | CPU Architecture: | Any |
[4 Dec 2006 0:35]
Edoardo Serra
[4 Dec 2006 8:24]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Please read carefully how to handle Multiple Statement Execution at http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html
[4 Dec 2006 12:35]
Edoardo Serra
Tnx for your answer, I see we have to use mysql_next_result to correctly handle multi_results but I cannot explain myself why it is working with some version of libmysqlclient. For example it was working with 5.0.12-beta and 5.1.7-beta but not with 5.0.27 and 5.1.13 from bitkeeper, that's why I opened that bug. Does it make sense ? are there important changes between them ? Is possibile and safe to use 5.1.7 client lib with 5.0.27 server ? Tnx Regards