Bug 30571: (follow-up) Additional check at upgrade
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Wed, 5 Oct 2022 11:49:56 +0000 (11:49 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Wed, 12 Oct 2022 12:04:06 +0000 (09:04 -0300)
commitd71c20a9976367aeac3f75feb2c0172e68a13cf4
treeeeaf5f0d597b2f9d63c5b3ac49ce09873833cf2d
parent86a744cbfd916ba0c61d25466a5e8402bb10951b
Bug 30571: (follow-up) Additional check at upgrade

Bad data occurs. We are removing null hosts here and update
empty syntax or encoding, informing the user.

Test plan:
Remove the NOT NULL condition if needed.
Copy db_revs/220600056.pl to atomicupdate and test dbrev.
You might see something like:
    Upgrade to 22.06.00.056  [11:48:22]: Bug 30571 - Table z3950servers: three cols NOT NULL
        Found bad data in table z3950servers: removed 1 records with host undefined
        Corrected empty syntax or encoding for the following hosts. Please check after upgrade.
        Updated hosts: lx2.loc.gov,lx2.loc.gov

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/db_revs/220600056.pl