| 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 | |
| Tags: | AES_ENCRYPT | ||
[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.
Description: 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.