[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)
commit37df07e8252e65d51b791f1956fc989817d0def9
treeabe82061b0752d02ef402d9b5b44d562691889c3
parentbb6064419d449e151535599a82a34e1fda675909
[TASK] Functional tests: Enable MySQL strict mode / data validation

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>
typo3/sysext/core/Build/Configuration/FunctionalTestsConfiguration.php