Correct varchar length differences between production and structure.sql
In #211781, a number of schema inconsistencies were identified between the GitLab.com production database and the structure.sql
file. One such problem is numerous instances of varchar columns that have an explicit length limit in production, but not in structure.sql
.
This can lead to issues where data used in local testing fails in the production environment, because it is too long for the current limit.
The previous issue discusses strategies to fix this problem, such as converting all these columns to unbounded varchar/text, but this can be difficult to do as this can lead to an lengthy and blocking index rebuild (particularly with partial indexes).