Comment 5 for bug 388889

Jeff,

Which version of Drizzle are you using?

Also, I need a little more data to resolve this... when trying to reproduce the bug, I mock up a data set and I can't get the test to fail, as shown in the output below..

Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 2
Server version: 2009.06.1057-bugs Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

drizzle> use test
Database changed
drizzle> create table t1 (id int not null, post_date datetime not null, primary key (id));
Query OK, 0 rows affected (0.01 sec)

drizzle> insert into t1 values (1, '2009-08-02');
Query OK, 1 row affected (0.01 sec)

drizzle> insert into t1 values (2, '2009-07-02');
Query OK, 1 row affected (0 sec)

drizzle> SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(id) as posts FROM t1 GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC;
+------+-------+-------+
| year | month | posts |
+------+-------+-------+
| 2009 | 8 | 1 |
| 2009 | 7 | 1 |
+------+-------+-------+
2 rows in set (0 sec)