Summary of Change

Derby can return fewer rows than expected.

Symptoms Seen by Applications Affected by Change

Applications that execute SQL statements containing nested EXISTS clauses can see fewer rows than satisfy the query. In particular, rows that have the same value for one of the selected columns as another row might not be returned.

Incompatibilities with Previous Release

Applications that depended on the previous incorrect behavior will need to be updated.

Rationale for Change

The previous behavior violated the ANSI SQL standard. The new behavior is correct.

Application Changes Required

Applications that depended on the previous incorrect behavior will need to be updated.