[ https://issues.jboss.org/browse/ARTIF-664?page=com.atlassian.jira.plugin.... ] Brett Meyer updated ARTIF-664: ------------------------------ Description: 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 was: Example: /s-ramp[expandedFromDocument] 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)