From ab6d5cefbea1e8ddf41f385dd85918f651958287 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Mon, 19 Jun 2023 17:18:21 -0700
Subject: hack to allow impersonator to impersonate target

---
 crates/secd/store/sqlite/sql/find_identity.sql | 2 --
 1 file changed, 2 deletions(-)

(limited to 'crates/secd/store/sqlite/sql/find_identity.sql')

diff --git a/crates/secd/store/sqlite/sql/find_identity.sql b/crates/secd/store/sqlite/sql/find_identity.sql
index 1528407..0d32a9b 100644
--- a/crates/secd/store/sqlite/sql/find_identity.sql
+++ b/crates/secd/store/sqlite/sql/find_identity.sql
@@ -7,9 +7,7 @@ select distinct
 from identity i
 left join address_validation av using (identity_id)
 left join address            a  using (address_id)
-left join session            s  using (identity_id)
 where (($1 is null) or (i.identity_public_id = $1))
 and (($2 is null) or (a.value = $2))
 and (($3 is null) or (($3 is true) and (av.validated_at is not null)))
-and (($4 is null) or (s.token_hash = $4))
 and i.deleted_at is null;
-- 
cgit v1.2.3

