ORDER BY fails with a subselect containing UNION ALL
----------------------------------------------------
Key: TEIID-4347
URL:
https://issues.jboss.org/browse/TEIID-4347
Project: Teiid
Issue Type: Bug
Reporter: Salvatore R
Assignee: Steven Hawkins
Running the following query:
{code:sql}
select s from
(
select 1 as o, 'a' as s
union all
select 0 as o, 'b' as s
)f order by f.o
{code}
throws java.lang.ArrayIndexOutOfBoundsException.
It looks like the bug occurs only if the element used in the order by clause is not
projected in the SELECT. In fact, this query works correctly:
{code:sql}
select s from
(
select 1 as o, 'a' as s
union all
select 0 as o, 'b' as s
)f order by f.s
{code}