Summary of Change

Derby can return fewer rows than expected.

Symptoms Seen by Applications Affected by Change

In the previous release, applications that executed SQL statements containing nested EXISTS clauses could see fewer rows than satisfy the query. In particular, rows that had the same value for one of the selected columns as another row might not have been 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.