Bug #20451 AES Encrypt Decrypt Bug
Submitted: 14 Jun 2006 8:56 Modified: 14 Jun 2006 9:33
Reporter: Lee Harrison Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5 OS:Microsoft Windows (Windows Any)
Assigned to: CPU Architecture:Any

[14 Jun 2006 8:56] Lee Harrison
Description:
When encrypting and decrypting a particular string I get a null value. If I change the string or the encryption password it works fine. This is used in a live system so I cannot change the encryption password used.

How to repeat:
select AES_ENCRYPT('01','$%^&*()!1709748H1gHT3nS10n'), AES_DECRYPT('¶áEo	…
ñ”‘½4ö¹', '$%^&*()!1709748H1gHT3nS10n');

Suggested fix:
No idea.
[14 Jun 2006 9:33] Sveta Smirnova
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php
[14 Jun 2006 9:36] Sveta Smirnova
Binary strings not always can be input in command line correctly.

Use SELECT AES_ENCRYPT('01','$%^&*()!1709748H1gHT3nS10n'), AES_DECRYPT(AES_ENCRYPT('01','$%^&*()!1709748H1gHT3nS10n'),'$%^&*()!1709748H1gHT3nS10n'); instead.