Dnia 07/12/2003 04:54 AM, Jonas Lindholm napisa³(a):
> Hi!
>
> I believe I've found a bug with daylight saving time.
> The example below shows that after inserting a row with a date and time
> when daylight saving is changing (6 April 2003 02:00:00) any selects
> using the same time and date are only returning correct result first
> time. If the select is done again the row is not found.
Hi,
I had similar problem that select returned 1 or 0 rows (with the same
query) (if you want - see "SELECT bug?")
I don't know where is the problem, but try to reindex table timespan.
In my database it resolved all problems (hope so ;) )
Now select return correct values.
Jacek