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

Compound Cache Rules should be AND and not OR condition

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 2.4.19
    • Fix Version/s: 2.4.20
    • Component/s: cache
    • Labels:
      None
    • Environment:
      centos 7

      Description

      According to documentation here:

      https://mariadb.com/kb/en/mariadb-maxscale-24-cache/#security_1

      In the Security section, it shows an example and says:

      "That can be prevented, by explicitly declaring in the rules that the caching should be applied to alice only."

      However, in implementation, Each json stanza is applied as an OR condition.

      For Example:

       
      {
        "store": [
          {
            "attribute": "database",
            "op": "=",
            "value": "marketing"
          },
          {
            "attribute": "table",
            "op": "=",
            "value": "flyer_data"
          }
        ],
        "use": [
          {
            "attribute": "user",
            "op": "=",
            "value": "'jqgrid'@'%'"
           }
        ]
      }
      

      Matches ANY condition and not ALL as expected.

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            ksizemore Kathryn Sizemore
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.