TYPO3 Core

How to test it:
set mysql setting in my.cnf:

sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

This is the default fro mysql 5.7
run some functional test, like:

typo3DatabaseName='t37_core_test' typo3DatabaseHost='localhost' typo3DatabaseUsername='user' typo3DatabasePassword='password' bin/phpunit -c vendor/typo3/testing-framework/Resources/Core/Build/FunctionalTests.xml typo3/sysext/workspaces/Tests/Functional/DataHandling/IRRE/ForeignField/Modify/ActionTest.php --filter changeParentContentSorting

without a patch you should see an error:

1) TYPO3\CMS\Workspaces\Tests\Functional\DataHandling\IRRE\ForeignField\Modify\ActionTest::changeParentContentSorting
SQL Error for table "tx_irretutorial_1nff_price": 
An exception occurred while executing 'INSERT INTO `tx_irretutorial_1nff_price` (`uid`, `pid`, `sorting`, `deleted`, `sys_language_uid`, `l18n_parent`, `l18n_diffsource`, `t3ver_wsid`, `t3ver_state`, `t3ver_stage`, `t3ver_oid`, `t3ver_move_id`, `title`, `parentid`, `parenttable`, `parentidentifier`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["7", "89", "1", "0", "0", "0", "", "0", "0", "0", "0", "0", "Price #1.1.1", "5", "tx_irretutorial_1nff_offer", ""]:

Field 'price' doesn't have a default value