Ticket #3083 (new defect)
Identical names appearing twice in name lookup
|Reported by:||tmb||Owned by:||cjg|
|Priority:||Would be nice||Milestone:||EPrints 3.2.10|
|Component:||Workflow & InputForm||Version:|
This lookup joins the eprint_creators_name and eprint_creators_id tables.
An author's name in eprint_creators_name may or may not have a corresponding row in eprint_creators_id. I have observed three cases:
1) ID entered for author: row in both creators_name and creators_id 2) No ID entered for author: row in both creators_name and creators_id (empty string for ID) 3) No ID entered for author: row in creators_name, no row in creators_id
In case 2, when creators_name and creators_id are joined in the name lookup script, the ID is empty string.
In case 3, when creators_name and creators_id are joined in the name lookup script, the ID is NULL.
So we can end up with 2 identical author names which are treated as 2 different entries by the name lookup because empty string != NULL. So we end up with the same name twice in the suggestion list.
Not sure if this is a bug with EPrints itself (should there always be a corresponding row for each creators_name in creators_id? - probably not) or whether we need to work around this in the lookup script.