Bug #101672 Add SERVER_STATUS_ANSI_QUOTES flag to the Client/Server protocol
Submitted: 19 Nov 2020 1:41 Modified: 19 Nov 2020 13:56
Reporter: Adalbert Makarovych Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[19 Nov 2020 1:41] Adalbert Makarovych 
Description:
Server status doesn't contain the information about the ANSI_QUOTES SQL_MODE. 
Supported flags are listed here: https://dev.mysql.com/doc/internals/en/status-flags.html .
This information can be useful for drivers/connectors.

How to repeat:
Not available.
It is a feature request.

Suggested fix:
Add SERVER_STATUS_ANSI_QUOTES flag.
[19 Nov 2020 13:56] MySQL Verification Team 
Hi Mr. Makarovich,

Thank you for your feature request.

Since that field is an unsigned integer, which on 64-bit systems can take many more bits, we find that your request is fully justified.

Verified as reported.
[19 Nov 2020 13:57] MySQL Verification Team 
Setting the correct version.
[20 Nov 2020 8:17] Georgi Kodinov 
Posted by developer:
 
The status flags are a bit deprecated by now. They're superseded by the session trackers (also in the OK packet). 
If you want to try your hand on implementing it as a session tracker I'd gladly take contributions.