Issue Bug Closed

#67442Setting NOT NULL on „BLOB“ column in Install Tool

Morton Jonuschat 06/14/15, 13:47 updated 10/02/18, 11:44

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

Reviews 1