[overlord-issues] [JBoss JIRA] (ARTIF-664) Queries with relationship predicates fail on EAP 6.2-6.4
[
https://issues.jboss.org/browse/ARTIF-664?page=com.atlassian.jira.plugin....
]
Horia Chiorean commented on ARTIF-664:
--------------------------------------
[~brmeyer]: the query engine (not necessarily the query parser) is radically different
between ModeShape 3 and ModeShape 4: ModeShape 3 uses Lucene & Hibernate search,
ModeShape 4 uses a custom, in-house query engine.
If you can build a test case we can run locally in ModeShape 3.x (even if it uses
artificer CND but with actual nodes & values) to reproduce the issue, feel free to log
a BZ and we'll investigate this for DV 6.2. You can look at our [query
tests|https://github.com/ModeShape/modeshape/blob/3.x/modeshape-jcr/src/t...]
for such examples.
Queries with relationship predicates fail on EAP 6.2-6.4
--------------------------------------------------------
Key: ARTIF-664
URL: https://issues.jboss.org/browse/ARTIF-664
Project: Artificer
Issue Type: Bug
Reporter: Brett Meyer
Assignee: Brett Meyer
Fix For: 1.1.0.Final, 1.0.0.Alpha2
Example:
{code}
/s-ramp[expandedFromDocument]
{code}
JCR-SQL2:
{code}
SELECT artifact1.* FROM [sramp:baseArtifactType] AS artifact1 WHERE
artifact1.[jcr:uuid] IN
(SELECT artifact2.[jcr:uuid] AS uuid FROM [sramp:relationship] AS relationship1
INNER JOIN [sramp:baseArtifactType] AS artifact2 ON
ISCHILDNODE(relationship1,artifact2)
WHERE (relationship1.[sramp:relationshipType] = 'expandedFromDocument' AND
ISDESCENDANTNODE(relationship1,'/s-ramp')))
AND ISDESCENDANTNODE(artifact1,'/s-ramp') ORDER BY artifact1.[sramp:name] ASC
{code}
The query simply returns nothing. Works perfectly for Wildfly 8
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)