Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
None
-
None
-
None
Description
Hello together,
when using orderby together with an odata expand operation I get and error. The statement I am trying looks as follows:
The error is:
<error xmlns="http://docs.oasis-open.org/odata/ns/metadata">
<code>null</code>
<message>
TEIID31202 Detected that an already sorted set of values was not in the expected order (typically UTF-16 / UCS-2). Please check the translator settings to ensure character columns used for joining are sorted as expected.
</message>
</error>
Please note, when using orderby without expand, the orderby is working as expected. The attribute which shall be used for ordering has the following type:
<Property Name="MealNumber" Type="Edm.String" Nullable="false" MaxLength="1">
In the underlaying database it is defined as an ENUM('1','2','3','4','5')