Bug #28282 Wrong DATETIME comparison in INTERVAL function.

• Submitted: 7 May 2007 14:16
• Modified: 7 May 2007 14:41
• Reporter: Evgeny Potemkin
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0+
• OS: Any
• Assigned to: Evgeny Potemkin
• CPU Architecture: Any

[7 May 2007 14:16] Evgeny Potemkin

Description:
mysql> select interval(cast('01-01-02' as date),'01-01-01','01-01-03', '01-01-05') as tt;
+----+
| tt |
+----+
|  3 | 
+----+
1 row in set, 3 warnings (0.00 sec)

mysql> show warnings;
+---------+------+----------------------------------------------+
| Level   | Code | Message                                      |
+---------+------+----------------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: '01-01-01' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: '01-01-03' | 
| Warning | 1292 | Truncated incorrect DOUBLE value: '01-01-05' | 
+---------+------+----------------------------------------------+
3 rows in set (0.00 sec)

mysql> select version();
+-------------------+
| version()         |
+-------------------+
| 5.0.42-gcov-debug | 
+-------------------+
1 row in set (0.00 sec)

How to repeat:
See description.

Suggested fix:
Implement a correct DATETIME comparison.