file_size_bytes should support 64-bit integers

Description

The datatype for the file_size_bytes column in the file_version table is INT(11), which limits entries to 32-bit integers. Larger files necessitate support for 64-bit integers in this field, so we'd like to request changing the datatype for file_size_bytes to BIGINT.

Environment

RHEL 7

Activity

Show:
Christine Di Bella
November 14, 2018, 4:54 PM

- I believe you had done some research into this issue. Could you please summarize here when you get a chance?

Rachel Searcy
October 16, 2020, 7:30 PM

In staff interface of ArchivesSpace test environment, File Size (Bytes) field of the File Version sub-record accepts 64-bit integers and digital object record can be saved. Attempting to do the same in previous versions results in an error when trying to save the DO.

Joshua Shaw
October 19, 2020, 3:28 PM

Concur that issue is fixed. Tried adding 9223372036854775807 as file size and DO saved successfully.

Done

Assignee

Lora Woodford

Reporter

Adam Jazairi

Labels

None

Fix versions

Priority

Major