Bug #87227 Please clarify what happens when SETting AUTOCOMMIT while in BEGIN transaction

• Submitted: 27 Jul 2017 18:00
• Modified: 1 Sep 2017 14:55
• Reporter: Rick James
• Status: No Feedback
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Any
• CPU Architecture: Any
• Tags: autocommit, commit, transaction

[27 Jul 2017 18:00] Rick James

Description:
After issuing a BEGIN (or START TRANSACTION), the manual says that COMMIT is the normal way to terminate it.  But in some circumstance, SET AUTOCOMMIT (to 0 or 1 or 0, then 1, or something), the transaction will be terminated.  Please clarify the sequence(s) that cause such.

How to repeat:
N/A

Suggested fix:
Clarification on https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html

[1 Aug 2017 14:55] MySQL Verification Team

Hi!

If autocommit mode is set to ON in the midst of the transaction, the transaction will auto-commit after that command. If you have test case that proves otherwise, please provide it and we shall be happy to make our manual more accurate.

[2 Sep 2017 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".