[teiid-issues] [JBoss JIRA] Closed: (TEIID-1305) Problem executing an ORDER BY against the ModeShape data source
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Fri Nov 5 12:46:05 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-1305.
---------------------------------
> 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
More information about the teiid-issues
mailing list