Bug #117548 | mysql/connector python fetchmany() has an off by one bug when argument given as 1 | ||
---|---|---|---|
Submitted: | 23 Feb 23:07 | Modified: | 4 Jul 21:14 |
Reporter: | Mike Bayer | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / Python | Severity: | S1 (Critical) |
Version: | 9.2.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[23 Feb 23:07]
Mike Bayer
[24 Feb 7:48]
MySQL Verification Team
Hello Mike Bayer, Thank you for the report and test case. Verified as described. regards, Umesh
[25 Feb 16:56]
Oscar Pacheco
Posted by developer: Dear all, After further verification, we detected the issue is exclusive of the c-extension implementation. For those users impacted by this bug, you may consider the following workarounds while the bug gets fixed: 1. Use buffered cursors. 2. If a slight performance hit is not a concern, use the pure-python implementation. Regards.
[28 May 12:33]
Souma Kanti Ghosh
Posted by developer: Hello Mike, Thank you for raising this bug. Cheers, Souma Kanti
[4 Jul 21:14]
Daniel So
Posted by developer: Added the following entry to the Connector/Python 9.4.0 changelog: "When using the Connector/Python C Extension with an unbuffered server-side cursor, fetchmany(1) failed to fetch more results after reading the second row in the result set."