From d40fe8eabe0f7a21eaca1947a4b6bc0c1a1e1546 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Mon, 3 Jan 2022 13:13:12 +0300
Subject: Fix error in query: Replace '=' with 'IN'

---
 gn3/db/partial_correlations.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'gn3/db')

diff --git a/gn3/db/partial_correlations.py b/gn3/db/partial_correlations.py
index 9a4d814..8c4ec65 100644
--- a/gn3/db/partial_correlations.py
+++ b/gn3/db/partial_correlations.py
@@ -733,8 +733,8 @@ def set_homologene_id(conn, traits):
         "SELECT InbredSet.Name AS `group`, Homologene.GeneId AS geneid, "
         "HomologeneId "
         "FROM Homologene, Species, InbredSet "
-        "WHERE Homologene.GeneId = ({geneids}) "
-        "AND InbredSet.Name = ({groups}) "
+        "WHERE Homologene.GeneId IN ({geneids}) "
+        "AND InbredSet.Name IN ({groups}) "
         "AND InbredSet.SpeciesId = Species.Id "
         "AND Species.TaxonomyId = Homologene.TaxonomyId").format(
             geneids=", ".join(["%s"] * len(geneids)),
-- 
cgit v1.2.3