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
Assignee: 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.
