Bug #68602
NULL values in records get transformed to FALSE on T3D import
| Status: | New | Start date: | 2015-07-29 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Morton Jonuschat | % Done: | 0% |
|
| Category: | Import/Export (T3D) | Spent time: | - | |
| Target version: | 7.5 | |||
| TYPO3 Version: | 7 | Is Regression: | No | |
| PHP Version: | 5.6 | Sprint Focus: | ||
| Complexity: |
Description
Given a database record with a NULL value in a column the export file generated will have a XML node like <field index="link" type="NULL"></field> - properly representing the NULL value.
On Import the value gets transformed into a boolean somewhere during the import.
Related issues
History
#1 Updated by Marc Bastian Heinrichs about 16 hours ago
Wondering about this error. With #55082 this was normally fixed. And if you look at the assertion importPagesAndRelatedTtContentWithDifferentImageToExistingData.csv you see that link is asserted NULL.
#2 Updated by Morton Jonuschat about 6 hours ago
If I understand this correctly then the test should fail even when not running in MySQL strict mode. The link field in sys_file_reference is defined as "NOT NULL" with a default of '' (empty string). So the conversion of FALSE to '' makes this test pass?