Select SQL Generated With Different Column Orders In Select Clause
(Doc ID 1574944.1)
Last updated on MARCH 31, 2019
Applies to:Oracle TopLink - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Using TopLink version 220.127.116.11.0, created an application which has JPQL joining two entities with non-PK criteria. When EclipseLink generates the SQL from the JPQL, the order of columns listed in the select clause may change, e.g. sometimes it has "SELECT id, name, ....", sometimes it has "SELECT name, id, ...". The shuffling of the column order causes the database to treat them as different SQL statements.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document