Reporter: incorrect join to asset.copy from acq.lineitem_detail
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
When creating a report that joins asset.copy from acq.lineitem_
SELECT * FROM (SELECT "c61194bfb1b243
"488118d5f4356
FROM acq.lineitem_detail AS "488118d5f4356a
INNER JOIN asset.copy AS "c61194bfb1b243
WHERE "c61194bfb1b243
AND "c61194bfb1b243
GROUP BY 1, 2
ORDER BY "c61194bfb1b243
) limited_
As you can see, the reporter has joined on the wrong field. Full debug output attached.
Evergreen 2.12/3.0
OpenSRF 3.0.0
PostgreSQL 9.5
Ubuntu 16.04 LTS
Chris, a couple questions about the template...
* It looks like it was created with the XUL client (version 4 template structure), is that correct?
* It looks like the core class is the ACQ Line Item Detail (that is, the direction is from acqlid to acp), is that also correct? (I just want to clarify what the description says...)
* Was nullability activated, and used, in creating this template?
The problem stems from the join path being written as "id-acp- id-b7df08da8516 c6304013fb1ac30 01c3b" when it should be "eg_copy_ id-acp- id-b7df08da8516 c6304013fb1ac30 01c3b". I don't have a cause for that yet, but nullability may be involved.