On 26-5-2014 21:45, eMeL wrote: > 2014.05.26. 12:51 keltezéssel, Joaquim Pais (JIRA) írta: >> Hash Function >> ------------- >> >> Key: CORE-4436 >> URL: http://tracker.firebirdsql.org/browse/CORE-4436 >> Project: Firebird Core >> Issue Type: Bug >> Components: API / Client Library >> Affects Versions: 2.1.5 Update 1 >> Environment: Windows Xp, 7, 2008 Server >> Reporter: Joaquim Pais >> >> >> >> Hi, >> >> Different string's give the same hash result ist's a bug? >> >> Witch max length to parameter hash function? >> >> Example >> >> select hash('4-20100433-01775-LOTES') >> from rdb$database >> union >> select hash('1-20100433-01765-LOTES') >> from rdb$database > > for see two lines: > > select hash('4-20100433-01775-LOTES') > from rdb$database > union all > select hash('1-20100433-01765-LOTES') > from rdb$database
Although the HASH() function isn't a cryptographic hash, I would have expected a better distribution of the hash. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ The best possible search technologies are now affordable for all companies. Download your FREE open source Enterprise Search Engine today! Our experts will assist you in its installation for $59/mo, no commitment. Test it for FREE on our Cloud platform anytime! http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
