From 86d7a11c6b338a73c30476be13a6cac562e309c3 Mon Sep 17 00:00:00 2001
From: regnat <rg@regnat.ovh>
Date: Fri, 5 Nov 2021 11:17:22 +0100
Subject: Make sure to delete all the realisation refs
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Deleting just one will only work in the test cases where I didn’t bother
creating too many of them :p
---
 src/libstore/ca-specific-schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/libstore/ca-specific-schema.sql')

diff --git a/src/libstore/ca-specific-schema.sql b/src/libstore/ca-specific-schema.sql
index d2ea347fb..c01dc5a76 100644
--- a/src/libstore/ca-specific-schema.sql
+++ b/src/libstore/ca-specific-schema.sql
@@ -21,7 +21,7 @@ create index if not exists IndexRealisations on Realisations(drvPath, outputName
 -- realisations
 create trigger if not exists DeleteSelfRefsViaRealisations before delete on ValidPaths
   begin
-    delete from RealisationsRefs where realisationReference = (
+    delete from RealisationsRefs where realisationReference in (
       select id from Realisations where outputPath = old.id
     );
   end;
-- 
cgit v1.2.3

