Bug #51660 | allow empty fields in dates, integers, etc. | ||
---|---|---|---|
Submitted: | 2 Mar 2010 22:47 | Modified: | 28 Dec 2012 19:22 |
Reporter: | ivo welch | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: General | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[2 Mar 2010 22:47]
ivo welch
[28 Dec 2012 19:22]
Sveta Smirnova
Thank you for the report. You use TRADITIONAL SQL mode which includes NO_ZERO_IN_DATE SQL mode. Just don't set such a mode and you will get desired results. If you need other SQL modes which TRADITIONAL sets, specify them explicitly and don't use this shortcut. This is not MySQL bug and this feature is already implemented.