By using AWS re:Post, you agree to the Terms of Use
/Cannot change column used in a foreign key constraint/

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 5 months ago11 views