# HG changeset patch # User Krista Bennett # 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"