]
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.