1 files changed, 1 insertions, 1 deletions
diff --git a/src/libstore/local-store.cc b/src/libstore/local-store.cc
index e64917956..76524b01c 100644
--- a/src/libstore/local-store.cc
+++ b/src/libstore/local-store.cc
@@ -148,7 +148,7 @@ void migrateCASchema(SQLite& db, Path schemaPath, AutoCloseFD& lockFd)
             db.exec(R"(
                 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;