ENGINE-140 #comment fixed SQL error making excluded key being included - natural join isn't default ENGINE-140_exclude_identity_from_sync
authorEdouard Tisserant <edouard@pep-project.org>
Sun, 20 Nov 2016 02:09:23 +0100
branchENGINE-140_exclude_identity_from_sync
changeset 140853e4fe24ce2f
parent 1407 10c67fc4e3a7
child 1410 e90f02b87312
child 2734 16045c0485b3
ENGINE-140 #comment fixed SQL error making excluded key being included - natural join isn't default
src/pEpEngine.c
     1.1 --- a/src/pEpEngine.c	Sat Nov 19 01:06:50 2016 +0100
     1.2 +++ b/src/pEpEngine.c	Sun Nov 20 02:09:23 2016 +0100
     1.3 @@ -415,7 +415,7 @@
     1.4          
     1.5          sql_own_keys_retrieve =  
     1.6                              "select fpr from own_keys"
     1.7 -                            "   join identity"
     1.8 +                            "   natural join identity"
     1.9                              "   where (identity.flags & 1) = 0;"; // PEP_idf_not_for_sync
    1.10  
    1.11          sql_set_own_key = "insert or replace into own_keys (address, user_id, fpr)"