db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Adding order by clause eliminates results
Date Mon, 18 Jun 2007 19:27:54 GMT
you may want to look at this recent discussion about updating an
open cursor, in the development discussion group.


Elliotte Harold wrote:
> Interesting. That does indeed fix it, and it does make some sense.
> What's really surprising here is that the SELECT before the INSERT ever 
> worked.
> I'm still not sure if this qualifies as a Derby bug or not, but it does 
> feel weird that adding ORDER BY to the query can change the result set.
> -- 
> Elliotte Rusty Harold
> erharold@gmail.com <mailto:erharold@gmail.com>

View raw message