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