MySQL Bugs: #73664: sql_mode = strict report to MySQL error log

Bug #73664	sql_mode = strict report to MySQL error log
Submitted:	21 Aug 2014 8:00
Reporter:	Oli Sennhauser	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	any	OS:	Any (n.a.)
Assigned to:		CPU Architecture:	Any
Tags:	error log, SQL_MODE

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Switching sql_mode to a more strict mode than default could cause problems or errors in the application.

When we would have the possibility to tell MySQL to log problems cause by a more strict mode only to the error log instead of rising an error, we could fist enable this mode fix all the problems, and then switch to the real more strict mode.

How to repeat:
n.a.

Suggested fix:
sql_mode = log_conflicts_only, strict, ...