June 2016 - teiid-issues - Jboss List Archives

[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: ---------------------------------- Priority: Critical (was: Major) > 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, 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-4183) MSSQL JDBC driver invalidates kerberos ticket on Connection.close()

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4183?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4183: ------------------------------------- Is VDB a Dynamic VDB without DDL inside, and trying to fetch the metadata on deploy? If that is the case this NONE of the pass-through security scenarios work, as at deployment time the user can not be a future logged user. You must either use a VDB with DDL or Designer based VDB. Also, the correct test be, testing with and without <module-option name="wrapGSSCredential" value="true"/> to validate this JIRA. > MSSQL JDBC driver invalidates kerberos ticket on Connection.close() > ------------------------------------------------------------------- > > Key: TEIID-4183 > URL: https://issues.jboss.org/browse/TEIID-4183 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x, 8.7.5.6_2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > MSSQL JDBC driver invalidate kerberos ticket on Connection.close() (related bugzilla \[1\]). > If user creates kerberos connection, driver invalidates ticket on closing connection (Connection.close()). Therefore ticket cannot be re-used. EAP team creates a workaround for this by adding module option *wrapGSSCredential=true* with additional setting *credentialLifetime=-1* \[2, 3, 4, 5\]. This works for static kerberos authentication. > However, passthrough authentication (org.teiid.jboss.PassthroughIdentityLoginModule) does not work, because passed ticket is not managed by EAP but by client. > \[1\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276 > \[2\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276#c58 > \[3\] https://issues.jboss.org/browse/SECURITY-905 > \[4\] https://issues.jboss.org/browse/JBEAP-843 > \[5\] https://github.com/wildfly-security/jboss-negotiation/commit/0c7e06f58a79... -- 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 RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4273?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4273: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1346980, https://bugzilla.redhat.com/show_bug.cgi?id=1347311 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1346980) > 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.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 RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4272?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4272: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1347309 Bugzilla Update: Perform > 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, 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-4274) FunctionMethods don't set datatypes

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4274: ------------------------------------- Summary: 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-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.7.7.6_2 > 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.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-4273) With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4273?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4273: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1346980 Bugzilla Update: Perform > 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, 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 RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4272?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4272: ------------------------------------------- Bugzilla References: (was: https://bugzilla.redhat.com/show_bug.cgi?id=1346980) Bugzilla Update: (was: Perform) > 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, 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-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 commented on TEIID-3685: --------------------------------------- Never mind. I see this still occurs on master. The issue is with the clone of a IN predicate - we are reverting it back to a hash set, rather than a tree structure. > 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: 8.12, 8.11.4, 8.7.2.6_2 > > 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 commented on TEIID-3685: --------------------------------------- What version are you looking at? > 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: 8.12, 8.11.4, 8.7.2.6_2 > > 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