Re: [eclipselink-dev] Fix for bug# 295556 - Do not add Distinct to Queri

[J Grassel <fyrewyld@xxxxxxxxx>]

Unfortunately, it still passes…

        Session session = ((org.eclipse.persistence.internal.jpa.EntityManagerImpl) em).getSession();

       

        ReadAllQuery raQuery = new ReadAllQuery(ECL295EntB.class);

        raQuery.addBatchReadAttribute("entACollection”);

[EL Info]: 2014-09-08 11:16:07.266--ServerSession(2039599313)--EclipseLink, version: Eclipse Persistence Services - 2.5.0.v20130507-3faac2b

[EL Info]: connection: 2014-09-08 11:16:09.428--ServerSession(2039599313)--testpu login successful

[EL Fine]: sql: 2014-09-08 11:16:09.445--ServerSession(2039599313)--Connection(1635481008)--SELECT ID FROM ECL295ENTA WHERE ID <> ID

[EL Fine]: sql: 2014-09-08 11:16:09.74--ServerSession(2039599313)--Connection(1635481008)--SELECT ID FROM ECL295ENTB WHERE ID <> ID

[EL Fine]: sql: 2014-09-08 11:16:09.815--ServerSession(2039599313)--Connection(1635481008)--SELECT entACollection_ID FROM ECLENTA_ENTB WHERE entACollection_ID <> entACollection_ID

[EL Fine]: sql: 2014-09-08 11:16:09.915--ServerSession(2039599313)--Connection(1635481008)--SELECT ID, STRDATA FROM ECL295ENTB

[EL Fine]: sql: 2014-09-08 11:16:10.041--ServerSession(2039599313)--Connection(1635481008)--SELECT t1.ID, t1.STRDATA, t1.STRINGVALUE, t0.ECL295EntB_ID FROM ECLENTA_ENTB t0, ECL295ENTB t2, ECL295ENTA t1 WHERE ((t0.ECL295EntB_ID = t2.ID) AND (t1.ID = t0.entACollection_ID))

On Sep 8, 2014, at 9:47 AM, andrei ilitchev <andrei.ilitchev@xxxxxxxxxx> wrote:

raQuery.addBatchReadAttribute("entACollection");