Issue Bug Closed

#81784DatabaseConnection function INSERTmultipleRows does not allow NULL values

Christian Reiter 07/04/17, 13:43 updated 09/27/18, 16:37

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…)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.