MySQL GroupBy improper quoting

[intel352]

Okay, so maybe I'm not using GroupBy as intended, but I've found that when specifying a column to be grouped, the column string is returned back, single-quoted. This results in unexpected behavior in MySQL. For instance, if I run the resulting query (with a single-quoted column), I get 1 row returned from the query. If I run the query with a backtick/apostrophe-quoted column, I get a range of rows, grouped properly.

I believe this is due to the GroupBy class passing the string into Crystal_Helper_Mysql::add_single_quote instead of Crystal_Helper_Mysql::add_apostrophe

Just a note, the postgres GroupBy method uses Crystal_Helper_Postgres::sanitize_string instead, which is quite an interesting difference.