diff options
| author | Christopher Baines <mail@cbaines.net> | 2022-01-07 17:48:42 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2022-01-07 17:48:42 +0000 |
| commit | 0e5445c5bd6d23f12731d2347e805f80be846ab9 (patch) | |
| tree | 6a8af67c8c71155998114e310c8c3733525ff69e | |
| parent | 309fc55a83f8f95d6fc2fd8683d61283321b99a3 (diff) | |
| download | build-coordinator-0e5445c5bd6d23f12731d2347e805f80be846ab9.tar build-coordinator-0e5445c5bd6d23f12731d2347e805f80be846ab9.tar.gz | |
Add LIMIT 1 to a couple of queries
Where only the first row is checked for.
| -rw-r--r-- | guix-build-coordinator/datastore/sqlite.scm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index 1c01cd2..9e8de44 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -1162,7 +1162,8 @@ INNER JOIN unbuilt_outputs ON unbuilt_outputs.output_id = derivation_outputs.output_id INNER JOIN builds ON builds.derivation_id = derivation_inputs.derivation_id -WHERE builds.id = :build_id" +WHERE builds.id = :build_id +LIMIT 1" #:cache? #t))) (sqlite-bind-arguments @@ -3639,7 +3640,8 @@ INNER JOIN unbuilt_outputs ON unbuilt_outputs.output_id = derivation_outputs.output_id INNER JOIN builds ON builds.derivation_id = derivation_inputs.derivation_id -WHERE builds.id = :build_id" +WHERE builds.id = :build_id +LIMIT 1" #:cache? #t))) (sqlite-bind-arguments |