[JCR-2561] SQL2 query - supplying column selector fails with NPE on getColumnName()

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0
• Fix Version/s: 2.1
• Component/s: jackrabbit-jcr-commons
• Labels: query sql2
• Assignee: Thomas Mueller
• Reporter: James Gadbury
• Created: 11/Mar/10 13:00
• Updated: 27/Apr/10 08:23
• Resolved: 11/Mar/10 15:22

Description

I am preparing and executing an SQL2 query (JCR 2.0) as follows:

QueryManager qm = jcrSession.getWorkspace().getQueryManager();
String queryString = "select order.[customerAccountUUID] as cust from [atl:order] as order";
Query query = qm.createQuery(queryString, Query.JCR_SQL2);
QueryResult queryResult = query.execute();

The following query fails:

select order.[customerAccountUUID] from [atl:order] as order

java.lang.NullPointerException
org.apache.jackrabbit.commons.query.sql2.QOMFormatter.isSimpleName(QOMFormatter.java:577)
org.apache.jackrabbit.commons.query.sql2.QOMFormatter.formatName(QOMFormatter.java:567)
org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:452)
org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:123)
org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:117)

line 452: c.getColumnName() returns null.

The following query is fine:

select order.[customerAccountUUID] as cust from [atl:order] as order

I have been using the test case (here: http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-spi-commons/src/test/resources/org/apache/jackrabbit/spi/commons/query/sql2/test.sql2.txt?view=markup) as a guideline.

Cheers,

James