On Tue, 26 Feb 2019 09:59:54 -0800 Tim Armstrong <tarmstr...@cloudera.com.INVALID> wrote: > It's not a database thing, it's a floating point > number thing. If you're doing floating point arithmetic you can end up > with -0/+0 from expressions that should be equivalent.
But we are not exactly dealing with arithmetic here... I'm not sure the IEEE FP standard was designed with database joins in mind. Granted, float hashing and float equality may be of dubious utility. I'm curious about the use cases. > You end up in a world of pain if your equality relation and your hash > function implementation are not aligned. This is not what I am suggesting. > So it's really a question of how you want to define equality (and whether > you want to have multiple definitions of equality for different purposes). I think this is the goal of this discussion. Regards Antoine.
