Bug #91615
openRemoving fields from ext_tables.sql is not recognized by Analyze Database Structure when using Postgres
0%
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.
- Expected behavior:
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
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) ?