bug #37117 [Messenger/DoctrineBridge] set column length for mysql 5.6 compatibility (Nemo64)

nicolas-grekas · nicolas-grekas · commit 717de3ef871e · 2020-06-07T17:46:15.000+02:00
This PR was merged into the 5.1 branch. Discussion ---------- [Messenger/DoctrineBridge] set column length for mysql 5.6 compatibility MySQL 5.6 does not support more than 191 characters when an index is used and when using utf8mb4 as charset. As a workaround, I define the length of the queue_name field. | Q | A | ------------- | --- | Branch? | 5.1 | Bug fix? | yes | New feature? | no | Deprecations? | no | Tickets | Fix #37116 | License | MIT Commits ------- d121906 set column length for mysql 5.6 compatibility
diff --git a/src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/Connection.php b/src/Symfony/Component/Messenger/Bridge/Doctrine/Transport/Connection.php
@@ -390,6 +390,7 @@ private function addTableToSchema(Schema $schema): void
         $table->addColumn('headers', self::$useDeprecatedConstants ? Type::TEXT : Types::TEXT)
             ->setNotnull(true);
         $table->addColumn('queue_name', self::$useDeprecatedConstants ? Type::STRING : Types::STRING)
+            ->setLength(190) // mysql 5.6 only supports 191 characters on an indexed column in utf8mb4 mode
             ->setNotnull(true);
         $table->addColumn('created_at', self::$useDeprecatedConstants ? Type::DATETIME : Types::DATETIME_MUTABLE)
             ->setNotnull(true);
