Mercurial > sci

diff sql/job-todo.sql @ 4:9c4fea43803c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: some refactoring in db
author David Demelier <markand@malikania.fr>
date Tue, 15 Jun 2021 20:42:55 +0200
parents 215c0c3b3609
children 8c408176d2b1
line wrap: on
line diff
--- a/sql/job-todo.sql	Mon Jun 14 22:08:24 2021 +0200
+++ b/sql/job-todo.sql	Tue Jun 15 20:42:55 2021 +0200
@@ -4,8 +4,8 @@
        FROM job
       WHERE job.id
      NOT IN (
-            SELECT job_result.job_id
-              FROM job_result
-             WHERE job_result.worker_id = ?
+            SELECT jobresult.job_id
+              FROM jobresult
+             WHERE jobresult.worker_id = ?
      )
       LIMIT ?