Project

General

Profile

Actions

Bug #91615

open

Removing fields from ext_tables.sql is not recognized by Analyze Database Structure when using Postgres

Added by Thomas Uchtmann over 4 years ago. Updated 4 months ago.

Status:
Needs Feedback
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2020-06-08
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

While using Postgres as the database provider, field removals are not recognized, neither through BE nor through helhum/typo3-console.
Creation of Fields, creation of Tables and deletions of Tables are recognized as well as changing of field definitions.

After changing the database provider to mysql and installing all tables anew, field deletions where once again recognized.

How to recreate:
  • Go to maintenance > Analyze Database. There should be no changes pending.
  • Add a new field into ext_tables.sql
  • run Analyze Database again, pending changes will show.
  • Apply pending changes.
  • Remove the newly added field from ext_tables.sql
  • run Analyze Database again.
    • Expected behavior:
      • Removal of field should be shown.
    • Experienced behavior:
      • No pending database changes are shown.

Enviroment DDEV PHP 7.4 with Postgres DB and TYPO3 Version 10.4.3, find configuration for Postgres Container attached.
After starting ddev add the following configuration to your LocalConfiguration.php:

    'DB' => [
        'Connections' => [
            'Default' => [
                'charset' => 'utf8',
                'dbname' => 'db',
                'driver' => 'pdo_pgsql',
                'host' => 'postgres',
                'password' => 'db',
                'port' => 5432,
                'user' => 'db',
            ],
        ],
    ],


Files

docker-compose.postgres.yaml (740 Bytes) docker-compose.postgres.yaml Thomas Uchtmann, 2020-06-08 17:04
Actions #1

Updated by Thomas Uchtmann over 4 years ago

  • Description updated (diff)
Actions #2

Updated by Thomas Uchtmann over 4 years ago

  • Description updated (diff)
Actions #3

Updated by Stefan Bürk 4 months ago

  • Status changed from New to Needs Feedback
  • Assignee set to Stefan Bürk

@korno_

v10 is out of support now - does this issue still occur on newer versions ?

Literally, the core has functional tests for table field removals. Do you have more insight ? Is the field really removed from all occurances (ext_tables.sql, ext_tables_static+adt.sql, no schema hook/event listener, ...

How did you checked that (removing a field etc) ?

Actions

Also available in: Atom PDF