Bug #30796 Timestamp comparison in invalid date format

• Submitted: 4 Sep 2007 14:18
• Modified: 4 Oct 2007 14:47
• Reporter: Marco Novo
• Status: No Feedback
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.0.22
• OS: Linux
• CPU Architecture: Any
• Tags: <, comparison, invalid date format, timestamp

[4 Sep 2007 14:18] Marco Novo

Description:
I have a problem with an installation of MySQL

# Server version: 5.0.22
# Protocol version: 10
# Server: Localhost via UNIX socket

and a query like this:

SELECT * FROM table
WHERE
date1 >= '2007-08-01 00:00:00'
AND
date1 <= '2007-09-31 00:00:00'

The second date 2007-09-31 00:00:00 is obviously not valid 31 September (out of 30).

But this query WORK! in my previous installation of MySQL
# Server version: 4.1.12
# Protocol version: 10
# Server: Localhost via UNIX socket

I try to use ALLOW_INVALID_DATES but it seems not to work.

Some ideas or helps?

How to repeat:
SELECT * FROM table
WHERE
date1 >= '2007-08-01 00:00:00'
AND
date1 <= '2007-09-31 00:00:00'

[4 Sep 2007 14:47] MySQL Verification Team

Thank you for the bug report. Your server version is pretty older, could
you please test with the latest released version 5.0.45 and comment here
the results. Thanks in advance.

[4 Oct 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".