Bug #8438 whitespace after agregation function
Submitted: 11 Feb 2005 8:53 Modified: 11 Feb 2005 9:05
Reporter: Ales Lipovy Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.7 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[11 Feb 2005 8:53] Ales Lipovy 
Description:
Agregation functions (count, max, min, ...) followed by a whitespace and bracket are not parsed correctly. "...COUNT(..." is OK, however "... COUNT<whitespace>(..." fails. It is a bit annoying in case of migration finished application to the MySQL.

How to repeat:
SELECT COUNT (*) FROM <table>
[11 Feb 2005 9:05] Hartmut Holzgraefe 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

See http://dev.mysql.com/doc/mysql/en/reserved-words.html
[11 Feb 2005 10:01] Ales Lipovy 
Thanks for explanation. 

I should migrate finished application working on Oracle, MSSQL, DB2, Sybase, HSQL and PostgreSQL. Such databases have different approach to reserved words than MySQL. So this could be an enhancement instead of a bug: 
Think about a revision of your "reserved words" philosophy to be more "compatible" with other databases. Migration to MySQL will be more straightforward.
[11 Feb 2005 10:18] Ales Lipovy 
I am taking back previous commentary. I am sorry, I do not read the documentation carefully...