April 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4855) Google translator behaves unexpectedly for multi value INSERT with null

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4855?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4855: ---------------------------------------- On latest teiid 9.3 this issue doesn't appear. > Google translator behaves unexpectedly for multi value INSERT with null > ----------------------------------------------------------------------- > > Key: TEIID-4855 > URL: https://issues.jboss.org/browse/TEIID-4855 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Following query with multivalue insert generates unexpected results: > * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) > - row 1: Intkey = 1, Intnum and other columns are empty > - row 2: Intkey = 2, Intnum and other columns (StringNum, BooleanValue,...) have value set to 20 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4855) Google translator behaves unexpectedly for multi value INSERT with null

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4855?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4855: ----------------------------------- Description: Following query with multivalue insert generates unexpected results: * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) - row 1: Intkey = 1, Intnum and other columns are empty - row 2: Intkey = 2, Intnum and other columns (StringNum, BooleanValue,...) have value set to 20 was: Following query with multivalue insert generates unexpected results: * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) - row 1: Intkey = 1, Intnum and other columns are empty - row 2: Intkey = 2, Intnum and other columns have value set to 20 > Google translator behaves unexpectedly for multi value INSERT with null > ----------------------------------------------------------------------- > > Key: TEIID-4855 > URL: https://issues.jboss.org/browse/TEIID-4855 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Following query with multivalue insert generates unexpected results: > * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) > - row 1: Intkey = 1, Intnum and other columns are empty > - row 2: Intkey = 2, Intnum and other columns (StringNum, BooleanValue,...) have value set to 20 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4857) Add file metadata such as creation and last modified date to file translator functions

by Marc Shirley (JIRA)

Marc Shirley created TEIID-4857: ----------------------------------- Summary: Add file metadata such as creation and last modified date to file translator functions Key: TEIID-4857 URL: https://issues.jboss.org/browse/TEIID-4857 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Marc Shirley Assignee: Steven Hawkins Add file metadata such as creation date and last modified date to the data returned by the file translator functions (getFiles/getTextFiles). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4754) Wrong result with bidirectional relationship

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4754?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4754: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1440762, https://bugzilla.redhat.com/show_bug.cgi?id=1440939 Bugzilla Update: Perform > Wrong result with bidirectional relationship > -------------------------------------------- > > Key: TEIID-4754 > URL: https://issues.jboss.org/browse/TEIID-4754 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2, 9.1.4 > > > From the forum post, two tables that relate to each other: > EmployeeMasterEntity (PK EmployeeID, FK Departments) > OrganizationalUnitEntity (PK OrganizationalUnitID, FK Managers) > With data like: > EmployeeMasterEntity > EmployeeID Department > 1 10000001 > 2 10000002 > 3 10000001 > > OrganizationalUnitEntity > OrganizationaUnitID UnitManager > 10000001 1 > 10000002 2 > 10000003 2 > Will not return the correct results for a query such as: > http://localhost:8080/odata4/TestOdata.1/InterlemView/EmployeeMasterEntit... > This is due to using the wrong relationship for the navigation. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4856) OData - Teiid throws IndexOutOfBoundsException if user requests value of nonexistent propery

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4856: ----------------------------------- Summary: OData - Teiid throws IndexOutOfBoundsException if user requests value of nonexistent propery Key: TEIID-4856 URL: https://issues.jboss.org/browse/TEIID-4856 Project: Teiid Issue Type: Bug Components: OData Affects Versions: 9.3 Reporter: Juraj Duráni Assignee: Steven Hawkins If user requests property of entity which is not present, Teiid returns 404 (this is correct behavior). However, if user requests value of the property ($value), Teiid returns 500 which is cause by IndexOutOfBoundsException \[1\]. VDB \[2\]. http://localhost:8080/odata4/vdb/test/t1(1)/fk/id/ - returns 404 http://localhost:8080/odata4/vdb/test/t1(1)/fk/id/$value - returns 500 {code:text|title=\[1\] Exception} 09:20:27,462 ERROR [org.teiid.ODATA] (default task-26) TEIID16052 Unable to process odata request due to: Index: 0, Size: 0: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:638) at java.util.ArrayList.get(ArrayList.java:414) at org.teiid.olingo.service.TeiidServiceHandler$1.visit(TeiidServiceHandler.java:189) at org.apache.olingo.server.core.responses.PrimitiveValueResponse.accepts(PrimitiveValueResponse.java:113) at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:179) at org.apache.olingo.server.core.requests.DataRequest$ValueRequest.execute(DataRequest.java:674) at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255) at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160) at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98) at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67) at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:228) at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.gzip.GzipFilter.doFilter(GzipFilter.java:61) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:284) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:263) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:174) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:793) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:744) {code} {code:xml|title=\[2\] VDB} <vdb name="vdb" version="1"> <model name="test" type="VIRTUAL"> <metadata> CREATE VIEW t1 ( id integer PRIMARY KEY, fid integer, CONSTRAINT fk FOREIGN KEY (fid) REFERENCES t1(id)) AS SELECT 1, null; </metadata> </model> </vdb> {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4854: ----------------------------------- Affects Version/s: 8.12.10.6_3 > Google translator fails to update timestamp value reformatted after update > -------------------------------------------------------------------------- > > Key: TEIID-4854 > URL: https://issues.jboss.org/browse/TEIID-4854 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: gs-reformatted-timestamp.log > > > Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4853) Google translator does not allow update of empty String type cell

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4853?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4853: ----------------------------------- Affects Version/s: 8.12.10.6_3 > Google translator does not allow update of empty String type cell > ------------------------------------------------------------------ > > Key: TEIID-4853 > URL: https://issues.jboss.org/browse/TEIID-4853 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: gs-update-empty-cell.log > > > Google translator allows to be inserted null value into column of type String, but subsequent update of any cell in such row throws exception "Spreadsheet translator error: String values cannot be set to null". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4855) Google translator behaves unexpectedly for multi value INSERT with null

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4855: -------------------------------------- Summary: Google translator behaves unexpectedly for multi value INSERT with null Key: TEIID-4855 URL: https://issues.jboss.org/browse/TEIID-4855 Project: Teiid Issue Type: Bug Affects Versions: 9.3, 8.12.10.6_3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Following query with multivalue insert generates unexpected results: * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) - row 1: Intkey = 1, Intnum and other columns are empty - row 2: Intkey = 2, Intnum and other columns have value set to 20 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4854: -------------------------------------- Summary: Google translator fails to update timestamp value reformatted after update Key: TEIID-4854 URL: https://issues.jboss.org/browse/TEIID-4854 Project: Teiid Issue Type: Bug Affects Versions: 9.3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Attachments: gs-reformatted-timestamp.log Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4853) Google translator does not allow update of empty String type cell

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4853: -------------------------------------- Summary: Google translator does not allow update of empty String type cell Key: TEIID-4853 URL: https://issues.jboss.org/browse/TEIID-4853 Project: Teiid Issue Type: Bug Affects Versions: 9.3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Attachments: gs-update-empty-cell.log Google translator allows to be inserted null value into column of type String, but subsequent update of any cell in such row throws exception "Spreadsheet translator error: String values cannot be set to null". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017