Have the database do the work for you:

my $query = <<'SQL';
SELECT ticket_id, abstract, priority, maxlen_abstract
FROM
  (SELECT MAX(LENGTH(abstract)) AS maxlen_abstract FROM t1) AS s1
  CROSS JOIN t1;
SQL
[download]

Pay special attention to what your definition of length should be. You may not be in an ASCII-world.