[teiid-issues] [JBoss JIRA] (TEIID-2197) Temp table ordering not honored with index

Temp table ordering not honored with index ------------------------------------------ Key: TEIID-2197 URL: https://issues.jboss.org/browse/TEIID-2197 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.7.2, 8.2 If an IN predicate against an index is not entered in ascending order and an order by is specified against the same index, then the result will not be ordered properly. For example: create local temporary table x (e1 string, e2 integer, primary key (e2)) ... select * from x as y where e2 in (3, 2) order by e2