Issue Bug Closed

#104872Increase length of field `sys_file_metadata`.`publisher`

Leonie Philine 09/10/24, 09:42 updated 10/15/24, 09:06

Description

Someone has reported this in EXT:extractor, but the field is part of core.

https://github.com/xperseguers/t3ext-extractor/issues/85

Selecting distinct values from `sys_file_metadata`.`publisher` at one of our projects shows many clipped values:

macOS Version 10.14.6 (Build 18G103) Quartz P
macOS Version 12.6.1 (Build 21G217) Quartz PD
macOS Version 13.2 (Build 22D49) Quartz PDFCo

However, nowadays, fields aren’t silently truncated. Instead, a hard error is raised.

Since these appear to be common values, the publisher field should be extended beyond the current VARCHAR(45).

Reviews 1