openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Milosz Tylenda (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (OPENJPA-1465) Queries over multi-valued elements within XML column
Date Sun, 24 Oct 2010 15:12:18 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-1465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Milosz Tylenda reassigned OPENJPA-1465:
---------------------------------------

    Assignee:     (was: Milosz Tylenda)

> Queries over multi-valued elements within XML column
> ----------------------------------------------------
>
>                 Key: OPENJPA-1465
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1465
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: query, sql
>    Affects Versions: 1.2.1
>            Reporter: Milosz Tylenda
>
> A request for query support over multi-valued elements within XML column has been posted
on the user mailing list [1]. We currently support only queries over single-valued elements.
> I have investigated the matter a bit using MySQL. It seems that a query working correctly
over multi-valued elements can be constructed like this ("street" is multi-valued):
> select * from TORDER t0 where ExtractValue(t0.shipAddress,'count(/*/street[text()="Lelevela"])
>= 1') = 1;
> or
> select * from TORDER t0 where ExtractValue(t0.shipAddress,'count(/*/street[text()="Lelevela"])')
>= 1;
> What worries me is that such a query might not be indexable even if the database supports
indexes over expressions.
> [1] http://n2.nabble.com/collection-valued-path-ArgumentException-when-querying-based-on-multi-valued-elements-in-an-XML-colun-tp4162113p4162113.html

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message