Project

General

Profile

Actions

Bug #93491

closed

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

Added by Stephan Großberndt over 3 years ago. Updated about 3 years ago.

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.


Related issues 2 (1 open1 closed)

Related to TYPO3 Core - Epic #90719: PostgreSQL related issuesAccepted2020-03-10

Actions
Related to TYPO3 Core - Bug #93568: Revert database-related changes in Schema Diff / MigratorClosedBenni Mack2021-02-23

Actions
Actions

Also available in: Atom PDF