Check that handle.resource_id=item.item_id
The command:
SELECT handle.* from item, handle where handle.resource_id=item.item_id and handle = 2204;
yields:
The command:
SELECT item.* from item, handle where handle.resource_id=item.item_id and handle = 2204;
yields:
Finally the command:
select * from itemsbytitle where item_id=2;
yields:
All of this implies that the URL:
https://odin.lib.umn.edu:9031/dspace-ir/handle/2204
Will resolve to a record with the title:
xponentially growing solutions for inverse problems in PDE
This is what happens.
SELECT handle.* from item, handle where handle.resource_id=item.item_id and handle = 2204;
yields:
| handle_id | handle | resource_type_id | resource_id |
| 5 | 2204 | 2 | 2 |
SELECT item.* from item, handle where handle.resource_id=item.item_id and handle = 2204;
yields:
| item_id | submitter_id | in_archive | withdrawn | last_modified | owning_collection |
| 2 | 1 | t | f | 2007-12-13 16:53:15.767-06 | 1 |
select * from itemsbytitle where item_id=2;
yields:
| items_by_title_id | item_id | title | sort_title |
| 3727 | 2 | xponentially growing solutions for inverse problems in PDE | xponentially growing solutions for inverse problems in pde |
All of this implies that the URL:
https://odin.lib.umn.edu:9031/dspace-ir/handle/2204
Will resolve to a record with the title:
xponentially growing solutions for inverse problems in PDE
This is what happens.