Project

General

Profile

Actions

Bug #92959

closed

ConnectionMigrator must ignore unmapped tables on non-default connection

Added by Stephan Großberndt almost 4 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2020-11-30
Due date:
% Done:

100%

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

Description

When comparing the current database state with the wanted state, e.g. in the 'Upgrade Wizard' of the Install Tool, TYPO3 currently iterates all tables of non-default connections and fetches their detail information. Later on all information for tables which are not mapped to that connection in the 'TableMapping' are discarded.

This is
  • slow: fetching info of details of 100 tables when only 2 mapped tables need to be compared
  • error-prone: if a table in the database of a non-default connection contains data types doctrine/dbal cannot handle (e.g. xml), the SchemaDiff will fail completely
Actions

Also available in: Atom PDF