Request the following info be added to existing documentation of the MAXLENGTH attribute on CSV files:
There is a hard limit to the MAXLENGTH attribute (10MB)
Referencing HPCC 13990 and HPCC 12677, HPCC 13993 - Jake Smith reported that "A hard limit was introduced, mainly to protect from unbound lines causing problems." This limit is 10MB, but can be overridden by using the "maxCSVRowSizeMb" option as follows:
#OPTION('maxCSVRowSizeMB', n) where n is the maximum size in MB
Also in the current documentation, the size in the MAXLENGTH attribute should specify bytes for better clarity.