Opened 14 years ago

Closed 14 years ago

#783 closed task (fixed)

Check the source for other places affected by the Postgres problem described in ticket #781

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: minor Milestone: BASE 2.4.3
Component: core Version:
Keywords: Cc:

Description (last modified by Nicklas Nordborg)

Since it only affects distinct queries we can use Eclipse to find all places where Query.setDistinct() is called. More info at #781.

Change History (6)

comment:1 Changed 14 years ago by Nicklas Nordborg

Description: modified (diff)

comment:2 Changed 14 years ago by Nicklas Nordborg

Description: modified (diff)

comment:3 Changed 14 years ago by Nicklas Nordborg

Milestone: BASE 2.5BASE 2.4.3
Priority: majorminor

comment:4 Changed 14 years ago by Nicklas Nordborg

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:5 Changed 14 years ago by Nicklas Nordborg

I have found that BioMaterialEvent?.getQuery() also creates a DISTINCT query. The web interface has options to sort by protocol and owner, which doesn't work in Postgres. This case is probably more difficult to solve, since the query is built by generic code, that isn't aware of the problem.

The target method to check for a solution is ItemContext?.configureQuery() which already has an option for left joins. Maybe we can try to use a LEFT FETCH JOIN if the query is distinct.

comment:6 Changed 14 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

Can't find any more places. The problem found is now part of ticket #785.

Note: See TracTickets for help on using tickets.