]
Steven Hawkins commented on TEIID-3401:
---------------------------------------
Can you provide more information, such as a logs showing where the problem query is
formed? The odata layer does not have any logic that would manipulate an order by in this
way.
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.