Got ArrayIndexOutOfBoundsException while try to call Row.getValue(columnName)

[flyisland]

Hi all,

I'm a newbie for Modeshape, what I'm trying to do is to query some properties of parent and child node together, below is the JCR_SQL2:

{code:sql}SELECT parent.title, child.age FROM [nt:unstructured] as parent

                    FULL OUTER JOIN [nt:unstructured] as child ON ISCHILDNODE(child, parent)

                    WHERE child.age =10

{code}

the QueryResult.getColumnName() returns ["title", "age"], but I got the follow exception while I try to call Row.getValue("title") method

java.lang.ArrayIndexOutOfBoundsException: 14

          at org.modeshape.jcr.query.JcrQueryResult$MultiSelectorQueryResultRow.getValue(JcrQueryResult.java:651)

          at javax.jcr.query.Row$getValue.call(Unknown Source)

Can anyone tell me how to correct it, or show me some codesnip about getting result from "FULL OUTER JOIN" statement, thanks!

flyisland

[rhauch]

That's clearly a bug in the query engine, because clearly the code should work. Would you mind creating a JIRA issue for it? Be sure to denote which version you're using.

If you log it soon, I'll take a look at it today. We're getting close to locking down the changes for the next release, so it'd be good to get this fixed.

[flyisland]

Hi Randall, thanks for the quickly reply, I have just created the JIRA issue, you can check it at https://issues.jboss.org/browse/MODE-1277, thanks!

[rhauch]

Thanks for logging that issue!

I've replicated the problem with a test case (which is limited to full-outer joins), am running a build to verify a proposed fix, and should have a pull-request soon. I'll update the JIRA with the details, but it should be committed shortly and will definitely be in 2.6.0.FINAL (prolly next week).

[rhauch]

MODE-1277 has been resolved. Thanks again!

[flyisland]

Cool, I can't wait for the new release!