phinx icon indicating copy to clipboard operation
phinx copied to clipboard

dropForeignKey does not allow removal of constraints containing whitespaces

Open nijencc opened this issue 9 years ago • 3 comments

The code from ./src/Db/Adapter/MysqlAdapter.php:700-707 in MysqlAdapter::dropForeigKey(...) at Lines 700-707, doesn't quote $constraint with MysqlAdapter::quoteColumnName(...). As a result, dropping a foreign key constraint with whitespaces (which made me notice it), e.g. "i am a silly test", is not possible. My current workaround is to quote the name with backticks, manually.

nijencc avatar Jul 27 '16 16:07 nijencc

Are you able to provide a pull request with your suggested changes?

dereuromark avatar Oct 08 '17 17:10 dereuromark

using whitespace is definitely not typical.

Closing due to lack of activity or out of scope. If there is new interest, please open a PR.

othercorey avatar May 09 '20 01:05 othercorey

@othercorey could this be re-opened.

MasterOdin avatar May 11 '20 02:05 MasterOdin