michael-s-molina commented on code in PR #25115:
URL: https://github.com/apache/superset/pull/25115#discussion_r1310093071


##########
UPDATING.md:
##########
@@ -24,6 +24,7 @@ assists people when migrating to a new version.
 
 ## Next
 
+- [25053](https://github.com/apache/superset/pull/25053): Extends the 
`ab_user.email` column from 64 to 320 characters which is has an associated 
unique key constraint. This will problematic for MySQL metadata databases which 
use the InnoDB storage engine with the  `innodb_large_prefix` parameter 
disabled as the key prefix limit is 767 bytes. Enabling said parameter and 
ensuring that the table uses either the use the `DYNAMIC` or `COMPRESSED` row 
format should remedy the problem. See 
[here](https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html) for more 
details.

Review Comment:
   ```suggestion
   - [25053](https://github.com/apache/superset/pull/25053): Extends the 
`ab_user.email` column from 64 to 320 characters which has an associated unique 
key constraint. This will problematic for MySQL metadata databases which use 
the InnoDB storage engine with the  `innodb_large_prefix` parameter disabled as 
the key prefix limit is 767 bytes. Enabling said parameter and ensuring that 
the table uses either the use the `DYNAMIC` or `COMPRESSED` row format should 
remedy the problem. See 
[here](https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html) for more 
details.
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to