Bug #96093 Improve error message thrown when attempted to create encrypted temporary table
Submitted: 4 Jul 2019 14:45 Modified: 5 Jul 2019 5:13
Reporter: Sergei Glushchenko Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:8.0.16, 5.7.26 OS:Any
Assigned to: CPU Architecture:Any

[4 Jul 2019 14:45] Sergei Glushchenko
Description:
The error message reads as follows:

mysql> CREATE TEMPORARY TABLE t (a INT) ENCRYPTION='y';
ERROR 3833 (HY000): ENCRYPTION clause is not valid for temporary tablespace.

It looks confusing because user is trying to create temporary table, not tablespace.

How to repeat:
see description

Suggested fix:
Improve the message
[5 Jul 2019 5:13] MySQL Verification Team
Hello Sergei,

Thank you for the report and feedback.

regards,
Umesh