« part of regex to find sql attacks | Main | Test media filter ... DSPACE UDC side »

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:
handle_id handle resource_type_id resource_id
5 2204 2 2
The command:
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
Finally the command:
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.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)