#53662DatabaseConnection INSERTquery does not allow NULL values
Description
When you create a new record that has input fields with the new eval NULL setting the value is set correctly to NULL in the DataHandler but it is inserted as an empty string in the database.
The reason for this is, that the INSERTQuery() method in the DatabaseConnection class does not supply the $allowNull parameter to the fullQuoteArray() method. The UPDATEquery() method already does this so this can also be enabled for INSERTQuery().
Reviews 3
Related issues 7
- Feature #41773Add possibility to store NULL values
- Bug #54412Improve default value handling for NULL value fields
- Bug #54849Functional tests cannot write to backend log
- Bug #54917Debug "Column 'first' cannot be null"
- Bug #55989Debug "Column 'cookie' cannot be null"
- Bug #63991FAL override checkboxes are always active, when DBAL is installed
- Bug #81784DatabaseConnection function INSERTmultipleRows does not allow NULL values