Bug #55201 Date-time bug on select
Submitted: 13 Jul 2010 3:30 Modified: 13 Jul 2010 18:41
Reporter: Alexey Nikitayev Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.5.3 m3 OS:Windows
Assigned to: CPU Architecture:Any
Tags: regression

[13 Jul 2010 3:30] Alexey Nikitayev
Description:
SELECT * FROM trains t where datecom>'2010-07-01'; good

SELECT * FROM trains t where datecom>'2010-07-1'; good

SELECT * FROM trains t where datecom>'2010-7-1'; failed

How to repeat:
always repeat
[13 Jul 2010 10:23] Susanne Ebrecht
Many thanks for writing a bug report.

I am neither able to repeat this by using MySQL 5.1 nor by using MySQL 5.6.99-m4.

Seems like you hit a temporally issue that already is fixed in more actual trees.
[13 Jul 2010 18:26] Alexey Nikitayev
I tested this sql query under 5.5.3 m3 windows release. I hope this bug will fix in next release.
[13 Jul 2010 18:41] Alexey Nikitayev
failed = is empty result, not crash server!