]
Steven Hawkins resolved TEIID-3401.
-----------------------------------
Resolution: Cannot Reproduce Bug
Thanks Sanjeev, marking as resolved for now.
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.