MySQL Bugs: #73237: "it is not the job of the SQL server to validate dates" from /r/Database

Bug #73237	"it is not the job of the SQL server to validate dates" from /r/Database
Submitted:	9 Jul 2014 1:34	Modified:	2 Mar 2015 15:19
Reporter:	Jaime Crespo (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.6, 5.7	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	Docs, sql mode

Description:
After reading this thread on Reddit http://www.reddit.com/r/Database/comments/2a5exn/from_the_mysql_documentation_it_is_not_th... , I consider myself the issue reported as a valid bug.

How to repeat:
Go to:

http://dev.mysql.com/doc/refman/5.1/en/constraint-invalid-data.html

It says:

"The idea is that it is not the job of the SQL server to validate dates."

Suggested fix:
It should say:

"This behavior is maintained (unless a strict mode is used) to prevent incompatibility problems with older applications."

as a softer approach:

"In this case, the aplication will be fully responsible to validate dates".

As usual, Paul, you may find a better wording.

I would suggest only changing it for 5.6 and 5.7.

For viewers of the bug: common free and commercial pieces of software like Cacti doesn't work if this behavior is changed.

Hello Jaime,

Thank you for the report.

Thanks,
Umesh

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

I'll change the wording to:

In this case, when an application that has not enabled strict SQL
mode, it up to the application to validate the dates before storing
them.

With all due respects (and sorry for reopening this), the new text:

"In this case, when an application that has not enabled strict SQL mode, it up to the application to validate the dates before storing them."

doesn't look like gramatically/lexically correct. But I am not a native speaker. What about:

"In this case -when an application has not enabled strict SQL mode- it is up to the application to validate the dates before storing them."

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.