← Back to team overview

yahoo-eng-team team mailing list archive

[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