Subject | Re: Bug: "-0" <> "0" in FB indexes !!! |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-03-26T11:48:35Z |
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