Bug #117373 Contribution: Fix Example Packets for COM_STMT_PREPARE Response and Suggest ...
Submitted: 3 Feb 15:21 Modified: 13 Mar 14:21
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:9.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contrbution

[3 Feb 15:21] OCA Admin
Description:
This bug tracks a contribution by Konno Satoshi (Github user: cybergarage), as described in http://github.com/mysql/mysql-server/pull/593

How to repeat:
See description

Suggested fix:
See contribution code attached
[3 Feb 15:21] OCA Admin
Contribution submitted via Github - Fix Example Packets for COM_STMT_PREPARE Response and Suggestion on Payload Spec 
(*) Contribution by Konno Satoshi (Github cybergarage, mysql-server/pull/593#issuecomment-2626456559): @mysql-oca-bot I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_2308224740.txt (text/plain), 2.32 KiB.

[4 Feb 7:40] MySQL Verification Team
Hello Konno Satoshi,

Thank you for the report and contribution.

regards,
Umesh
[6 Feb 14:15] Georgi Kodinov
Thank you for your contribution. Yes, the check should be >=. See cli_read_prepare_result().
[26 Feb 14:07] Daniyaal Khan
Any chance this fix would get accepted into the upstream?
[13 Mar 14:21] Jon Stephens
Documented fix as follows in the MySQL 9.3.0 changelog:

    Addressed the following issues in the server source code
    documentation for COM_STMT_PREPARE responses:

        The payload specification showed the wrong condition for
        checking the warning count.
        
        Removed extraneous pipe characters (|) from the first
        example.
        
    Our thanks to Kanno Satoshi for the contribution.

Closed.