PG::SyntaxError: ERROR from timestamp

[bananatron]

I couldn't go to /jobs in the admin view, getting:

LINE 1: ... ( good_jobs.scheduled_at ,good_jobs.created_at ) : : TIMEST...
                                                             ^
):
    1: <%= render 'good_job/shared/filter', title: t("good_job.shared.navbar.jobs"), filter: @filter %>
    2: <%= render 'good_job/shared/chart', chart_data: GoodJob::ScheduledByQueueChart.new(@filter).data %>
    3: 
    4: <div data-live-poll-region="jobs-table">
    5:   <%= render 'good_job/jobs/table', jobs: @filter.records, filter: @filter %>

This line was the culprit producing the following string:

COALESCE (
  good_jobs.scheduled_at
  ,good_jobs.created_at
) : : TIMESTAMP AS scheduled_at

I'm not sure what's generating the whitespace between : : TIMESTAMP

• good_job v3.26.1
• rails v7.1.3.2

I upgraded everything without a lot of precision which seems to have fixed the issue, just wanted to past it here for searchability.

[bananatron]

Closing this, but here is a hint at a fix if anyone lands here: #1306