db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jrgchip <c...@datamology.com>
Subject Re: Record not found in some SQL - Bug?
Date Fri, 30 Jan 2009 15:10:14 GMT

jrgchip wrote:
> The failure still occurs.

Per investigation in DERBY-4032, it appears that there is indeed a bug in
Derby.  The problem here is that there are two records for 'HG15497' in the
unique index on the Product table (one active and one marked as deleted) and
that the B-tree scan logic does not account for that possibility.  So,
depending on the access path chosen and the logic used to satisfy the query,
the record might be found or not found.

View this message in context: http://www.nabble.com/Record-not-found-in-some-SQL---Bug--tp21700110p21748874.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message