Subject Re: Bug: "-0" <> "0" in FB indexes !!!
Author peter_jacobi.rm
Hi Daniel, All,

--- In firebird-support@yahoogroups.com, Daniel Rail wrote:
> They both make a distinction between -0.0 and +0.0, because of the
> sign bit. It is also possible that a compiler doesn't make the
> distinction between them. But, because Firebird's indices are binary
> representations of the values, it might(and mostly) possible that the
> sign bit is taken into consideration.

If by any means (a poll between the users, reading the SQL standard or
I Ging), it is decided that -0.0 and 0.0 should be equal in FB, a
transformation step (value=>index key) can be inserted, as is done
for string collations now.

Regards,
Peter Jacobi