yesodweb/persistent

MySQL backend generates foreign keys over length limit

开放

#1,000 创建于 2019年12月29日

 (0 条评论) (0 个反应) (0 位负责人)Haskell (302 个派生)auto 404
MySQLSQLbugfixgood first issue

仓库指标

星标
 (484 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

Currently, persistent-mysql suggests foreign key constraint names that are over MySQL's length limit of 64 characters, which MySQL will throw an error for.

persistent-mysql should generate truncated names that don't go over the length limit. It could use the same logic as is introduced in #996 for truncating Postgres keys, or logic that better matches MySQL's naming conventions.

This issue is discussed in greater detail in #996, which adds tests for it. This issue is mostly to track the issue being resolved for MySQL, since #996 will be closed after it resolves it for Postgres.

贡献者指南