[overlord-issues] [JBoss JIRA] (ARTIF-664) Queries with relationship predicates fail on EAP 6.2-6.4

[Brett Meyer (JIRA)]

     [ https://issues.jboss.org/browse/ARTIF-664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brett Meyer updated ARTIF-664:
------------------------------
    Fix Version/s:     (was: 1.1.0.Final)
                       (was: 1.0.0.Beta1)


> 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)