Bug #36682 A bug with Case Statement
Submitted: 13 May 2008 9:32 Modified: 13 May 2008 11:48
Reporter: Sudhakar Talluri Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[13 May 2008 9:32] Sudhakar Talluri
Description:
HI,
There is some ploblem with Case statement when null as data.

For Ex 
In Users table if Username is null I want Get 'Test' as Values for this the query what I have writen is

select (select  case Username 
when null  then 'TEST'
else username
end)
from Users

but when I executed this query I am getting null only Plz let me know if my query is wrong are is it a bug

How to repeat:
It is very requried to get another value when the value is null.
[13 May 2008 11:48] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.