when using orderby together with an odata expand operation I get and error. The statement I am trying looks as follows:
The error is:
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.
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')