Jira database schema change for customfieldvalue

[Matt Doar]

I see from https://jira.atlassian.com/browse/JRASERVER-66890 that the customfieldvalue table got a new field "updated" added around Jira 7.5.

Any one know what this new field is being used for?

Any one keep track of database schema changes for Jira? The documentation is way out of date.

[Shaun S · Accepted solution]

Hi Matt,

The updated column was added to the customfieldvalue table as a way to resolve a race condition found in JIRA Service Desk. That bug report and explanation for the addition of the updated column can be found here https://jira.atlassian.com/browse/JSDSERVER-5299 . Database schema changes are almost certainly being tracked internally, but public documentation on these changes isn't something I've seen published in about a decade. 

[Matt Doar]

Thanks, useful pointer. Shame the new column hurt performance!

I've never really accepted the official Atlassian stance of not using the database, since so many support cases are fixed by changing the database :)