Cannot change column used in a foreign key constraint

0

When trying to change an Aurora DB column that is a part of a foreign key an error is thrown: Error 1832: Cannot change column 'A_id': used in a foreign key constraint 'B_ibfk_1'

This makes Aurora incompatible with some of MySQL-tested products like this: https://github.com/ory/kratos/issues/2044

This issue is reproducible with Golang mysql driver and Aurora DB as a database. Here is the code to reproduce the problem: https://github.com/splaunov/aurora-fk-problem

The same Golang code works fine with MySQL db.

asked 2 years ago178 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions