Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

innodb_redo_log_encrypt is inconsistent with upstream

Description

The value reported for innodb_redo_log_encrypt is inconsistent with upstream and other ON/OFF variables.

Upstream 8.0.15

mysql> set global innodb_redo_log_encrypt = on; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'innodb_redo_log_encrypt'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | innodb_redo_log_encrypt | ON | +-------------------------+-------+ 1 row in set (0.00 sec) mysql> select @@version, @@version_comment; +-----------+------------------------------+ | @@version | @@version_comment | +-----------+------------------------------+ | 8.0.15 | MySQL Community Server - GPL | +-----------+------------------------------+ 1 row in set (0.00 sec)

PS 8.0.15

mysql> select @@version, @@version_comment; +-----------+-------------------------------------------------------+ | @@version | @@version_comment | +-----------+-------------------------------------------------------+ | 8.0.15-5 | Percona Server (GPL), Release '5', Revision 'f8a9e99' | +-----------+-------------------------------------------------------+ 1 row in set (0.00 sec) mysql> set global innodb_redo_log_encrypt = on, innodb_undo_log_encrypt = on; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'innodb_%_log_encrypt'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | innodb_redo_log_encrypt | on | | innodb_undo_log_encrypt | ON | +-------------------------+-------+ 2 rows in set (0.01 sec)

Environment

None

Smart Checklist

Activity

George Lorch September 2, 2019 at 4:13 PM

Not a bug, innodb_redo_log_encrypt in PS is not a BOOL but an enumeration of OFF, ON, MASTER_KEY, and KEYRING_KEY.  MySQL reports all enum types a lower case regardless of how they are specified within the typelib.

Lalit Choudhary May 7, 2019 at 8:14 AM

Hello Ceri,

Thank you for the report.

Validated as described.

 

Not a Bug

Details

Assignee

Reporter

Labels

Affects versions

Priority

Smart Checklist

Created May 6, 2019 at 2:14 PM
Updated March 6, 2024 at 12:11 PM
Resolved September 2, 2019 at 4:13 PM

Flag notifications