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

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

Hi,

<snip>
> 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.

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