Opened 17 years ago
Closed 17 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 )
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 by , 17 years ago
| Description: | modified (diff) |
|---|
comment:2 by , 17 years ago
| Description: | modified (diff) |
|---|
comment:3 by , 17 years ago
| Milestone: | BASE 2.5 → BASE 2.4.3 |
|---|---|
| Priority: | major → minor |
comment:4 by , 17 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:5 by , 17 years ago
comment:6 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Can't find any more places. The problem found is now part of ticket #785.
Note:
See TracTickets
for help on using tickets.
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.