May 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3672) Odata - if table does not contain element with required key then teiid trows NPE

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3672?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3672: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1259592|https://bugzilla.redhat.com/show_bug.cgi?id=1259592] from ON_QA to VERIFIED > Odata - if table does not contain element with required key then teiid trows NPE > -------------------------------------------------------------------------------- > > Key: TEIID-3672 > URL: https://issues.jboss.org/browse/TEIID-3672 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > > If table does not contain element with primary key defined in URL, then Teiid throws NPE: > [org.teiid.ODATA] (http-/127.0.0.1:8180-4) TEIID16013 Error occurred producing OData result.: java.lang.NullPointerException > at org.odata4j.format.xml.AtomEntryFormatWriter.write(AtomEntryFormatWriter.java:51) [odata-core-0.8.7.redhat-3.jar:0.8.7.redhat-3] > at org.odata4j.format.xml.AtomEntryFormatWriter.write(AtomEntryFormatWriter.java:20) [odata-core-0.8.7.redhat-3.jar:0.8.7.redhat-3] > at org.odata4j.producer.resources.EntityRequestResource.getEntityImpl(EntityRequestResource.java:309) [odata-core-0.8.7.redhat-3.jar:0.8.7.redhat-3] > at org.odata4j.producer.resources.EntityRequestResource.getEntity(EntityRequestResource.java:273) [odata-core-0.8.7.redhat-3.jar:0.8.7.redhat-3] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_40] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_40] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40] > at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40] > at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:561) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:543) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:128) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:118) [classes:] > at org.teiid.odata.ODataServlet.service(ODataServlet.java:65) [classes:] > at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.12.Final-redhat-1.jar:] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.10.Final-redhat-1.jar:7.5.10.Final-redhat-1] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4224) HANA translator : incorrect pushdown of DAYOFWEEK function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4224?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4224: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1339611 Bugzilla Update: Perform > HANA translator : incorrect pushdown of DAYOFWEEK function > ---------------------------------------------------------- > > Key: TEIID-4224 > URL: https://issues.jboss.org/browse/TEIID-4224 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > Teiid's DAYOFWEEK function: > {code:plain} > DAYOFWEEK(x) Return day of week (Sunday=1, Saturday=7) > {code} > is pushed down as: > {code:plain} > dayname(g_0."DATEVALUE") > {code} > but this function returns string representation of the day. > More appropriate would be to push DAYOFWEEK as WEEKDAY function, but the returned value has to be adapted to Teiid's representation (Sunday=1 and Saturday=7, vs. HANA's Monday=0,Sunday=6). So the solution would be to push: > {code:sql} > MOD((WEEKDAY(datevalue)+1),7)+1 > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4224) HANA translator : incorrect pushdown of DAYOFWEEK function

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4224: ---------------------------------- Summary: HANA translator : incorrect pushdown of DAYOFWEEK function Key: TEIID-4224 URL: https://issues.jboss.org/browse/TEIID-4224 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Teiid's DAYOFWEEK function: {code:plain} DAYOFWEEK(x) Return day of week (Sunday=1, Saturday=7) {code} is pushed down as: {code:plain} dayname(g_0."DATEVALUE") {code} but this function returns string representation of the day. More appropriate would be to push DAYOFWEEK as WEEKDAY function, but the returned value has to be adapted to Teiid's representation (Sunday=1 and Saturday=7, vs. HANA's Monday=0,Sunday=6). So the solution would be to push: {code:sql} MOD((WEEKDAY(datevalue)+1),7)+1 {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4207) Limit pushdown is incorrect for simpledb

by Tugba Dogan (JIRA)

