I'm using Magento CE 22.214.171.124 and enable email confirmation for registration. Email is sent as normal, but when I click the link, it always fails. The link is like this
Later on, I found out that under customer_entity_varchar table, Magento stores the plain text (from the password) instead of the hash string, under attribute_id 16 (confirmation). When I change this plain text to the hash string, it works.
My question is, why Magento stores the plain text whilst email the hash string?