MARCcat: MARC Bibliographic records
(UXPROD-786)
|
|
| Status: | Closed |
| Project: | mod-marccat |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None | Parent: | MARCcat: MARC Bibliographic records |
| Type: | Bug | Priority: | P3 |
| Reporter: | Annalisa Di Sabato | Assignee: | Mirko Fonzo |
| Resolution: | Done | Votes: | 0 |
| Labels: | Authority_record, browse_heading, marccat | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Attachments: |
|
||||||||
| Issue links: |
|
||||||||
| Sprint: | |||||||||
| Development Team: | @cult | ||||||||
| Epic Link: | MARCcat: MARC Bibliographic records | ||||||||
| Description |
|
In MARCcat browsing "Subject: All: "Atti persecutori", the system will display the heading with one authority record, ten bibliographic records and two cross reference. Clicking on that heading to see the authority and bibliographic record in the third panel, the system doesn't display the authority record (I see message "Non associated Authority record"), but only the bibliographic records. It seems that it the index SK used to find authority record for subject is not working. Follow the SQL produced by the BE during the search: CCL => "SK 95691" became "select res.aut_nbr from (select distinct smtc.aut_nbr from ((select distinct aut.aut_nbr from aut where (aut.hdg_nbr IN 95691 AND aut.hdg_typ_cde='SH'))) smtc order by smtc.aut_nbr desc ) res limit 30 offset 0" To find the wrong query on DB do the following select in table S_BIB1_SMNTC: select sql_whr from S_BIB1_SMNTC where ATRBT_USE_NBR = 21 and qry_nbr = 427 |
| Comments |
| Comment by Mirko Fonzo [ 21/May/19 ] |
|
The problem depends on wrong settings into the Semantic Table S_BIB1_SMNTC for some records. SQL Where Conditions such as "aut.hdg_nbr IN 95691" are accepted by Oracle but not by Postgres, which requires brackets even if just one element is specified. So, the condition should be "aut.hdg_nbr IN (95691)". |
| Comment by Annalisa Di Sabato [ 24/May/19 ] |
|
Verified in MARCcat. It's solved. |