I reviewed most of the changes from the v4 Google patch today. My
head hurts now. During this review I checked whether bugs fixed
in the patch have also been fixed in recent releases of official
MySQL. I am happy that most of them have been fixed. But some
changes will never be accepted, such as the one that added
support for INF for FLOAT/DOUBLE columns.
The default value of sql_mode is the empty string. You probably want to change that before your applications come to depend on it. When it is the empty string, invalid values are coerced to valid values on INSERT …