MDEV-34608 Temporary tablespace information missing in INFORMATION SCHEMA.INNODB_TABLESPACES_ENCRYPTION

[Thirunarayanan]

trafficstars

• INNODB_TABLESPACES_ENCRYPTION table in information schema should display innodb temporary tablespace with redo log default encryption ID when innodb_encrypt_temporary_tables is enabled.

• [x] The Jira issue number for this PR is: MDEV-34608

Description

• INNODB_TABLESPACES_ENCRYPTION fails to display temporary tablespace information even though it is encrypted. INNODB_TABLESPACE_ENCRYTION table in information schema should display innodb temporary tablespace with redo log default encryption ID when innodb_encrypt_temporary_tables is enabled.

How can this PR be tested?

./mtr encryption.innodb_encrypt_temporary_tables

Basing the PR against the correct MariaDB version

• [ ] This is a new feature or a refactoring, and the PR is based against the latest MariaDB development branch.
• [x] This is a bug fix, and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [x] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [x] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}