Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.1.1
-
None
Description
Masked column values are revealed with sql function CONCAT.
For example, masking table with masked column `lastname`,
select statement returns masked value for lastname.
But using CONCAT function, values are revealed.
mysql> SELECT id, firstname, lastname FROM masking;
|
+----+-----------+----------+
|
| id | firstname | lastname |
|
+----+-----------+----------+
|
| 1 | test1 | XXXXX |
|
| 2 | test2 | XXXXX |
|
+----+-----------+----------+
|
 |
mysql> SELECT id, firstname, CONCAT(lastname) FROM masking;
|
+----+-----------+------------------+
|
| id | firstname | CONCAT(lastname) |
|
+----+-----------+------------------+
|
| 1 | test1 | mask1 |
|
| 2 | test2 | mask2 |
|
+----+-----------+------------------+
|
2 rows in set (0.00 sec)
|