Bug #42629 Add SHA2 algorithms (like SHA256) to the encryption functions
Submitted: 5 Feb 2009 16:55 Modified: 5 Feb 2009 17:28
Reporter: Raymond Plante Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: encryption, hash, Security, sha1, SHA2, SHA256

[5 Feb 2009 16:55] Raymond Plante 
Description:
Add a SHA2 and other more recent (and secure) hashing algorithms to built in MySQL functions.  

How to repeat:
This is a feature request not a bug.  The bugtracking system should not make this a mandatory field when severity is set "S4(Feature Request)".  I'll let someone else enter that bug... ;)

Suggested fix:
Suggest adding functionality similar to the PHP function Hash(<algorithm name>, <string to encrypt>).  This way you don't need to keep adding new functions like SHA256() every time new ones come out--just new algorithms underneath.
[5 Feb 2009 17:08] Paul DuBois 
SHA2() is present as of MySQL 6.0.5.

http://dev.mysql.com/doc/refman/6.0/en/encryption-functions.html#function_sha2
[5 Feb 2009 17:28] Valeriy Kravchuk 
Closed as we have this feature in 6.0.x already.