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

Cache: Handle variables

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.1
    • Component/s: cache
    • Labels:
      None

      Description

      The cache key is effectively the entire SELECT statement. However, the value of any variables used in the select is not considered. For instance, if a variable is used in the WHERE clause of the select, a subsequent identical select will return the wrong result, if the value of the variable has been changed in between.

      The value of variables should either be tracked or then if variables are used, the statement should not be cached.

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            johan.wikman Johan Wikman
            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.