>> This seems to be an ordering problem.. The dates are inserted and then
>> the test relies on them being returned in the same order they were
>> inserted. I'm fairly sure that this isn't guaranteed when using SQL,
> Correct. Your tests are broken, you REALLY need an ORDER BY clause if you
> depend on the order of the result set. Alternately, adjust your tests to
> not care about the result set order.
I thought so...
>> however it looks like it probably worked before.
> The only major change I can personally think of that might've affected
> that is synchronized scans. If you have more than one backend reading the
> table at once using a sequential scan, one of them will usually pick up
> part-way through the table then go back to the beginning once it hits the
> end. I'm not sure if that's likely to be related to what you're seeing.
> In any case, you REALLY need an appropriate ORDER BY clause.
It should be simple to correct the tests, by adding a serial id field and
ordering on that...
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2009-04-20 21:51:27|
|Subject: Re: Query preparation|
|Previous:||From: Craig Ringer||Date: 2009-04-20 01:09:59|
|Subject: Re: Unit tests and ordering|