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 about 4 years ago. Updated about 4 years ago.

Status:
New
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 about 4 years ago

  • Description updated (diff)
Actions #2

Updated by Thomas Uchtmann about 4 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF