1202509 - Force MySQL to use mode STRICT_ALL_TABLES

Status: NEW

(Bugzilla :: Database, enhancement)

Description

[Frédéric Buclin]

We currently disable the MySQL strict mode for bad reasons; see bug 321645 for details. This has the side-effect to put MySQL in a lenient mode, where too long strings are truncated before being inserted into the DB instead of throwing an error like PostgreSQL does. This can have dramatic consequences, such as bug 1202447.

The right fix is to force MySQL strict mode using STRICT_ALL_TABLES and to fix our DB schema and upgrade tools accordingly. This way, when a too long string is inserted into the DB, you get:

DBD::mysql::db do failed: Data too long for column '...' at row 1 [for Statement "INSERT INTO ..."

and the whole DB transaction is reverted. This is much better and safer than to insert truncated data (data corruption).

Comment 1

[Frédéric Buclin]

Attachment: WIP, v0.1

Very early work. But this lets you create a new DB with strict mode enabled.