OpenLiberty / open-liberty

Open Liberty is a highly composable, fast to start, dynamic application server runtime environment
https://openliberty.io
Eclipse Public License 2.0
1.16k stars 597 forks source link

JPQL SELECT query returns incorrect results when running back to back on DB2 #29443

Open KyleAure opened 2 months ago

KyleAure commented 2 months ago

EclipseLink is returning an empty result list intermittently when running on DB2.

For example, the JPQL Query: SELECT this.numFullTimeWorkers FROM DemographicInfo WHERE this.collectedOn=:when

When executed on DB2 this query will have one of the two behaviors:

  1. The first time the query is executed an empty result list will be returned, all subsequent executions of this query will return the correct result
  2. The first time the query is executed the correct result will be returned, all subsequent executions of this query will return an empty result list.
ajaypaul-ibm commented 2 months ago

Raised Eclipselink issue here : https://github.com/eclipse-ee4j/eclipselink/issues/2243