This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Locking SQL_MODE against client changes

Is there any way for locking out sql_mode against client-side changes other than MySQL Proxy (which does not allow for SSL connections)? Perhaps some MariaDB-specific setting?

Answer

Unfortunately, we don't have such a feature yet.

However this feature would be trival to implement (about 3-4 hours of work including testing and adding to the MariaDB distribution) and thus is something that would be very suitable for a sponsorship.

I have added this feature request as WL#249

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.