[teiid-issues] [JBoss JIRA] Created: (TEIID-1305) Problem executing an ORDER BY against the ModeShape data source

[Van Halbert (JIRA)]

Problem executing an ORDER BY against the ModeShape data source 
----------------------------------------------------------------

                 Key: TEIID-1305
                 URL: https://jira.jboss.org/browse/TEIID-1305
             Project: Teiid
          Issue Type: Bug
          Components: JDBC Connector
            Reporter: Van Halbert
            Assignee: Steven Hawkins
            Priority: Critical
             Fix For: 7.1.1


Exucuting query:     Select * From nt_base ORDER BY jcr_path

produces the following exception on the server:

[JDBCExecutionException] 0: Error Code:0 Message:'Column 'jcr_path' does not exist on the table 'g_0'
' error executing statement(s): [SQL: SELECT g_0."jcr:name", g_0."jcr:path", g_0."jcr:primaryType", g_0."jcr:score", g_0."mode:depth", g_0."mode:localName" FROM "nt:base" AS g_0 ORDER BY jcr_path]
1 [SQLException]Column 'jcr_path' does not exist on the table 'g_0'

2 [RepositoryException]Column 'jcr_path' does not exist on the table 'g_0'

	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)
	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
	at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:637)
Caused by: java.sql.SQLException: Column 'jcr_path' does not exist on the table 'g_0'


And according to my conversation with Steve, we are stripping aliases because modeshape does not support select expressions, but not properly handling the order by.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira