[ https://issues.jboss.org/browse/TEIID-4520?page=com.atlassian.jira.plugin... ] Rafal Korytkowski commented on TEIID-4520: ------------------------------------------ I've got one more intriguing issue. Executing: {code:sql} SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigDecimalValue ORDER BY BQT1.SmallA.IntKey {code} results in: {noformat} Error: 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. SQLState: 38000 ErrorCode: 0 {noformat} The same query runs just fine when I execute it against Exasol and not TEIID. A similar query: {code:sql} SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigIntegerValue ORDER BY BQT1.SmallA.IntKey {code} runs just fine in TEIID. It seems to have something to do with handling of the BigDecimal type. I'll continue investigating, but please let me know, if you have any clues. My current state of work is at https://github.com/teiid/teiid/compare/master...rkorytkowski:TEIID-4520 -- This message was sent by Atlassian JIRA (v7.5.0#75005)