yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #11619
[Bug 1292397] [NEW] Difference in index creation for foreign key in MySQL and Postgres
Public bug reported:
In some migration such as 39cf3f799352_fwaas_havana_2_model,
569e98a8132b_metering, 1064e98b7917_nec_pf_port_del.
ForeignKeyConstraint is created with name, but in models this name isn't
mentioned. MySQL creates index when it creates ForeignKeyConstraint.
This cause difference between models and migrations and between database
content for MySQL and Postgres.
** Affects: neutron
Importance: Undecided
Status: New
** Tags: db
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1292397
Title:
Difference in index creation for foreign key in MySQL and Postgres
Status in OpenStack Neutron (virtual network service):
New
Bug description:
In some migration such as 39cf3f799352_fwaas_havana_2_model,
569e98a8132b_metering, 1064e98b7917_nec_pf_port_del.
ForeignKeyConstraint is created with name, but in models this name
isn't mentioned. MySQL creates index when it creates
ForeignKeyConstraint. This cause difference between models and
migrations and between database content for MySQL and Postgres.
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1292397/+subscriptions
Follow ups
References