For a JIRA installation using MySQL (in strict mode), a URL entered into a custom field of type "URL Field" longer than 255 characters will lead to a GenericEntityException with error message Data truncation: Data too long for column 'STRINGVALUE' at row 1.

If this happens during a workflow transition, an integrity check is needed (assuming no transactional database backend) - quite bothersome.

I believe this is due to the fact that the length of the entry is not checked and stored with PersistenceFieldType TYPE_LIMITED_TEXT.

Workarounds are of course a custom validator for said type or a custom extensions of it performing the validation. However I really think this should be fixed within JIRA, perhaps by a change of the persistance type, as URLs can get long.

Another possible workaround would be to edit edit-basictext.vm to include a maxLength-attribute. The downside of this is that pasted content will be truncated silently.