Bug #100653 aes_decrypt
Submitted: 27 Aug 2020 9:06 Modified: 27 Aug 2020 12:38
Reporter: lokesh singhal Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S5 (Performance)
Version:8.0.21 OS:Linux (Aes_decrypt returns binary)
Assigned to: CPU Architecture:Any

[27 Aug 2020 9:06] lokesh singhal
AES_DECRYPT returns  binary has to return string.

How to repeat:
select aes_decrypt(aes_encrypt('sting','123'),'123');

Suggested fix:
I have to perform one more step to convert it to char.
[27 Aug 2020 12:38] MySQL Verification Team
Hi Mr. singhai,

Thank you for your bug report.

However, this is not a bug.

All AES encryption functions are dealing with binary strings, hence this is a necessity, according to AES standard.

Not a bug.