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

warning: The query can't be routed to all backend servers because it includes SELECT and SQL variable modifications which is not supported.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.4.4
    • Fix Version/s: 2.4.8
    • Component/s: qc_sqlite
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-101

      Description

      SET @my_id = (SELECT LAST_INSERT_ID())

      Generates the warning in the subject.

      > 2020-02-24 15:04:00 warning: (162) The query can't be routed to all backend servers because it includes SELECT and SQL variable modifications which is not supported. Set use_sql_variables_in=master or split the query to two, where SQL variable modifications are done in the first and the SELECT in the second one.

      Looks like the SELECT queryi is not properly classified.

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            claudio.nanni Claudio Nanni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration