MySQL Bugs: #10596: 'DES_DECRYPT' functionality always return 'NULL'

Bug #10596	'DES_DECRYPT' functionality always return 'NULL'
Submitted:	12 May 2005 13:31	Modified:	12 May 2005 13:37
Reporter:	Disha	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.5-beta-nt	OS:	Windows (Windows xp)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
DES_DECRYPT function always return null value. 

How to repeat:
A) Execute the following command.
	delimiter //
	Select DES_DECRYPT('crypt_str','test')// 

B) Expected Result: if 'DES_DECRYPT' fail it should return value 'crypt_str'

C) Actual Result: 	
		+-----------------------------+
		| DES_DECRYPT('crypt_str','test') |
		+-----------------------------+
		| NULL                        |
		+-----------------------------+
		1 row in set (0.16 sec)

Related to the same issue of:

http://bugs.mysql.com/bug.php?id=10589