> > Here's the problem: there needs to be either an asterisk or a column > name inside the parens after COUNT. (That's a SQL standard rule AFAIK). > > But I'm also noticing a bug in COUNT (*), fixed now in the development > version. I can send it to you or you can wait for a release in a few > days. Or you can do "SELECT COUNT ($col) .." for a column that exists > in every row and get the same result.
Is this also true for a 'SELECT COUNT(FIELD) FROM TABLE'? What is the current version of SQL::Statement? I am using 0.1016
