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.
