Bug 32399: Remove FK constraints while changing columns
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Mon, 5 Dec 2022 09:18:04 +0000 (09:18 +0000)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Sun, 18 Dec 2022 08:21:32 +0000 (08:21 +0000)
commit8b6a8e82b3b77608798b3cb67bd7161d44fc35f9
tree4d6d6d5a509baa6ff495d3fa2bad4042ca48776c
parent619e7ab9dbd457c97d9b3b420780b9a828d31759
Bug 32399: Remove FK constraints while changing columns

Some users have reported that the dbrev of bug 30483 fails. This might
depend on bad data, SQL server version, etc.
We now remove the constraints temporarily.

Test plan:
Reset your version in order to pass this dbrev again. So below
22.06.00.041.
* update systempreferences set value='22.0600040' where variable = 'Version';
Run updatedatabase.

Bonus: Create an issues record with invalid itemnumber (set FK check
off when doing so). Verify that dbrev fails and installer stops.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit bad638578b6bb3d0913841bd71ab9fba220a529e)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/db_revs/220600041.pl