Bug #20592 FUNCTION coalesce does not exist
Submitted: 21 Jun 2006 7:02 Modified: 21 Jun 2006 8:49
Reporter: qu weihong Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connectors: DBD::mysql ( Perl ) Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[21 Jun 2006 7:02] qu weihong 
Description:
When I use coalesce function I receive this error: 

"FUNCTION dbName.coalesce does not exist".  Can someone 
help me with this error 

i run the function on MySql's console in Dos

mysql> SELECT COALESCE(NULL,1); 
        -> 1 
mysql> SELECT COALESCE(NULL,NULL,NULL); 
        -> NULL 

it was ok!

the mysql version what i used is V5.0.22

Thanks, 

How to repeat:
my mail-box
quweihong@gmail.com
[21 Jun 2006 8:49] Sveta Smirnova 
I can't repeat it using DBD::mysql 3.0006 and 3.0006_1
[26 Aug 2008 7:36] Albert Attard 
Has this problem been solved as I have the same problem?
[6 Nov 2008 13:48] Stefan M. 
Check if you have a space after the word "COALESCE". That should be removed.
wrong:
"... COALESCE (...."
right:
"... COALESCE(...."