# HG changeset patch
# User Krista Bennett <krista@pep-project.org>
# Date 1497613927 -7200
# Node ID a3bf01e38752029bf23dd7401e133dbd6747e51f
# Parent  cc57e29989a49d1aa3f0691cd639493421669eab
ENGINE-171: initial commit - doesn't break current lookups. Now to test the two weird ones we want.

diff -r cc57e29989a4 -r a3bf01e38752 src/pEpEngine.c
--- a/src/pEpEngine.c	Thu Jun 15 18:49:12 2017 +0200
+++ b/src/pEpEngine.c	Fri Jun 16 13:52:07 2017 +0200
@@ -27,7 +27,10 @@
     "   join pgp_keypair on fpr = identity.main_key_id"
     "   join trust on id = trust.user_id"
     "       and pgp_keypair_fpr = identity.main_key_id"
-    "   where address = ?1 and identity.user_id = ?2;";
+    "   where (address = ?1" 
+    "              or (address = ?1 collate nocase)"
+    "              or (replace(address,'.','') = replace(?1,'.','')))"
+    "   and identity.user_id = ?2;";
 
 static const char *sql_replace_identities_fpr =  
     "update identity"