Comment 10 for bug 1770453

Revision history for this message
Josh Stompro (u-launchpad-stompro-org) wrote :

Hello, I just noticed this issue also, on 3.3.3. Here is an example from our test system.

https://egtest1.larl.org/eg/opac/record/311994?locg=1;detail_record_view=0;page=0;sort=pubdate.descending;query=nora%20roberts;expand=marchtml#marchtml

The 650's look like this.
=650 \0$aFamily violence$vFiction.$0(LARL_NWRL_CONSORTIUM)164976
=650 \0$aAdult child abuse victims$vFiction.$0(LARL_NWRL_CONSORTIUM)170357
=650 \7$aFICTION / Romance / Suspense.$2bisacsh
=650 \7$aFICTION / Thrillers / Domestic.$2bisacsh
=650 \7$aAdult child abuse victims.$2fast$0(LARL_NWRL_CONSORTIUM)178912
=650 \7$aFamily violence.$2fast$0(LARL_NWRL_CONSORTIUM)19960

Subjects in the detail page look like:
Subject:
Family violence Fiction
Family violence Fiction
Family violence Fiction
Adult child abuse victims Fiction
Adult child abuse victims Fiction
Adult child abuse victims Fiction
FICTION / Romance / Suspense
FICTION / Romance / Suspense
FICTION / Romance / Suspense
FICTION / Thrillers / Domestic
FICTION / Thrillers / Domestic
FICTION / Thrillers / Domestic
Adult child abuse victims
Adult child abuse victims
Adult child abuse victims
Family violence
Family violence
Family violence

metabib.display_entry contains
select cdfm.name, mde.* from metabib.display_entry mde join config.display_field_map cdfm on cdfm.field=mde.field where mde.source=311994 and mde.field in (16,12,13,14) order by value;
     name | id | source | field | value
---------------+---------+--------+-------+-----------------------------------
 subject_topic | 7430085 | 311994 | 14 | Adult child abuse victims
 subject_topic | 7430088 | 311994 | 14 | Adult child abuse victims
 subject | 7430094 | 311994 | 16 | Adult child abuse victims
 subject | 7430091 | 311994 | 16 | Adult child abuse victims Fiction
 subject | 7430092 | 311994 | 16 | FICTION / Romance / Suspense
 subject_topic | 7430086 | 311994 | 14 | FICTION / Romance / Suspense
 subject_topic | 7430087 | 311994 | 14 | FICTION / Thrillers / Domestic
 subject | 7430093 | 311994 | 16 | FICTION / Thrillers / Domestic
 subject_topic | 7430084 | 311994 | 14 | Family violence
 subject_topic | 7430089 | 311994 | 14 | Family violence
 subject | 7430095 | 311994 | 16 | Family violence
 subject | 7430090 | 311994 | 16 | Family violence Fiction
(12 rows)

I don't really get why it is showing all the duplicates.

The physical description also shows strange duplicate results.

Physical Description: print
print
print
436 pages ; 25 cm
436 pages ; 25 cm
436 pages ; 25 cm

Viewing the non search result based, non display field record detail view and everything looks fine.
https://egtest1.larl.org/eg/opac/record/311994

Subject:
Family violence > Fiction.
Adult child abuse victims > Fiction.
FICTION / Romance / Suspense.
FICTION / Thrillers / Domestic.
Adult child abuse victims.
Family violence.

Physical Description: 436 pages ; 25 cm