June 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4972) Couchbase - query with comparison criteria not properly translated

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4972: ----------------------------------- Summary: Couchbase - query with comparison criteria not properly translated Key: TEIID-4972 URL: https://issues.jboss.org/browse/TEIID-4972 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Issuing simple query with comparison criteria like \[1\] returns empty result. From what I can see, the query is not properly translated - it is translated to query with syntax error \[2\]. Another issue here which I can see is that Teiid does not provide any information to the user that query actually failed. Only empty result is returned. This one, I will report it as a separate issue. {code:sql|title=\[1\] Query} SELECT BQT1.SmallA.FloatNum FROM BQT1.SmallA WHERE BQT1.SmallA.FloatNum = 7 {code} {code:plain|title=\[2\] Source-specific query} 10:16:09,749 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue86) TEIID29001 Source-specific Query: SELECT TONUMBER(`$cb_c1_FloatNum`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_FloatNum` = `$cb_t1`.`FloatNum`TONUMBER() WHERE TONUMBER(`$cb_c1_FloatNum`) = 7.0 AND `$cb_t1`.`type` = 'SmallA' {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4971) Infinispan Hotrod can't access remote instance

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4971: ---------------------------------- Summary: Infinispan Hotrod can't access remote instance Key: TEIID-4971 URL: https://issues.jboss.org/browse/TEIID-4971 Project: Teiid Issue Type: Bug Components: JDG Connector Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Blocker The Infinispan Hotrod connector writes to jdg's internal cache, which can't be accessed from remote hosts if the cache container is not secured and the user accessing the internal cache doesn't have specific privileges. User can't authenticate via resource-adapter currently, enhancement TEIID-4904 is needed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4970) Couchbase - GROUP BY returns empty result

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4970: ----------------------------------- Summary: Couchbase - GROUP BY returns empty result Key: TEIID-4970 URL: https://issues.jboss.org/browse/TEIID-4970 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Issuing query like \[1\] returns empty result. Query seems to not be properly translated to source-specific query \[2\] {code:sql|title=\[1\] Query} SELECT IntKey, SUM(IntKey) AS Total FROM BQT1.SmallA GROUP BY IntKey {code} {code:plain|title=\[2\] Source-specific query - GROUP BY clause refers to cb_c2 instead of cb_c1} 09:53:09,066 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue64) TEIID29001 Source-specific Query: SELECT `$cb_c1_IntKey`, SUM(`$cb_c2_IntKey`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_IntKey` = `$cb_t1`.`IntKey`, `$cb_c2_IntKey` = `$cb_t1`.`IntKey` WHERE `$cb_t1`.`type` = 'SmallA' GROUP BY `$cb_c2_IntKey` {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4969) Couchbase - ORDER BY returns empty result

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4969: ----------------------------------- Summary: Couchbase - ORDER BY returns empty result Key: TEIID-4969 URL: https://issues.jboss.org/browse/TEIID-4969 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Issuing query like \[1\] returns empty result. From what I can see, query seems to not be properly translated to the source-specific query \[2\]. {code:sql|title=\[1\] Query} SELECT IntKey AS Total FROM BQT1.SmallA ORDER BY IntKey {code} {code:plain|title=\[2\] Source-specific query - c_0 is not defined anywhere} 09:40:11,748 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue60) TEIID29001 Source-specific Query: SELECT `$cb_c1_IntKey` FROM `dvqe_small` `$cb_t1` LET `$cb_c1_IntKey` = `$cb_t1`.`IntKey`c_0 WHERE `$cb_t1`.`type` = 'SmallA' ORDER BY c_0 {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4968) oids are not unique in pg_attribute

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4968: ------------------------------------- Summary: oids are not unique in pg_attribute Key: TEIID-4968 URL: https://issues.jboss.org/browse/TEIID-4968 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 9.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.0, 9.3.1, 9.2.5 The pg_attribute table is not reporting a distinct set of oids even though it is marked as a pk column. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4904) Add support for identify security to the infinispan connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4904?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-4904 at 6/28/17 1:20 PM: ------------------------------------------------------------- No issues when implementing. The username/password is needed because the user that issues calls against the '___protobuf_metadata' cache (registering marshallers) is required to have the admin permission in JDG. In the 8.12.x version of the translator, the ability to specify the username/password was needed because the metadata was retrieved before a user query was submitted. And this appears to occurs when the hotrod client is in a different VM. was (Author: van.halbert): No issues when implementing. The username/password is needed because the user that issues calls against the '___protobuf_metadata' cache (registering marshallers) is required to have the admin permission in JDG. In the 8.12.x version of the translator, the ability to specify the username/password was needed because the metadata was retrieved before a user query was submitted. > Add support for identify security to the infinispan connector > ------------------------------------------------------------- > > Key: TEIID-4904 > URL: https://issues.jboss.org/browse/TEIID-4904 > Project: Teiid > Issue Type: Enhancement > Components: Infinispan > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 10.0 > > > Add support for identify secuirty to the new infinispan connector/translator. This is needed for openshift. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4904) Add support for identify security to the infinispan connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4904?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-4904 at 6/28/17 1:20 PM: ------------------------------------------------------------- No issues when implementing. The username/password is needed because the user that issues calls against the '___protobuf_metadata' cache (registering marshallers) is required to have the admin permission in JDG. In the 8.12.x version of the translator, the ability to specify the username/password was needed because the metadata was retrieved before a user query was submitted. And this appears to occurs when the hotrod client is in a different host machine. was (Author: van.halbert): No issues when implementing. The username/password is needed because the user that issues calls against the '___protobuf_metadata' cache (registering marshallers) is required to have the admin permission in JDG. In the 8.12.x version of the translator, the ability to specify the username/password was needed because the metadata was retrieved before a user query was submitted. And this appears to occurs when the hotrod client is in a different VM. > Add support for identify security to the infinispan connector > ------------------------------------------------------------- > > Key: TEIID-4904 > URL: https://issues.jboss.org/browse/TEIID-4904 > Project: Teiid > Issue Type: Enhancement > Components: Infinispan > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 10.0 > > > Add support for identify secuirty to the new infinispan connector/translator. This is needed for openshift. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4904) Add support for identify security to the infinispan connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4904?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4904: ------------------------------------ No issues when implementing. The username/password is needed because the user that issues calls against the '___protobuf_metadata' cache (registering marshallers) is required to have the admin permission in JDG. In the 8.12.x version of the translator, the ability to specify the username/password was needed because the metadata was retrieved before a user query was submitted. > Add support for identify security to the infinispan connector > ------------------------------------------------------------- > > Key: TEIID-4904 > URL: https://issues.jboss.org/browse/TEIID-4904 > Project: Teiid > Issue Type: Enhancement > Components: Infinispan > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 10.0 > > > Add support for identify secuirty to the new infinispan connector/translator. This is needed for openshift. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4904) Add support for identify security to the infinispan connector

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4904?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4904: ------------------------------------- [~van.halbert] can you tell me any issues you ran into last time around? > Add support for identify security to the infinispan connector > ------------------------------------------------------------- > > Key: TEIID-4904 > URL: https://issues.jboss.org/browse/TEIID-4904 > Project: Teiid > Issue Type: Enhancement > Components: Infinispan > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 10.0 > > > Add support for identify secuirty to the new infinispan connector/translator. This is needed for openshift. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4904) Add support for identify security to the infinispan connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4904?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4904: ------------------------------- Priority: Blocker (was: Major) > Add support for identify security to the infinispan connector > ------------------------------------------------------------- > > Key: TEIID-4904 > URL: https://issues.jboss.org/browse/TEIID-4904 > Project: Teiid > Issue Type: Enhancement > Components: Infinispan > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 10.0 > > > Add support for identify secuirty to the new infinispan connector/translator. This is needed for openshift. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

6 years, 12 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2017