Bug #89345 Contribution: Reduce callproc roundtrip time

• Submitted: 22 Jan 2018 14:10
• Modified: 28 Oct 2022 21:36
• Reporter: OCA Admin (OCA)
• Status: Closed
• Category: Connector / Python
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[22 Jan 2018 14:10] OCA Admin

Description:
This bug tracks a contribution by Vilnis Termanis (Github user: vtermanis) as described in http://github.com/mysql/mysql-connector-python/pull/39

How to repeat:
See description

Suggested fix:
See contribution code attached

[22 Jan 2018 14:10] OCA Admin

Contribution submitted via Github - Reduce callproc roundtrip time 
(*) Contribution by Vilnis Termanis (Github vtermanis, mysql-connector-python/pull/39#issuecomment-359253435): 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_164136017.txt (text/plain), 3.15 KiB.

[23 Jan 2018 4:58] MySQL Verification Team

Hello Vilnis,

Thank you for the report and contribution.

Thanks,
Umesh

[25 Oct 2022 18:24] Nuno Mariz

Posted by developer:
 
Thank you for the contribution.

[28 Oct 2022 21:36] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Connector/Python 8.0.32 release, and here's the proposed changelog entry from the documentation team:

The cursors (both pure and c-ext versions) uses a single SELECT query to
retrieve procedure result parameters after a procedure call; but one SET
call was used per parameter when setting the input parameters. This was
optimized to always use a single SET call for one or multiple parameters.

Thanks to Vilnis Termanis for the contribution.

Thank you for the bug report.