Bug #90754

Database Compare with SQLite can not be finished

Added by Daniel Siepmann about 2 years ago. Updated about 2 years ago.

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

100%

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

Description

With current master, and since some v10 releases already, I can't finish the database compare using SQLite.

I've attached a screenshot of the result when executing the compare, together with a file containing the output of the compare beforehand:

liayn1 8 minutes ago
I added a dummy column to the pages table locally and did a compare.
it showed me the option to rename the column to zzz_, this worked without errors.
Now I see the same suggestion again and additionally the statements to drop the zzz field.
So this is some different bug indeed


Files

Screenshot from 2020-03-13 09-29-37.png (128 KB) Screenshot from 2020-03-13 09-29-37.png Daniel Siepmann, 2020-03-13 10:01
compare.txt (111 KB) compare.txt Daniel Siepmann, 2020-03-13 10:01

Related issues

Related to TYPO3 Core - Bug #90758: Renaming of column does work in sqlite with db compareClosedMarkus Klein2020-03-13

Actions
Related to TYPO3 Core - Bug #94710: Database Compare "Change fields" with SQLite shows red errorUnder Review2021-08-04

Actions
Related to TYPO3 Core - Bug #94709: TypeError for SQLite in DB CompareClosedDaniel Siepmann2021-08-04

Actions
Follows TYPO3 Core - Bug #90751: database compare shows differences for fresh installationClosed2020-03-12

Actions

Also available in: Atom PDF