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

Reply via email to