-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Fixed
-
Affects Version/s: 8.0.19-10, 8.0.20-11
-
Fix Version/s: 8.0.21-12
-
Component/s: Data Masking
-
Labels:
Due to https://dev.mysql.com/worklog/task/?id=13038 in 8.0.19, mysql terminal in interactive mode shows binary as hex
All the UDFs until now declared output as binary string. Because of above WL, mysql terminal in interactive mode (that is output or input not redirected) started showing the output from UDFs as hex. Other client modes are not effected.
Example:
mysql> SELECT mask_ssn("935-20-5725");
+--------------------------------------------------+
| mask_ssn("935-20-5725") |
+--------------------------------------------------+
| 0x5858582D58582D35373235 |
+--------------------------------------------------+
expected output:
mysql> SELECT mask_ssn("935-20-5725");
+-------------------------+
| mask_ssn("935-20-5725") |
+-------------------------+
| XXX-XX-5725 |
+-------------------------+
1 row in set (0.00 sec)
- is triggered by
-
PS-5793 Data masking plugin
-
- Done
-