February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3451) OData does not inject schema into queries

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3451?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3451: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1214445|https://bugzilla.redhat.com/show_bug.cgi?id=1214445] from VERIFIED to CLOSED > OData does not inject schema into queries > ----------------------------------------- > > Key: TEIID-3451 > URL: https://issues.jboss.org/browse/TEIID-3451 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11, 8.7.3 > > > OData service does not inject a fully qualified object names for tables for POSTS, PUTs, and DELETEs: > 12:50:34,367 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1) START USER COMMAND: startTime=2015-04-22 12:50:34.367 requestID=XxHTbednhDq7.0 txID=null sessionID=XxHTbednhDq7 applicationName=JDBC principal=teiidUser@teiid-security vdbName=ImsOne vdbVersion=2 sql=INSERT INTO Subscription (SUBSCRIPTION_ID, CLIENT_NAME, DEST_CONNECTION_URI, DEST_SCHEMA_NAME, DEST_TABLE_NAME, PROVIDER_URL, TOPIC_NAME) VALUES (?, ?, ?, ?, ?, ?, ?) > 12:50:34,380 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1) ERROR USER COMMAND: endTime=2015-04-22 12:50:34.379 requestID=XxHTbednhDq7.0 txID=null sessionID=XxHTbednhDq7 principal=teiidUser@teiid-security vdbName=ImsOne vdbVersion=2 finalRowCount=null > 12:50:34,380 WARN [org.teiid.PROCESSOR] (http-localhost/127.0.0.1:8080-1) TEIID30020 Processing exception for request XxHTbednhDq7.0 'Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace. > 12:50:34,383 WARN [org.teiid.ODATA] (http-localhost/127.0.0.1:8080-1) TEIID16012 Could not produce a successful OData response. Returning status ServerErrorException with message Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription. > Same insert works fine over JDBC. Offending line from 8.7.0 public github: > https://github.com/teiid/teiid/blob/8.7.x/odata/src/main/java/org/teiid/o... > Note that private Table findTable() on line 925 depends upon org.odata4j.core.EdmEntitySet#getName to return the name, but this is not fully qualified -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3226) Need to upgrade org.springframework to at least version 3.2.12

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3226?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3226: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1166378|https://bugzilla.redhat.com/show_bug.cgi?id=1166378] from VERIFIED to CLOSED > Need to upgrade org.springframework to at least version 3.2.12 > -------------------------------------------------------------- > > Key: TEIID-3226 > URL: https://issues.jboss.org/browse/TEIID-3226 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1, 8.10 > > > The spring framework version that's packaged with the connector-ws needs to be upgraded from 3.0.7 to 3.1.2. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3553) Odata - if table name is ambiguous, teiid returns result from first table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3553?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3553: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1234724|https://bugzilla.redhat.com/show_bug.cgi?id=1234724] from VERIFIED to CLOSED > Odata - if table name is ambiguous, teiid returns result from first table > ------------------------------------------------------------------------- > > Key: TEIID-3553 > URL: https://issues.jboss.org/browse/TEIID-3553 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12, 8.7.5 > > > If table name is ambiguous, teiid returns data from first matching table. I expect, that it should return error message similar to exception which is thrown via JDBC. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3094) SOLR: minus sign is not escaped

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3094?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3094: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1131576|https://bugzilla.redhat.com/show_bug.cgi?id=1131576] from VERIFIED to CLOSED > SOLR: minus sign is not escaped > ------------------------------- > > Key: TEIID-3094 > URL: https://issues.jboss.org/browse/TEIID-3094 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Alpha2 > Fix For: 8.7.1, 8.9 > > Attachments: server.log > > > Minus sign is not escaped in SOLR translator which causes parse exception, because the "-" is a special character. > Example of query: > Query: {code}SELECT BQT1.SmallA.IntNum FROM BQT1.SmallA WHERE BQT1.SmallA.IntNum = -1{code} > Query parameter q is set to: {code}IntNum:-1{code} but it should be: {code}IntNum:\-1{code} > Log is in the attachment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

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: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1272213|https://bugzilla.redhat.com/show_bug.cgi?id=1272213] from VERIFIED to CLOSED > 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)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3544) teiid-odata-*.war not deploying in EAP when using domain

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3544?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3544: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1233001|https://bugzilla.redhat.com/show_bug.cgi?id=1233001] from VERIFIED to CLOSED > teiid-odata-*.war not deploying in EAP when using domain > -------------------------------------------------------- > > Key: TEIID-3544 > URL: https://issues.jboss.org/browse/TEIID-3544 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.7.1.6_2 > > > The Teiid odata war, located: > modules/system/layers/dv/org/jboss/teiid/main/deployments/teiid-odata-8.7.1.6_2-redhat-2.war > was not being deployed. It's working in standalone. > The workaround in domain mode is to re-deploy the war using the admin console. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2990) MongoDB: Usage of lookup() function throws an exception

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2990?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2990: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1105121|https://bugzilla.redhat.com/show_bug.cgi?id=1105121] from VERIFIED to CLOSED > MongoDB: Usage of lookup() function throws an exception > ------------------------------------------------------- > > Key: TEIID-2990 > URL: https://issues.jboss.org/browse/TEIID-2990 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.8, 8.7.1 > > Attachments: server.log > > > Exception[1] is thrown when function lookup() is used in SQL query. > Mongo translator doesn't support selection of constants only, which causes the exception(select 1, select 'hi' from smalla). > {code} > [1] 3:59:20,997 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue6) Connector worker process failed for atomic-request=Ef2Z7E0246by.1.5.3: com.mongodb.CommandFailureException: { "serverUsed" : "localhost/127.0.0.1:27017" , "errmsg" : "exception: $projection requires at least one output field" , "code" : 16403 , "ok" : 0.0} > at com.mongodb.CommandResult.getException(CommandResult.java:71) > {code} > Server log is in the attachment. > Sample query: > {code} > SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey= lookup('BQT1.SmallB', 'IntKey', 'StringKey', BQT1.SmallA.StringKey) ORDER BY IntKey > {code} > Generated mongo commands: > {code} > { aggregate: "smalla", pipeline: [ { $project: { _m0: "$INTKEY", _m1: "$STRINGKEY" } } ] } > {code} > and > {code} > { aggregate: "smallb", pipeline: [ { $project: {} } ] } > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2919) BigInteger and BigDecimal datatypes are converted into string in MongoDB translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2919: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1084373|https://bugzilla.redhat.com/show_bug.cgi?id=1084373] from VERIFIED to CLOSED > BigInteger and BigDecimal datatypes are converted into string in MongoDB translator > ------------------------------------------------------------------------------------- > > Key: TEIID-2919 > URL: https://issues.jboss.org/browse/TEIID-2919 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Filip Elias > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > Description of problem: > BigInteger and BigDecimal datatypes are converted into string in MongoDB translator (MongoDBExecutionFactory.java). User can't use these datatypes in the WHERE clause. > For example > The query: > > SELECT IntKey FROM SmallA where BIGINTEGERVALUE > 1 > returns no results because BIGINTEGERVALUE > 1 is converted into > { "BIGINTEGERVALUE" : { "$gt" : "1"}} > but is should be > { "BIGINTEGERVALUE" : { "$gt" : 1}} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3228) SOLR: Date and Timestamp parsing is incorrect

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3228?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3228: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1166577|https://bugzilla.redhat.com/show_bug.cgi?id=1166577] from VERIFIED to CLOSED > SOLR: Date and Timestamp parsing is incorrect > --------------------------------------------- > > Key: TEIID-3228 > URL: https://issues.jboss.org/browse/TEIID-3228 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Alpaha1 > Fix For: 8.7.1, 8.10 > > > SolrSQLHierarchyVisitor uses incorrect Date and Timestamp pattern. > The pattern for Date is yyyy-MM-DD, but it should be yyyy-MM-dd. > DD represents day in year, not day in month > Similar issue occurs for Timestamp. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3368) The database-service.jar needs version version in its name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3368?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3368: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1199048|https://bugzilla.redhat.com/show_bug.cgi?id=1199048] from VERIFIED to CLOSED > The database-service.jar needs version version in its name > ---------------------------------------------------------- > > Key: TEIID-3368 > URL: https://issues.jboss.org/browse/TEIID-3368 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1, 8.11 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.10 > > > The database-service.jar in the tepid-extensions needs to be built with a version in the name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016