Re: [Firebird-devel] HASH function (CORE-4436)

[Adriano d. S. F. <adr...@gm...>]

On 19/07/2017 05:27, Dimitry Sibiryakov wrote:
> 19.07.2017 2:47, Adriano dos Santos Fernandes wrote:
>> They will store hash on field of appropriate length for the given hash
>> and index it.
>
>   On contrary, there is no point to store hash value if its purpose is
> to speed up lookup only.
>

I hope you don't need to recreate your index and recompute whole table
hashes with a slow algorithm.

In most cases original string (password) is not even stored and hashes
are used to check if a password matches a previously one.


Adriano