[#MXS-3810] SQL_MODE parsing sometimes fails

[MXS-3810] SQL_MODE parsing sometimes fails Created: 2021-10-13 Updated: 2021-10-14 Resolved: 2021-10-14
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	Core
Affects Version/s:	2.5.16
Fix Version/s:	2.5.17

Type:

Bug

Priority:

Major

Reporter:

markus makela

Assignee:

markus makela

Resolution:

Fixed

Votes:

Labels:

None

Description

The following SQL statement doesn't cause the SQL_MODE in MaxScale to change to ORACLE:

SET SQL_MODE='ORACLE,ANSI_QUOTES';

Changing the order of the values causes it to be detected:

SET SQL_MODE='ANSI_QUOTES,ORACLE';

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