Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3810

SQL_MODE parsing sometimes fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.16
    • Fix Version/s: 2.5.17
    • Component/s: Core
    • 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';
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.