Bug #26078 AES_ENCRYPT problem
Submitted: 5 Feb 2007 10:51 Modified: 5 Feb 2007 11:16
Reporter: munira Ahmed Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Views Severity:S1 (Critical)
Version:Ver 14.12 Distrib 5.0.27, for redhat-lin OS:Linux (linux)
Assigned to: CPU Architecture:Any

[5 Feb 2007 10:51] munira Ahmed
Description:
has anybody ever tried this query on commans line client
  

select AES_ENCRYPT('company','zyxwvutsrqponmlk');

this is what it produces

+-------------------------------------------+
| AES_ENCRYPT('company','zyxwvutsrqponmlk') |
+-------------------------------------------+
| �M"*(�hȏá÷Ó                           ≠
+-------------------------------------------+
1 ⎼⎺┬ ␋┼ ⎽␊├ (0.00 ⎽␊␌)

└≤⎽─┌>

How to repeat:
NA

Suggested fix:
no idea
[5 Feb 2007 10:59] 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://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read carefully what function AES_ENCRYPT does at http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function-aes-encrypt
[5 Feb 2007 11:16] munira Ahmed
it is definitely a bug as it corrupts the whole data base and the terminal screen.

why the mysql prompt does not come back.

it is cent percent a bug. just try it. 

I have doen quite a bit of reading on the net and did not fin any solution.