[teiid-issues] [JBoss JIRA] Resolved: (TEIID-755) Oracle Connector is not honouring metadata when rewriting ORDER BY clause

Thu Aug 6 14:20:29 EDT 2009

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

Steven Hawkins resolved TEIID-755.
----------------------------------

    Resolution: Rejected

The unit tests do not reflect that all queries with order by receive column aliases which are referenced in the order by clause.  If it's an unrelated column then the name on the order by item will not be set and the metadata form of the name will be used.

> Oracle Connector is not honouring metadata when rewriting ORDER BY clause
> -------------------------------------------------------------------------
>
>                 Key: TEIID-755
>                 URL: https://jira.jboss.org/jira/browse/TEIID-755
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 6.0.0, 6.1.0, 6.2.0
>            Reporter: Larry O'Leary
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 6.2.0
>
>   Original Estimate: 1 hour
>  Remaining Estimate: 1 hour
>
> When executing a query that contains an ORDER BY clause, the Oracle Connector is rewriting the query using the column name given by the MM query rather than the source name as specified in the source model.  What this means is that column name case is not being enforced.  
> For example:
> MM User Command:
> SELECT INTKEY FROM BQT1.SMALLA UNION SELECT INTKEY FROM BQT1.SMALLB ORDER BY INTKEY
> Model represents INTKEY as IntKey for source name.  Currently we rewrite as:
> SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY INTKEY
> This should actually be:
> SELECT SmallA.IntKey FROM SmallA UNION SELECT SmallB.IntKey FROM SmallB ORDER BY IntKey
> Although this does not trigger a failure with the current implementation, if the column names were qualified is SQL identifiers, the query would fail as Oracle is expecting a column name of "IntKey" and would not know what "INTKEY" was.

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