Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7307

Modify Data masking UDFs to display output using Latin1 character set

    XMLWordPrintable

    Details

    • 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:

      Description

      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)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              satya.bodapati Satya Bodapati
              Reporter:
              satya.bodapati Satya Bodapati
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Smart Checklist