[MXS-1616] Masking filter does not use value with partial matching Created: 2018-01-17  Updated: 2018-07-10  Resolved: 2018-07-10

Status: Closed
Project: MariaDB MaxScale
Component/s: masking
Affects Version/s: None
Fix Version/s: 2.2.11

Type: Bug Priority: Major
Reporter: Johan Wikman Assignee: Marko Rajala (Inactive)
Resolution: Not a Bug Votes: 0
Labels: 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,


Generated at Thu Feb 08 04:08:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.