Project

General

Profile

Actions
Copy link

Bug #81784

closed

DatabaseConnection function INSERTmultipleRows does not allow NULL values

Added by Christian Reiter almost 7 years ago. Updated over 5 years ago.

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

0%

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

Description

Just like issue #53662 which affected INSERTquery:

the INSERTmultipleRows() method in the DatabaseConnection class does not supply the $allowNull parameter to the fullQuoteArray() method.

This causes values that should be NULL to be inserted as empty strings '' instead.

Visible frontend effects will for instance happen with sys_file_reference (title = NULL means no element specific value so load title from sys_file_metadata; title = '' means empty string as specific value - result in a filelinks element would be showing filename instead of metadata title...)

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #53662: DatabaseConnection INSERTquery does not allow NULL valuesClosed2013-11-15

Actions
Actions
Copy link

Also available in: Atom PDF