For array columns using MySQL, if an array contains a double quote (e.g.
if the scalar is a single double quote: '"'), after inflation the scalar
will contain a backslash before every double quote, e.g. '\"'. More
generally, backslashes added for escaping are never removed. The net
effect is that every update adds more backslashes, until the array takes
too much space to be stored.
The problem appears to be in the parse_array sub in Rose/DB.pm. This
occurs with the SVN version as well as the latest CPAN version.
If it were not for backward compatibility issues, I would suggest using
JSON::XS for this purpose. JSON::XS could be used with pre-processing and
post-processing of enclosing brackets for backward compatibility.
RT for rt.cpan.org