From 776d0462e97b5faaf096c4250ae2d3eafb42c072 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sun, 29 Mar 2020 12:05:00 +0100 Subject: Fix a missing ; in a Sqitch migration --- sqitch/deploy/load_new_guix_revision_jobs_make_commits_unique.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sqitch') diff --git a/sqitch/deploy/load_new_guix_revision_jobs_make_commits_unique.sql b/sqitch/deploy/load_new_guix_revision_jobs_make_commits_unique.sql index 52ef2d3..bd07eac 100644 --- a/sqitch/deploy/load_new_guix_revision_jobs_make_commits_unique.sql +++ b/sqitch/deploy/load_new_guix_revision_jobs_make_commits_unique.sql @@ -9,7 +9,7 @@ WHERE job_id NOT IN ( SELECT DISTINCT ON (commit) id FROM load_new_guix_revision_jobs ORDER BY commit, succeeded_at ASC NULLS LAST, created_at ASC -) +); DELETE FROM load_new_guix_revision_job_logs WHERE job_id NOT IN ( -- cgit v1.2.3