Fix representation of the unknown license in License DB prod database

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Problem to solve

The correct License ID for an unknown license is 1 which maps to noassertion.

Currently in the production database of License DB we have licenses in <registry>_license tables that contain {} or {0} when it should be {1}. The bug that introduced these wrong values was fixed but we still have this data in the database.

This was raised in #412986 (comment 1476908808)

Proposal

Run an UPDATE query to fix the production database, and replace {} and {0} with {1}.

Implementation plan

In a transaction,

• Count wrong representations of the unknown license.
• Run UPDATE queries to fix them.
• Check the result.
• Commit.