Project

General

Profile

Actions

Bug #104297

closed

Ensure correct column type in database compare for SQLite

Added by Stefan Bürk 5 months ago. Updated 5 months ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-07-02
Due date:
% Done:

100%

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

Description

Since Doctrine DBAL 4 field types are no longer communicated based
column field comments [1]. Database vendors not supporting certain
types, for example JSON in case of SQLite, the type retrieved from
reading the database schema does not match when compared with the
virtual database column type. Doctrine interally mitigates this by
using a new way of comparision by comparing the compatible create
statements for the database vendor.

Sadly, this comparision has been disabled and worked around during
the Doctrine DBAL 4 upgrade and still cannot be removed until open
issues have been properly integrated.

[1] https://github.com/doctrine/dbal/blob/4.0.x/UPGRADE.md#bc-break-removed-platform-commented-type-api


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #104319: SQLite Install TYPO3v13: sys_reactions and sys_webhook create endless DB Analyzer cycleClosedStefan Bürk2024-07-06

Actions
Actions #1

Updated by Gerrit Code Review 5 months ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/85086

Actions #2

Updated by Gerrit Code Review 5 months ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/85086

Actions #3

Updated by Stefan Bürk 5 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Stefan Bürk 5 months ago

  • Related to Bug #104319: SQLite Install TYPO3v13: sys_reactions and sys_webhook create endless DB Analyzer cycle added
Actions #5

Updated by Benni Mack 5 months ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF