July 2016 - teiid-issues - Jboss List Archives

[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 resolved TEIID-4347. ----------------------------------- Resolution: Duplicate Issue Thanks. This is a duplicate of TEIID-3858 > 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)

9 years, 8 months

1
0
0 / 0

[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)

9 years, 8 months

1
0
0 / 0

[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)

9 years, 8 months

1
0
0 / 0

[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)

9 years, 8 months

1
0
0 / 0

[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)

9 years, 8 months

1
0
0 / 0

[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)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2901) Excel translator with large documents

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2901?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2901: ---------------------------------- Fix Version/s: Open To Community > Excel translator with large documents > ------------------------------------- > > Key: TEIID-2901 > URL: https://issues.jboss.org/browse/TEIID-2901 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Fix For: Open To Community > > > Use Apache POI's event based SAX parsing for XLSX files to load large Excel documents. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4332) Enhance costing to better guess at ndv

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4332?page=com.atlassian.jira.plugin... ] Work on TEIID-4332 started by Steven Hawkins. --------------------------------------------- > Enhance costing to better guess at ndv > -------------------------------------- > > Key: TEIID-4332 > URL: https://issues.jboss.org/browse/TEIID-4332 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Our logic for determining ndv is mostly ad hoc and varies greatly depending upon the position in the plan. This needs to be more standardized and based upon consistent assumptions - also additional information such as predicates and foreign keys should influence the calculation. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4346) Remove excel-odbc translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4346?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4346. ----------------------------------- Resolution: Done Removed from the code / docs and added a release note. > 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)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2901) Excel translator with large documents

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2901?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2901: ------------------------------------- [~fox123] No immediate plans, as there not enough requests. If you would like to contribute, please let us know. > Excel translator with large documents > ------------------------------------- > > Key: TEIID-2901 > URL: https://issues.jboss.org/browse/TEIID-2901 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > > Use Apache POI's event based SAX parsing for XLSX files to load large Excel documents. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2016