This adds a validation to the text limit constraint that was added in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/33565.

Our database migration guidelines
https://docs.gitlab.com/ee/development/database/strings_and_the_text_data_type.html#add-a-text-limit-constraint-to-an-existing-column
recommend that we only validate the constraint one release after the
constraint was added.

https://gitlab.com/gitlab-org/gitlab/-/issues/220420