[aur-dev] [PATCH] MySQL unique index on Email column too long

Lukas Fleischer lfleischer at archlinux.org
Thu Nov 12 19:50:22 UTC 2015


On Thu, 12 Nov 2015 at 09:34:23, Stefan Auditor wrote:
> Using unique indexes on varchar fields with a character count of more than 255
> on InnoDB tables with utf8 encoding produces an error in MySQL.
> Also as per https://www.rfc-editor.org/errata_search.php?eid=1690 it seems that
> the maximum length for email addresses is limited to 254 characters.
> 
> Fixes FS#47038
> 
> Signed-off-by: Stefan Auditor <stefan.auditor at erdfisch.de>
> ---
>  schema/aur-schema.sql | 2 +-
>  upgrading/4.2.0.txt   | 2 +-
>  2 files changed, 2 insertions(+), 2 deletions(-)
> [...]

Applied, thanks!


More information about the aur-dev mailing list