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.