At 5:42 PM -0800 11/26/99, perry@stripped wrote:
> Creating an index on a column causes a query which previously
> returned data to return no rows. The data was originally
> created one row at a time but the problem can be demonstrated by
> performing a query first with no index and then after rebuilding
> the index.
> Version 3.21.33 does not have the problem, version 3.22.25 and
> 3.22.27 do.
> The following test case
> * creates a table
> * populates it with a bunch of data
> * shows a select returning a row
> * creates an index
> * shows the same select not returning any data
> Although there is nothing very strange about the data (the dates
> range from year 0000 through year 9999) I was not able to recreate
> the problem by inserting sample data one row at a time. I can provide
> a dump of the table if needed.
> The year used in the query seems to be significant. Querying for date
> '1800/12/01' seems to work but date '0800/12/01' does not.
If the column is a DATE column, the manual says the supported range is
from years 1000 to 9999.
Paul DuBois, paul@stripped