June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3685) org.teiid.padSpace does not affect to the "IN" operator

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3685?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-3685: --------------------------------- Fix Version/s: 8.7.7.6_2 > org.teiid.padSpace does not affect to the "IN" operator > ------------------------------------------------------- > > Key: TEIID-3685 > URL: https://issues.jboss.org/browse/TEIID-3685 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Environment: JBoss DV 6.1.2 > Reporter: hisao furuichi > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0, 8.7.7.6_2, 8.13.6, 9.0.1 > > Attachments: datasert.csv, INTERNAL_TEST.zip, test.vdb > > > org.teiid.padSpace does affect to "=" operator. But does not affect to "IN" operator. > [data for a column named "id"] > {noformat} > "test1 " > {noformat} > ["=" operator] I can get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1'; > {noformat} > ["IN" operator] I can not get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2'); > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4273) With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4273?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4273: ---------------------------------- Fix Version/s: 8.12.5 > With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table > --------------------------------------------------------------------------------------------------- > > Key: TEIID-4273 > URL: https://issues.jboss.org/browse/TEIID-4273 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.5, 8.7.7.6_2, 9.0.1 > > > A query such as: > WITH qry_0 as /\*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t), qry_1 as /\*+ no_inline */ (SELECT 'b' AS a1) select (select a1 || 'a' from qry_1) as x, a1 from qry_0 > where the projected scalar subquery cannot be pushed down, but the rest of the query can will result in the with plan for qry_1 not being associated with the parent RelationalPlan and results in an exception that the temporary table cannot be found. This does not occur if the clause is inlined (9.0+). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4272) NPE when CTE and subuquery without a WITH clause are pushed together

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4272?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4272. ----------------------------------- Resolution: Done Moved the check to remove the with clause. > NPE when CTE and subuquery without a WITH clause are pushed together > -------------------------------------------------------------------- > > Key: TEIID-4272 > URL: https://issues.jboss.org/browse/TEIID-4272 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.5, 9.0.1 > > > With a query such as: > WITH qry_0 as /*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t) select (select e1 from pm1.g1) as x, a1 from qry_0 > that is pushed together to the source, the relationalplanner will throw an NPE when pulling up any nested with clauses because there is no with clause assigned to the subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4272) NPE when CTE and subuquery without a WITH clause are pushed together

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4272?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4272: ---------------------------------- Fix Version/s: 8.12.5 > NPE when CTE and subuquery without a WITH clause are pushed together > -------------------------------------------------------------------- > > Key: TEIID-4272 > URL: https://issues.jboss.org/browse/TEIID-4272 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.12.5, 9.0.1 > > > With a query such as: > WITH qry_0 as /*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t) select (select e1 from pm1.g1) as x, a1 from qry_0 > that is pushed together to the source, the relationalplanner will throw an NPE when pulling up any nested with clauses because there is no with clause assigned to the subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3739) Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3739?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3739: ------------------------------------------------ Alex Szczuczko <aszczucz(a)redhat.com> changed the Status of [bug 1268308|https://bugzilla.redhat.com/show_bug.cgi?id=1268308] from MODIFIED to ON_QA > Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed > ---------------------------------------------------------------------------------------------- > > Key: TEIID-3739 > URL: https://issues.jboss.org/browse/TEIID-3739 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.5, 8.7.2.6_2, 8.7.6 > > Attachments: dynovdb1-vdb.xml, dynovdb2-vdb.xml > > > When using a Dynamic VDB that imports another VDB it isn't redeployed if the imported VDB is redeployed. You can in the log it undeploys the top VDB and the imported VDB but only redeploys the imported one. The top VDB then doesn't exist until it's redeployed. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3757) OData V2: $top doesn't work with virtual procedures

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3757?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3757: ------------------------------------------------ Alex Szczuczko <aszczucz(a)redhat.com> changed the Status of [bug 1272211|https://bugzilla.redhat.com/show_bug.cgi?id=1272211] from MODIFIED to ON_QA > OData V2: $top doesn't work with virtual procedures > --------------------------------------------------- > > Key: TEIID-3757 > URL: https://issues.jboss.org/browse/TEIID-3757 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Debbie Steigner > Assignee: Ramesh Reddy > Fix For: 8.7.2.6_2, 8.12.1, 8.7.6 > > Attachments: odat.vdb > > > When using OData to query a virtual procedure with a input parameter $top gets ignored: > http://127.0.0.1:8080/odata/odat/proctest?string_in='30'&$top=5 > Returns all the rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4017: ------------------------------------------------ Alex Szczuczko <aszczucz(a)redhat.com> changed the Status of [bug 1314864|https://bugzilla.redhat.com/show_bug.cgi?id=1314864] from MODIFIED to ON_QA > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.13.2, 8.7.5.6_2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4274) FunctionMethods don't set datatypes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4274?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4274. ----------------------------------- Resolution: Done Attempted to set the datatypes in most places and made the DDL logic tolerant of not having the datatype. > FunctionMethods don't set datatypes > ----------------------------------- > > Key: TEIID-4274 > URL: https://issues.jboss.org/browse/TEIID-4274 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Several methods of adding a FunctionMethod to the metadata do not set the Datatype - which is an issue if DDL is generated, then a NPE is generated. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3685) org.teiid.padSpace does not affect to the "IN" operator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3685?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3685: ---------------------------------- Fix Version/s: 8.13.6 > org.teiid.padSpace does not affect to the "IN" operator > ------------------------------------------------------- > > Key: TEIID-3685 > URL: https://issues.jboss.org/browse/TEIID-3685 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Environment: JBoss DV 6.1.2 > Reporter: hisao furuichi > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0, 8.13.6, 9.0.1 > > Attachments: datasert.csv, INTERNAL_TEST.zip, test.vdb > > > org.teiid.padSpace does affect to "=" operator. But does not affect to "IN" operator. > [data for a column named "id"] > {noformat} > "test1 " > {noformat} > ["=" operator] I can get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1'; > {noformat} > ["IN" operator] I can not get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2'); > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3685) org.teiid.padSpace does not affect to the "IN" operator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3685?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3685. ----------------------------------- Fix Version/s: 9.0.1 9.0 (was: 8.12) (was: 8.11.4) (was: 8.7.2.6_2) Resolution: Done Also needed to correct the clone method for this to work as expected for temporary tables - and it would also affect other scenarios where the criteria was cloned, but not fully pushed to a non-temporary source. > org.teiid.padSpace does not affect to the "IN" operator > ------------------------------------------------------- > > Key: TEIID-3685 > URL: https://issues.jboss.org/browse/TEIID-3685 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Environment: JBoss DV 6.1.2 > Reporter: hisao furuichi > Assignee: Steven Hawkins > Fix For: 9.0.1, 9.0 > > Attachments: datasert.csv, INTERNAL_TEST.zip, test.vdb > > > org.teiid.padSpace does affect to "=" operator. But does not affect to "IN" operator. > [data for a column named "id"] > {noformat} > "test1 " > {noformat} > ["=" operator] I can get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id ='TEST1'; > {noformat} > ["IN" operator] I can not get a result > {noformat} > SELECT * FROM ViewModel.originalViewTable WHERE ViewModel.originalViewTable.id IN ('TEST1', 'TEST2'); > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016