Actions
Bug #93491
closedRemoved columns are not recognized when analyzing the database using PostgreSQL (and not renamed to zzz_deleted_)
Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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.
Actions