[teiid-issues] [JBoss JIRA] (TEIID-3401) OData layer generates incorrect alias names in orderby

[Sanjeev Gour (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13053998#comment-13053998 ] 

Sanjeev Gour commented on TEIID-3401:
-------------------------------------

I will try and see if I can create it easily. I tried with H2 but the query it generated was correct. My original problem is with a custom translator which reads the metadata from a csv file in the getMatada method. Do you have any idea if any translator property or the way metadata is generated will affect the query generation behaviour. With H2, there are no double quotes around the alias name in the order by but with the web service translator the alias name is enclosed in quotes causing the problem.

> OData layer generates incorrect alias names in orderby
> ------------------------------------------------------
>
>                 Key: TEIID-3401
>                 URL: https://issues.jboss.org/browse/TEIID-3401
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>            Reporter: Sanjeev Gour
>            Assignee: Steven Hawkins
>             Fix For: 8.7
>
>
> When a table has large number of columns, a request like the following http://localhost:8080/odata/VDB.1/objectName generates a query like SELECT col1 as c_1, col2 as c2.....col23 as c_23...col35 as c_35 ..FROM objectName ORDER BY "c_0", "c_1", "c_2", "c_3", "c_2"3, "c_3"5. Here c_0, c_1, c_2, c_3, c_23, c_35 happen to be the primary key columns. As seen in the query, the quotes around the column alias are incorrect for c_23 and c_35 which results into an invalid query.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)