[ https://issues.jboss.org/browse/TEIID-4207?page=com.atlassian.jira.plugin... ] Tugba Dogan commented on TEIID-4207: ------------------------------------ I checked the connector's source code.There are 2 options to solve this issue: * We can remove the limit support by removing the following lines. {code:java} @Override public boolean supportsRowLimit() { return true; } {code} {code:java} if (!useSelectLimit() && obj.getLimit() != null) { buffer.append(Tokens.SPACE); append(obj.getLimit()); } {code} * We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. > Limit pushdown is incorrect for simpledb > ---------------------------------------- > > Key: TEIID-4207 > URL: https://issues.jboss.org/browse/TEIID-4207 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Tugba Dogan > Fix For: 9.0, 8.12.5, 8.13.5 > > > The limit clause for simpledb sets a page size rather than fully limiting results, thus our pushdown is incorrect. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4207) Limit pushdown is incorrect for simpledb

by Tugba Dogan (JIRA)

[ https://issues.jboss.org/browse/TEIID-4207?page=com.atlassian.jira.plugin... ] Tugba Dogan edited comment on TEIID-4207 at 5/25/16 8:08 AM: ------------------------------------------------------------- I checked the connector's source code.There are 2 options to solve this issue: * We can remove the limit support by removing the following lines. {code:java} @Override public boolean supportsRowLimit() { return true; } {code} {code:java} if (!useSelectLimit() && obj.getLimit() != null) { buffer.append(Tokens.SPACE); append(obj.getLimit()); } {code} * We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. was (Author: tugbadogan): I checked the connector's source code.There are 2 options to solve this issue: * We can remove the limit support by removing the following lines. {code:java} @Override public boolean supportsRowLimit() { return true; } {code} {code:java} if (!useSelectLimit() && obj.getLimit() != null) { buffer.append(Tokens.SPACE); append(obj.getLimit()); } {code} * We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. > Limit pushdown is incorrect for simpledb > ---------------------------------------- > > Key: TEIID-4207 > URL: https://issues.jboss.org/browse/TEIID-4207 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Tugba Dogan > Fix For: 9.0, 8.12.5, 8.13.5 > > > The limit clause for simpledb sets a page size rather than fully limiting results, thus our pushdown is incorrect. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4223) Hana translator: incorrect pushdown of QUARTER function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4223?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4223: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1339584 Bugzilla Update: Perform > Hana translator: incorrect pushdown of QUARTER function > ------------------------------------------------------- > > Key: TEIID-4223 > URL: https://issues.jboss.org/browse/TEIID-4223 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > Teiid's QUARTER function returns integer. > SAP HANA's QUARTER function returns string in form: > {code:plain} > 2000-Q1 > {code} > So the function either shouldn't be pushed down, or it has to be pushed down together with some substring method wrapping it: > {code:sql} > SUBSTR_REGEXPR('[[:digit:]]{4}\-Q([[:digit:]]{1})' IN quarter(datevalue) GROUP 1) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4223) Hana translator: incorrect pushdown of QUARTER function

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4223: ---------------------------------- Summary: Hana translator: incorrect pushdown of QUARTER function Key: TEIID-4223 URL: https://issues.jboss.org/browse/TEIID-4223 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Teiid's QUARTER function returns integer. SAP HANA's QUARTER function returns string in form: {code:plain} 2000-Q1 {code} So the function either shouldn't be pushed down, or it has to be pushed down together with some substring method wrapping it: {code:sql} SUBSTR_REGEXPR('[[:digit:]]{4}\-Q([[:digit:]]{1})' IN quarter(datevalue) GROUP 1) {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4221) HANA translator: incorrect pushdown of week function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4221?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4221: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1339568 Bugzilla Update: Perform > HANA translator: incorrect pushdown of week function > ---------------------------------------------------- > > Key: TEIID-4221 > URL: https://issues.jboss.org/browse/TEIID-4221 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > Hana translator pushes down function week to SAP HANA datasource as its WEEK function. But it is not in accordance with the ISO8601 rule. > For this standard, HANA has function ISOWEEK, which returns results in following format: > {code:plain} > 2000-W01 for date 'Jan 3, 2000' > {code} > So it should be possible to push Teiid's WEEK function as: > {code:sql} > SUBSTR_REGEXPR('[[:digit:]]{4}\-W([[:digit:]]{2})' IN ISOWEEK(datevalue) GROUP 1) > {code} > where 'datevalue' is column of DATE datatype. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4222) replace JBoss AS to WildFly

by Kylin Soong (JIRA)

Kylin Soong created TEIID-4222: ---------------------------------- Summary: replace JBoss AS to WildFly Key: TEIID-4222 URL: https://issues.jboss.org/browse/TEIID-4222 Project: Teiid Issue Type: Sub-task Components: Documentation Affects Versions: 9.x Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 9.x There are lots of place depict server as "JBoss AS", but start from 8.13, server is "WildFly". -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4221) HANA translator: incorrect pushdown of week function

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4221: ---------------------------------- Summary: HANA translator: incorrect pushdown of week function Key: TEIID-4221 URL: https://issues.jboss.org/browse/TEIID-4221 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Hana translator pushes down function week to SAP HANA datasource as its WEEK function. But it is not in accordance with the ISO8601 rule. For this standard, HANA has function ISOWEEK, which returns results in following format: {code:plain} 2000-W01 for date 'Jan 3, 2000' {code} So it should be possible to push Teiid's WEEK function as: {code:sql} SUBSTR_REGEXPR('[[:digit:]]{4}\-W([[:digit:]]{2})' IN ISOWEEK(datevalue) GROUP 1) {code} where 'datevalue' is column of DATE datatype. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 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 May 2016