Bug #44825 | libmysql breaks existing client applications | ||
---|---|---|---|
Submitted: | 12 May 2009 14:16 | Modified: | 29 Jul 2009 10:16 |
Reporter: | Andrey Hristov | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: C API (client library) | Severity: | S2 (Serious) |
Version: | 6.0.8,5.4 | OS: | Any |
Assigned to: | Alexander Nozdrin | CPU Architecture: | Any |
[12 May 2009 14:16]
Andrey Hristov
[13 May 2009 9:34]
Sveta Smirnova
Thank you for the report. With version 6.0 I can not compile run example from the manual: it fails at status = mysql_stmt_execute(stmt); with error " Incorrect arguments to mysql_stmt_execute". If take in account 5.1 fails with " OUT or INOUT argument 2 for routine test.p1 is not a variable or NEW pseudo-variable in BE
[13 May 2009 9:35]
Sveta Smirnova
Thank you for the report. With version 6.0 I can not compile run example from the manual: it fails at status = mysql_stmt_execute(stmt); with error " Incorrect arguments to mysql_stmt_execute". If take in account 5.1 fails with " OUT or INOUT argument 2 for routine test.p1 is not a variable or NEW pseudo-variable in BE
[13 May 2009 9:38]
Andrey Hristov
Sveta, can you then file a documentation bug report that the example doesn't work. Which doesn't remove make this report nil.
[13 May 2009 9:45]
Sveta Smirnova
Andrey, done: bug #44842
[14 May 2009 7:04]
Sveta Smirnova
Thank you for the feedback. Error which prevented me to run the example exists on Mac only. Bug verified as described. Test case will be attached.
[14 May 2009 8:14]
Sveta Smirnova
test case
Attachment: bug44825.c (text/plain), 11.92 KiB.
[14 May 2009 8:19]
Sveta Smirnova
corrected test case
Attachment: bug44825.c (text/plain), 11.93 KiB.
[24 Jul 2009 6:59]
Alexander Nozdrin
There is already a flag for this: CLIENT_PS_MULTI_RESULTS. However it is included in CLIENT_CAPABILITIES set of flags, so there is no way to turn it off. A solution may be to add support for this flag in COM_SET_OPTION server command (mysql_set_server_option() API function)
[24 Jul 2009 8:12]
Konstantin Osipov
The text protocol is not affected. The binary protocol crashes in 5.1 with stored procedures and multiple result sets. The fact that it now works, but requires a change in the client application is IMHO an improvement. I believe nothing needs to be done about this bug report until we see some external users complain about the change.
[23 Sep 2009 17:19]
Andrey Hristov
It is not just libmysql. I have seen multiple RSets work with 5.1 server, it is the problem in libmysql that it can't work with multiple PS rsets in 5.1 and previous.