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

Masking filter does not use value with partial matching

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • 2.2.11
    • masking
    • None

    Description

      If partial matching is used with the masking filter, the value key is ignored even if the length would match. For instance, with the following rules

      {
          "rules": [
              {
                  "replace": {
                      "column": "ssn",
                      "match": "....$"
                  },
                  "with": {
                      "value": "YYYY"
                  }
              }
          ]
      }
      

      we'll have

      > select * from person;
      +-------+-------------+
      | name  | ssn         |
      +-------+-------------+
      | Bob   | 435-22-XXXX |
      | Alice | 721-07-XXXX |
      +-------+-------------+
      

      even though the length of the matched part is the same as the length of the value of value,

      Attachments

        Activity

          People

            marko.rajala Marko Rajala (Inactive)
            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.