[JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL
by Salvatore R (JIRA)
[ https://issues.jboss.org/browse/TEIID-4347?page=com.atlassian.jira.plugin... ]
Salvatore R commented on TEIID-4347:
------------------------------------
It was 8.12-CR1
> 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)
8 years, 5 months
[JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4347?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4347:
---------------------------------------
Which older version? There may be some patching that is applicable.
> 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)
8 years, 5 months
[JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL
by Salvatore R (JIRA)
[ https://issues.jboss.org/browse/TEIID-4347?page=com.atlassian.jira.plugin... ]
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)
8 years, 5 months
[JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4347?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4347:
---------------------------------------
What version are you on?
> 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)
8 years, 5 months
[JBoss JIRA] (TEIID-4347) ORDER BY fails with a subselect containing UNION ALL
by Salvatore R (JIRA)
Salvatore R created TEIID-4347:
----------------------------------
Summary: 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)
8 years, 5 months
[JBoss JIRA] (TEIID-4346) Remove excel-odbc translator
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4346:
-------------------------------------
Summary: Remove excel-odbc translator
Key: TEIID-4346
URL: https://issues.jboss.org/browse/TEIID-4346
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1
Now that we are on 1.8 there is no more odbc bridge, thus the excel-odbc translator should be removed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months