Bug #68562

Epic #68397: Make TYPO3 work with MySQL strict mode

Bool values need to be cast to integer for MySQL strict mode

Added by Morton Jonuschat over 5 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2015-07-27
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

MySQL strict mode doesn't accept '' as a valid value to store in an integer column if the MySQL is run in strict mode.
Boolean values are cast by mysqli_real_escape string to '1' (for TRUE) and '' (for FALSE). Due to this special handling is required for boolean values to result in '0' and '1' for FALSE/TRUE


Related issues

Related to TYPO3 Core - Bug #68418: scheduler chokes on mysql strict modeClosedMorton Jonuschat2015-07-21

Actions
Related to TYPO3 Core - Bug #68602: NULL values in records get transformed to FALSE on T3D importClosedMorton Jonuschat2015-07-29

Actions
#1

Updated by Morton Jonuschat over 5 years ago

  • Status changed from New to In Progress
#2

Updated by Gerrit Code Review over 5 years ago

  • Status changed from In Progress to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/41993

#3

Updated by Morton Jonuschat over 5 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#4

Updated by Christian Kuhn over 5 years ago

  • Status changed from Resolved to New

patch was unfortunately reverted with https://review.typo3.org/#/c/42076/

#5

Updated by Morton Jonuschat over 5 years ago

After discussion with Stefan Neufeind the initial implementation is still the best way to go, but the bug(s) in EXT:impexp need to be fixed first. Additionally this should be marked as breaking to be on the safe side.

#7

Updated by Gerrit Code Review over 5 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42376

#8

Updated by Morton Jonuschat over 5 years ago

  • Status changed from Under Review to Resolved
#9

Updated by Riccardo De Contardi about 3 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF