On 10-08-2020 12:23, Alex Peshkoff via Firebird-devel wrote:
On 2020-08-02 13:52, Dmitry Yemanov wrote:
02.08.2020 13:14, Mark Rotteveel wrote:
Firebird 4 introduces the function CRC32 which generates a CRC32
hash, while Firebird 4 also introduces an extension to the HASH
function to add (cryptographic) hashes.
Would it make sense to remove CRC32 as a standalone function and
instead add it to HASH?
As for me, it would.
I doubt that's good idea - because:
CRC32 returns 32-bit integer.
HASH(something USING method) returns varbinary of appropriate length.
What should be return value of HASH(something USING CRC32)?
HASH(...) without USING returns BIGINT, and HASH(... USING ...) already
has a variable type (although it is just the length that varies).
What would be the problem for HASH(... USING CRC32) to return a INTEGER
instead?
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel