[teiid-issues] [JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL

[Salvatore R (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13268288#comment-13268288 ] 

Salvatore R commented on TEIID-4347:
------------------------------------

Hi Steven, thanks for the quick reply and sorry, I was using an old version.
I tried right now in latest 9.1.0-Alpha2 and I cannot reproduce it anymore.

> 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}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)