Description:
When issuing a command containing both a GROUP BY and an ORDER BY clause, the server
is returning no results. This issue has
arisen since upgrading from 3.23.47 to 4.0.1
How-To-Repeat:
Table Creation:
CREATE TABLE statarchive (uid INT unsigned NOT NULL AUTO_INCREMENT, referal
Description:
This problem is being experienced on both MySQL 4.0.0 and 4.0.1.
Currently the system's timezone is set to PST, and MySQL's timezone variable
is PST (no problem there)
However if I do a NOW() on the system, the returned result is 8 hours earlier
that the