A coder's home for Marc "Foddex" Oude Kotte, who used to be located in Enschede, The Netherlands, but now in Stockholm, Sweden!
MySQL SUM whitespace weirdness [updated]
Originally posted at Fri 17-04-2009 09:07:46
, in the nerd stuff category.
I just found out that MySQL seems to have difficulties with whitespace in a very, very weird way. I needed to summarize all sizes for all documents stored in a customer's database, and so I executed this query (literally):
SELECT SUM (size) FROM `documents`
To my great surprise and frustration MySQL responded with:
FUNCTION dbname.SUM does not exist
Eh, 'xcuse me
? Who's the genius who decided that SUM is no longer a function we want in MySQL? Turns out that removing the space between SUM and the parenthesis open did the trick:
SELECT SUM(size) FROM `documents`
And voila, my results....
I know MySQL can be a bit strange at times, but this one was a bit too much for me. Can anyone enlighten me on this? I'm running server version 5.0.45-community-nt on a Fedora 9 box.
[ update ]
I found this
page.... I'm.... flabbergasted, to put it mildly...