]> review.fuel-infra Code Review - openstack-build/neutron-build.git/commit
Update migration scripts to support DB2
authorJohn Kasperski <jckasper@us.ibm.com>
Thu, 25 Sep 2014 15:38:45 +0000 (10:38 -0500)
committerMatt Riedemann <mriedem@us.ibm.com>
Mon, 29 Sep 2014 15:17:08 +0000 (08:17 -0700)
commitc048d3fb480cbd9033152c745802691876b7ba0d
treea2606da251f6b9c722557d832baee389d8c61cf5
parentff9745c9527399df52f56b022a698cd63e48d537
Update migration scripts to support DB2

Three of the migration scripts are causing failures with DB2.

- DB2 doesn't support nullable column in primary key

- Hard coded SQL statements which use False/True as Boolean arguments
  are not compatible with DB2. In DB2, Boolean columns are created as
  small integer with a constraint to allow only 0 & 1.

- Hardcoded update rows from other table sql is not compatible with DB2

- Foreign key constraints require additional handling

Co-authored-by: Rahul Priyadarshi <rahul.priyadarshi@in.ibm.com>
Change-Id: I82e2d1c522b81fed90a1e5cc6f2321f80797cf7b
Closes-Bug: #1328019
neutron/db/migration/alembic_migrations/versions/31d7f831a591_add_constraint_for_routerid.py
neutron/db/migration/alembic_migrations/versions/3927f7f7c456_l3_extension_distributed_mode.py
neutron/db/migration/alembic_migrations/versions/884573acbf1c_unify_nsx_router_extra_attributes.py