Column decryption does not work with column groups
With an active/working setup for transparent encryption of a table column, if I do normal query the column is decrypted correctly.
Take the api_key
table which has a column key
that is encrypted. If I do:
$db->api_key('a')->join('u', 'a.user_id=u.id', 'u')->findOne(['u.id' => 1]);
then the column is returned decrypted automatically. However, if I do:
$db->api_key('a')->join('u', 'a.user_id=u.id', 'u')->findOne(['u.id' => 1], ['key' => 'a.*', 'user' => 'u.*']);
then the data is returned in the correct groups but the column is not decrypted.