=head2 errormsg
  data_type: 'text'
  is_nullable: 1
=head2 errortime
  data_type: 'integer'
  is_nullable: 1

  "errormsg",
  { data_type => "text", is_nullable => 1 },
  "errortime",
  { data_type => "integer", is_nullable => 1 },

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M61ikfnjORU7jDAH8P/j7w

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 11:13:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zDBtAFc4HiFUcL/TpkuCcg

    errorMsg      text, -- error output from the evaluator
    errorTime     integer, -- timestamp associated with errorMsg

ALTER TABLE JobsetEvals
    ADD COLUMN errorMsg text,
    ADD COLUMN errorTime integer NULL;
-- Copy the current error in jobsets to the latest field in jobsetevals
UPDATE jobsetevals
    SET errorMsg = j.errorMsg,
        errorTime = j.errorTime
  FROM (
    SELECT
        jobsets.errorMsg,
        jobsets.errorTime,
        jobsets.id AS jobset_id,
        latesteval.id AS eval_id
    FROM jobsets
    LEFT JOIN
        (
            SELECT
                MAX(id) AS id,
                project,
                jobset
            FROM jobsetevals
            GROUP BY project, jobset
            ORDER BY project, jobset
        )
        AS latesteval
        ON
            jobsets.name = latesteval.jobset
            AND jobsets.project = latesteval.project
    WHERE latesteval.id IS NOT NULL
    ORDER BY jobsets.id
)
AS j
WHERE id = j.eval_id;