MySQL Bugs: #96093: Improve error message thrown when attempted to create encrypted temporary table

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Hello Sergei,

Thank you for the report and feedback.

regards,
Umesh