Issue Bug Closed

#93491Removed columns are not recognized when analyzing the database using PostgreSQL (and not renamed to zzz_deleted_)

Stephan Großberndt 02/11/21, 15:46 updated 05/11/21, 16:00

Description

If a column of a table has been removed in a ext_tables.sql definition the according change to rename it adding the prefix zzz_deleted_ is not done on PostgreSQL.

How to reproduce:

1. Have TYPO3 installation running on a PostgreSQL database
2. Remove a column from an ext_tables.sql definition, e.g. be_users.avatar in sysext/core/ext_tables.sql
3. Go to “Maintenance” and click on “Analyze database“
4. There is no statement for renaming be_users.avatar to be_users.zzz_deleted_avatar

This may lead to major issues if columns are removed which require a certain datatype that is not set as default, leading to making it impossible to add rows to the table.

Reviews 4