Cannot execute SQL query using SQL function in SORT clause via view model

Solution Unverified - Updated -

Issue

If SQL query is contained using SQL function in SORT clause, the query cannot execute via view model.

Ex) SELECT C1 FROM TEST_TABLE_VW order by CAST(C3 AS integer)

Environment

  • JBoss Enterprise Data Services Platform (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In