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

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

Hi!

We have HASH function that returns a 64 bit integer. The algorithm is
bad and the result too small for a hash.

I propose to extend the same function with a second parameter with the
algorithm name.

When only one parameter is passed, things works as now.

When two parameters are passed, it will return a VARCHAR(64) CHARACTER
SET OCTETS. That's sufficient for a SHA-256, for example.

We implement (preferably getting code with compatible license or public
domain - like was done for SHA-1 used in authentication - instead of use
a bloated library) some algorithms (MD5, some useful SHA-*). No need for
"hash plugins" for now.


Adriano