[
https://issues.apache.org/jira/browse/OODT-551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luca Cinquini resolved OODT-551.
--------------------------------
Resolution: Fixed
The issue is solved by creating a primary key for the metadata table:
+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| product_id | varchar(100) | NO | | NULL | |
| element_id | varchar(1000) | NO | | NULL | |
| metadata_value | varchar(2500) | NO | | NULL | |
| pkey | int(10) unsigned | NO | PRI | NULL | auto_increment |
+----------------+------------------+------+-----+---------+----------------+
and returning values as "ORDER BY pkey'
> DataSourceCatalog implementation does not preserve order of metadata values
> ---------------------------------------------------------------------------
>
> Key: OODT-551
> URL: https://issues.apache.org/jira/browse/OODT-551
> Project: OODT
> Issue Type: Bug
> Components: file manager
> Affects Versions: 0.5
> Reporter: Luca Cinquini
> Assignee: Luca Cinquini
> Fix For: 0.6
>
>
> The table that stores the metadata (key, value) pairs for the File Manager
> database-based implementation has no primary key - as a consequence, values
> are not guaranteed to be returned in any order, which is a problem for
> applications that rely on the order of the values (for example, among
> different metadata keys).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
