Bug #35188 Add a FNV hash function that accepts many arguments

Submitted: 10 Mar 2008 17:34 Modified: 11 Mar 2008 5:52
Reporter: Baron Schwartz (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution, qc

[10 Mar 2008 17:34] Baron Schwartz 
Description:
I built a UDF to speed up Maatkit, as recorded here:

http://www.xaprb.com/blog/2008/03/09/a-very-fast-fnv-hash-function-for-mysql/

The result is a 64-bit FNV hash function.  The most important thing I did, which differs from other implementations I've seen, is permit many arguments to the FNV hash function.  This avoids the need to concat() arguments into a single argument.

It would be very nice if this were integrated into the server instead of being a UDF.  (It could also return an unsigned 64-bit integer, instead of signed).

How to repeat:
Feature request.

Suggested fix:
I'd submit a patch, but I doubt my code is suitable for general inclusion in the server; perhaps Mark Callaghan's patch (from the Google patches) is a good place to start.
[11 Mar 2008 5:52] Valeriy Kravchuk 
Thank you for a reasonable feature request.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.