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

Disallow setting innodb_temp_tablespace_encrypt to negative numbers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      While testing PS-3821, it is noticed that setting a negative value enables temp tablespace encryption

       

      mysql> set global innodb_temp_tablespace_encrypt = 0;
      Query OK, 0 rows affected (0.00 sec)

      mysql> select @@innodb_temp_tablespace_encrypt;
      ----------------------------------

      @@innodb_temp_tablespace_encrypt

      ----------------------------------

      0

      ----------------------------------
      1 row in set (0.00 sec)

      mysql> set global innodb_temp_tablespace_encrypt = -2;
      Query OK, 0 rows affected (0.00 sec)

      mysql> select @@innodb_temp_tablespace_encrypt;
      ----------------------------------

      @@innodb_temp_tablespace_encrypt

      ----------------------------------

      1

      ----------------------------------
      1 row in set (0.00 sec)

       

      Expected behaviour should be that we return an error if an invalid value is attempted to set.

      Expected values must be: 0, 1, ON, OFF, TRUE, FALSE, default

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            mohit.joshi Mohit Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist