It works on 3.23.25. I just tried it on my server, Linux6.1 and MySQL 3.23.21 and it worked too. Maybe it's a bug in 3.23.27, check msyql.com to see if it's listed.
<pre>
mysql> show columns from test;
+----------+------------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+----------+------------+------+-----+---------+-------+---------------------------------+
| ticketid | int(11) | YES | | NULL | | select,insert,update,references |
| total | float(5,2) | YES | | NULL | | select,insert,update,references |
+----------+------------+------+-----+---------+-------+---------------------------------+
2 rows in set (0.00 sec)
mysql> select * from test;
+----------+-------+
| ticketid | total |
+----------+-------+
| 1 | 1.25 |
| 1 | 2.50 |
| 2 | 1.25 |
+----------+-------+
3 rows in set (0.00 sec)
mysql> select ticketid,sum(total) from test group by ticketid;
+----------+------------+
| ticketid | sum(total) |
+----------+------------+
| 1 | 3.75 |
| 2 | 1.25 |
+----------+------------+
2 rows in set (0.00 sec)
mysql> select version();
+------------------+
| version() |
+------------------+
| 3.23.21-beta-log |
+------------------+
1 row in set (0.00 sec)
</pre>
---John Holmes...
