[TASK] Functional tests: Enable MySQL strict mode / data validation 86/42986/2
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Wed, 2 Sep 2015 18:07:14 +0000 (20:07 +0200)
committerChristian Kuhn <lolli@schwarzbu.ch>
Tue, 15 Sep 2015 08:47:18 +0000 (10:47 +0200)
Enable SQL mode options that force MySQL to be more strict and not
allow legacy defaults which truncate data, accept invalidate dates
or silently change values on INSERT/UPDATE.

STRICT_ALL_TABLES: Strict SQL mode for all tables, reject invalid data
ERROR_FOR_DIVISION_BY_ZERO: Division by zero produces an error
NO_AUTO_VALUE_ON_ZERO: Only NULL generates the next auto_incroment number
NO_ENGINE_SUBSTITUTION: No automatic substitution of unavailable engines
NO_ZERO_DATE: Don't treat '0000-00-00' as a valid date
NO_ZERO_IN_DATE: Dates with zero parts are not permitted
ONLY_FULL_GROUP_BY: Deny invalid use of aggregation functions

Resolves: #69484
Releases: master
Change-Id: Ife3755b56339a479d86c5535a301ebef1563ace8
Reviewed-on: http://review.typo3.org/42986
Reviewed-by: Stephan GroƟberndt <stephan@grossberndt.de>
Reviewed-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Tested-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>

index 4c6b760..e6e6116 100644 (file)
@@ -4,5 +4,6 @@ return array(
                'displayErrors' => '1',
                'debugExceptionHandler' => '',
                'trustedHostsPattern' => '.*',