The example query comparing a datetime column against NOW() returns an empty set of rows under 3.23.49. The same query against the same database returns two rows under 3.23.48. In my opinion the 3.23.48 behaviour is correct and 3.23.49 appears to be incorrect. This happens under Linux 6.2 using the standard MySQL RPMs. The reason behind this seems to be that 3.23.49 has a different concept of what NOW() means, ie. NOW() under 3.23.49 reports GMT/UTC while NOW() under 3.23.48 and earlier uses the localtime. The script extracts below show this.
Is this a documented feature change in 3.23.49 or a bug or something related to Linux 6.2 libraries or ...? For the time being I will stick with 3.23.48 to avoid all my applications breaking. Manuel -------------------------------------------------------------------------- Your MySQL connection id is 1 to server version: 3.23.49 mysql> select EventNotifierID, EventTime, NOW() from EventNotifiers where EventTime < NOW(); Empty set (0.04 sec) mysql> select NOW(); +---------------------+ | NOW() | +---------------------+ | 2002-02-25 03:30:01 | +---------------------+ 1 row in set (0.00 sec) -------------------------------------------------------------------------- Your MySQL connection id is 1 to server version: 3.23.48 mysql> select EventNotifierID, EventTime, NOW() from EventNotifiers where EventTime < NOW(); +-----------------+---------------------+---------------------+ | EventNotifierID | EventTime | NOW() | +-----------------+---------------------+---------------------+ | 80302 | 2002-02-25 10:38:02 | 2002-02-25 11:31:04 | | 80301 | 2002-02-25 09:18:59 | 2002-02-25 11:31:04 | +-----------------+---------------------+---------------------+ 2 rows in set (0.10 sec) mysql> select NOW(); +---------------------+ | NOW() | +---------------------+ | 2002-02-25 11:31:06 | +---------------------+ 1 row in set (0.00 sec) -------------------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
