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)
committerTomas Cohen Arazi <tomascohen@theke.io>
Thu, 15 Dec 2022 13:18:27 +0000 (10:18 -0300)
commitbad638578b6bb3d0913841bd71ab9fba220a529e
treeaf2b694a81e0dbcaf46b2edaea5ac2dd2f0b95ec
parentaa13c1a9d1fe44021f991fc8e78f70e80b2a56ac
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>
installer/data/mysql/db_revs/220600041.pl