Comparator fails for BLOBS

[thomashohn]

In the TYPO3 project we use the diffColumn method in the class Doctrine\DBAL\Schema. Unfortunately this method fails to detect changes in BLOB columns. So changing a column from BLOB to another BLOB type fails - which is problematic in an MySql env.

[Ocramius]

@thomashohn this needs a test case, as the issue as reported is too superficial.

[thomashohn]

Create the following table:
create table test (
ablob blob
)

Try to change the column to ablob medium blob - the diffColumn doesn't catch this case.

[chrisguitarguy]

Seems like this happens because the the MySqlPlatform uses length to determine blob size, but length is only diffed for a few types.

[Defcon0]

Is there any progress here? We‘re also experiencing this issue in our contao cms instance :-(

[ausi]

this needs a test case, as the issue as reported is too superficial.

I created pull request #4551 to fix this issue, it includes several test cases.

[morozov]

This bug will be indirectly covered by the Doctrine\DBAL\Tests\Functional\Schema\MySQL::testLobLengthIncrementOverLimit test in #4746.

Additionally,

$connection->executeStatement('DROP TABLE IF EXISTS test');
$connection->executeStatement('CREATE TABLE test (ablob BLOB)');

$sm = $connection->createSchemaManager();
$desiredTable = $sm->listTableDetails('test');

$connection->executeStatement('ALTER TABLE test MODIFY COLUMN ablob MEDIUMBLOB');

$actualTable = $sm->listTableDetails('test');

$comparator = $sm->createComparator();
$diff = $comparator->diffTable($desiredTable, $actualTable);
var_dump($diff);
/*
class Doctrine\DBAL\Schema\TableDiff#49 (14) {
    ...
}
*/

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.