Re: [Firebird-devel] Timestamp & Date index troubles (< 1858-11-17)

[Arno B. <fir...@ab...>]

Hi Alex,

> >>The fix is easy, but what about backwards compatibilty?
> >>
> >>Users that currently have stored date-values below '1858-11-17' can only
> >>used the index correctly if they DO NOT use ORDER BY (which uses an
index)
> >>and "greater than", "greater than or equal", "less than" and "less than
or
> >>equal" operators on dates below '1858-11-17'.
> >>
> >>I see no problem with fix and only users that stored dates below
> >>'1858-11-17' and uses indexes on them need to rebuild their indexes.
> >>
> >>Comments / ideas?
> >>
> >>btw, i see the run-time flags idx_timestamp1 and idx_date aren't used
> >>anymore thus IMO those can be removed together with their code safely.
> >>
> >>
> >
> >If nobody has objections i commit the patch to HEAD.
> >
> >
> What will happen with databases (ODS 10.*), where indices were not
rebuilt?

Without ODS check dates below the Julian date will be completly "corrupted".
I meant when you do a equal match it will fail and could return other date
(but always also one below Julian date)
f.e. : SELECT * FROM TableA a WHERE a.DateTime = '1600-01-01'
Note! That currently queries already fail on operations other then equal
match.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
  http://www.firebirdsql.org
  http://www.firebirdsql.info
  http://www.fingerbird.de/
  http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
fir...@ya...

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info