#67442Setting NOT NULL on „BLOB“ column in Install Tool
Description
To see this bug most patches under review for DBAL must be in the working tree, otherwise this will be swallowed by other bugs!
When the InstallTool suggests a change like this:
ALTER TABLE sys_category CHANGE l10n_diffsource l10n_diffsource longblob NOT NULL; Current value: longblob
this alteration will not be performed, it seems as if the NOT NULL is being silently swallowed, the statements logged by the DB server for this alteration are:
LOG: statement: ALTER TABLE "sys_category" ALTER COLUMN "l10n_diffsource" TYPE BYTEA LOG: statement: ALTER TABLE "sys_category" ALTER COLUMN "l10n_diffsource" SET DEFAULT ''
Manually setting the field to NOT NULL using a statement like this:
ALTER TABLE sys_category ALTER COLUMN l10n_diffsource SET NOT NULL; <pre> works and will be recognized by the install tool. Test Environment: TYPO3 7.3-dev@master + DBAL patches PostgreSQL 9.4.1