[MDEV-32875] Unreliable autocommit flag on connection creation Created: 2023-11-24  Updated: 2023-12-13  Resolved: 2023-11-24

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Critical
Reporter: Diego Dupin Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None

Attachments: Text File MDEV-32875.patch    
Issue Links:
Relates
relates to CONJ-1090 AutoCommit Error Closed

 Description   

Client can relies on all command ending packet (OK_PACKET/EOF_PACKET) server status to always know if server is configured to have autocommit enable or not.

Problem is that the very first connection resulting ending OK_PACKET, always have SERVER_STATUS_AUTOCOMMIT set, even if server is configured with `autocommit=0`.

Simple patch is joined
Generated at Thu Feb 08 10:34:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.