Re: [IB-Architect] Bi-Directional cursor support WAS: Re: triggers + plans
Author
Alexandre Kozlov
Post date
2002-06-28T13:56:07Z
----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
To: <IB-Architect@yahoogroups.com>
Sent: Friday, June 28, 2002 2:29 AM
Subject: RE: [IB-Architect] Bi-Directional cursor support WAS: Re: triggers
+ plans
> > -----Original Message-----
> > From: Jim Starkey [mailto:jas@...]
> > Sent: Viernes 24 de Mayo de 2002 12:48
> > To: IB-Architect@yahoogroups.com; IB-Architect@yahoogroups.com
> >
> > Index walking in Interbase/Firebird is always problematic due
> > to an inherent inprecision of the indexes (all numbers and dates
> > are converted to double precision floating with inevitable
> > roundoff problems). The index scan code must revalidate a
> > candidate record to compensate for record generation issues,
> > this isn't a problem. But it is a nasty problem for index
> > walking, expecting to get a strict ordering.
>
> And what's the reason that indices need numbers and dates transmogrified
> into floating point values? Isn't there any alternative approach? Two very
> close timestamps in a column could be different yet for the index they
could
> become indistinguishable.
>
> C.
> ---------
> Claudio Valderrama C.
> Ingeniero en Informática - Consultor independiente
> http://www.cvalde.com - http://www.firebirdSQL.org
> Stop Spam - Save Joey McNicol
> http://t3-v-mcnicol.ilaw.com.au/
>
It looks like not perfect approach. I guess it would be better to escape
this
transformation for indices. C++ OOP should help it easier to design and
maintain.