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)
• Status: Closed
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 9.2
• OS: Any
• 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.