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.

貢獻者指南