Identical names appearing twice in name lookup

[tmb]

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.