bug #37697 [Messenger] reduce column length for MySQL 5.6 compatibility (xabbuh)

nicolas-grekas · nicolas-grekas · commit b6ea86e7a200 · 2020-07-29T16:49:14.000+02:00
This PR was merged into the 4.4 branch. Discussion ---------- [Messenger] reduce column length for MySQL 5.6 compatibility | Q | A | ------------- | --- | Branch? | 4.4 | Bug fix? | yes | New feature? | no | Deprecations? | no | Tickets | Fix #37116 | License | MIT | Doc PR | Commits ------- bc5f35c reduce column length for MySQL 5.6 compatibility
diff --git a/src/Symfony/Component/Messenger/Transport/Doctrine/Connection.php b/src/Symfony/Component/Messenger/Transport/Doctrine/Connection.php
@@ -368,6 +368,7 @@ private function getSchema(): Schema
         $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);
