List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 27 1999 5:10am
Subject:Re: Index causes SELECT to fail
View as plain text  
At 5:42 PM -0800 11/26/99, perry@stripped wrote:
>  >Description:
>	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
Index causes SELECT to failperry27 Nov
  • Re: Index causes SELECT to failPaul DuBois27 Nov