MySQL 4.0.1 bug ... no returned results using GROUP and ORDER

2002-02-05 Thread 2bunnyhop
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

NOW() is returning incorrect value

2002-01-15 Thread 2bunnyhop
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