rails/rails — pull request #6069 by mipearson (2012-04-30 00:37:46+00:00)
Title: Use strict mode in mysql

MySQL, by default, opts to truncate or replace rather than 'fail fast' on incompatible data. This can lead to confusion, frustration and data loss.

This is inconsistent with two other popular database engines: PostgreSQL will error (since v 7.2) and sqlite will simply allow the original data (rather than modifying it).

Defaulting to STRICT_ALL_TABLES will ease error discovery and prevent new applications from depending on MySQL's quirks.