[MXS-2166] Default SQL mode should be service specific. Created: 2018-11-13  Updated: 2024-01-04  Resolved: 2019-08-27

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: None
Fix Version/s: 2.5.0

Type: New Feature Priority: Major
Reporter: Johan Wikman Assignee: Marko Rajala (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Filter Improvements
Sprint: MXS-SPRINT-88

 Description   

Using the global parameter sql_mode you can specify whether MaxScale should by default expect regular MariaDB SQL or PL/SQL.

That is inconvenient if some of the applications expect the former and some the latter and requires that either group set the right mode using set sql_mode=[oracle|default] at runtime.

If sql_mode was made into a service parameter, you could have one service expecting MariaDB SQL and another service expecting PL/SQL, and have the client connect to the service that has the right default. That way applications would not have to set the mode explicitly.


Generated at Thu Feb 08 04:12:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.