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

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-1305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1305.
-----------------------------------

    Resolution: Done


switched the logic that strips aliases to use actual column references in the order by clause.  This does not actually affect many of the connectors, since the majority do support selectexpressions/alias or if they do not then they also do not support order by.  In the future executionfactories may need an explicit property as to whether aliases should be used.

> 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