Reviewed: https://review.openstack.org/301722 Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=1a349bb96be5dece65a672648ecc6f7cae9641b2 Submitter: Jenkins Branch: stable/liberty
commit 1a349bb96be5dece65a672648ecc6f7cae9641b2 Author: Victoria Martinez de la Cruz <email address hidden> Date: Wed Mar 30 15:05:59 2016 -0300
Fixes migrations for MySQL 5.6.* and MariaDB 10.1.*
In MySQL 5.6/MariaDB 10.1 and later versions there was a change on the restrictions over foreign keys (FK).
In 019-datastore-fix.py, we attempt to change a column that is part of a FK from NULL to not NULL. This sort of modifications are not longer allowed.
This situation caused trove-manage db_sync and trove-manage db_migrate to fail.
To workaround this, the FK check before executing the ALTER query is disabled and then reenabled.
Change-Id: I666d01235f2c3225aca3fe7520ebdf6d53831cab Closes-Bug: #1473226 (cherry picked from commit 679e2283ecc888bd567955b4bf431c87043e8d12)
Reviewed: https:/ /review. openstack. org/301722 /git.openstack. org/cgit/ openstack/ trove/commit/ ?id=1a349bb96be 5dece65a672648e cc6f7cae9641b2
Committed: https:/
Submitter: Jenkins
Branch: stable/liberty
commit 1a349bb96be5dec e65a672648ecc6f 7cae9641b2
Author: Victoria Martinez de la Cruz <email address hidden>
Date: Wed Mar 30 15:05:59 2016 -0300
Fixes migrations for MySQL 5.6.* and MariaDB 10.1.*
In MySQL 5.6/MariaDB 10.1 and later versions there was a change
on the restrictions over foreign keys (FK).
In 019-datastore- fix.py, we attempt to change a column that is part
of a FK from NULL to not NULL. This sort of modifications are not
longer allowed.
This situation caused trove-manage db_sync and trove-manage db_migrate
to fail.
To workaround this, the FK check before executing the ALTER query
is disabled and then reenabled.
Change-Id: I666d01235f2c32 25aca3fe7520ebd f6d53831cab d567955b4bf431c 87043e8d12)
Closes-Bug: #1473226
(cherry picked from commit 679e2283ecc888b