[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....
]
Brett Meyer commented on ARTIF-664:
-----------------------------------
[~rhauch] & [~hchiorean], I know I've been bothering you guys a lot -- apologies!
In the thick of beta testing...
Is there anything obvious in that query that wouldn't be supported by 3.8.1? It works
great on 4.0. I've narrowed down the specific commit that broke the relationship
support, and that query structure is the only runtime delta.
I've been looking through JIRAs, etc. and can't find anything that sticks out.
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
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)