December 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3638) Analytical Functions Push-down Optimization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3638?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3638. --------------------------------- > Analytical Functions Push-down Optimization > ------------------------------------------- > > Key: TEIID-3638 > URL: https://issues.jboss.org/browse/TEIID-3638 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.7.1 > Environment: RHEL 6, AWS VM, JBoss EAP (standalone) 6.3.2.GA > JBoss Data Virtualization 6.1.0.ER4 > Reporter: Jorge Herrera > Assignee: Steven Hawkins > > Enhancements and/or more documentation as to how Analytical functions work from JDV perspective. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2724) Suggestion for Cassandra: implement fallback plan if push-down CQL fails

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2724?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2724. --------------------------------- > Suggestion for Cassandra: implement fallback plan if push-down CQL fails > ------------------------------------------------------------------------- > > Key: TEIID-2724 > URL: https://issues.jboss.org/browse/TEIID-2724 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.6 > Environment: Teiid 8.6 with Cassandra > Reporter: Ivan Chan > Assignee: Steven Hawkins > Priority: Minor > Labels: teiid > > Sometimes push down sql doesn't work in Cassandra database because most of the time filtering only works on petition key or index column. For example, it won't be possible to apply "IN" clause on non-petition key column. Therefore, I suggest if push down sql fails to execute, I would like to see Teiid to the filtering using Teiid in-memory engine. Thanks. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4855?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4855. --------------------------------- > 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.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2304) Spreadsheet Integration tests/unit tests

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2304?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2304. --------------------------------- > Spreadsheet Integration tests/unit tests > ---------------------------------------- > > Key: TEIID-2304 > URL: https://issues.jboss.org/browse/TEIID-2304 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Filip Nguyen > Assignee: Filip Nguyen > > Identify/add more unit tests to the spreadsheet. > Run integration tests in separate profile probably with username/password supplied via java properties. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5049) CLOB instead of STRING

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5049?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-5049. --------------------------------- > CLOB instead of STRING > ---------------------- > > Key: TEIID-5049 > URL: https://issues.jboss.org/browse/TEIID-5049 > Project: Teiid > Issue Type: Bug > Reporter: Lukáš Svačina > Assignee: Steven Hawkins > > Postgresql translator should replace source's datatype `text` for `clob` instead of `string(4000)` by default. > In general teiid should be able to handle any input source without data corruption. So if source's column datatype doesn't fit into string(4000), it should use some kind of unlimited datatype e.g. `clob`. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5091) EdmPrimitiveTypeException in OData4 parse results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5091?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-5091. --------------------------------- > EdmPrimitiveTypeException in OData4 parse results > ------------------------------------------------- > > Key: TEIID-5091 > URL: https://issues.jboss.org/browse/TEIID-5091 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Affects Versions: 8.12.5 > Environment: * JDV 6.3 > Reporter: Kylin Soong > Assignee: Steven Hawkins > > Decimal type has risk if use odata4 to query data, I would use below example to show how to reproduce the errot: > h3. set up sample data in mysql > {code} > create table test(U_ID Decimal Primary Key); > insert into test values(11); > desc test; > +-------+---------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-------+---------------+------+-----+---------+-------+ > | U_ID | decimal(10,0) | NO | PRI | NULL | | > +-------+---------------+------+-----+---------+-------+ > {code} > h3. Deploy VDB > The VDB only contain one source model > {code} > <model name="TEST"> > <property name="importer.useFullSchemaName" value="false"/> > <source name="mysql-connector" translator-name="translator-mysql5" connection-jndi-name="java:/TEST_DS"/> > </model> > {code} > h3. Reproduce > Once the vdb deployed finished, the http://localhost:8080/odata4/TEST_VDB/TEST/test will return below error in web browswer > {code} > <error xmlns="http://docs.oasis-open.org/odata/ns/metadata"> > <code>null</code> > <message> > org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '11' does not match the facets' constraints. > </message> > </error> > {code} > The server log have a error like > {code} > 15:47:05,306 ERROR [org.teiid.ODATA] (http-0.0.0.0:8180-3) TEIID16050 Unable to process odata request due to: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '11' does not match the facets' constraints. with cause The value '11' does not match the facets' constraints.: org.apache.olingo.server.api.ODataApplicationException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '11' does not match the facets' constraints. > at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:174) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332) > 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:66) > at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > 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.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131] > Caused by: java.sql.SQLException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '11' does not match the facets' constraints. > at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:275) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.olingo.service.EntityCollectionResponse.isSameEntity(EntityCollectionResponse.java:151) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:280) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:349) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:172) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > ... 25 more > Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '11' does not match the facets' constraints. > at org.apache.olingo.commons.core.edm.primitivetype.EdmDecimal.internalValueToString(EdmDecimal.java:185) > at org.apache.olingo.commons.core.edm.primitivetype.AbstractPrimitiveType.valueToString(AbstractPrimitiveType.java:86) > at org.apache.olingo.server.core.responses.EntityResponse.buildLocation(EntityResponse.java:200) > at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:247) [teiid-olingo-8.12.5.redhat-8.jar:8.12.5.redhat-8] > ... 29 more > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4540) Make admin methods the same for ddl vdbs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4540?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4540. --------------------------------- > Make admin methods the same for ddl vdbs > ---------------------------------------- > > Key: TEIID-4540 > URL: https://issues.jboss.org/browse/TEIID-4540 > Project: Teiid > Issue Type: Sub-task > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > There are still admin methods that depend upon the VDBService/Runtime vdb, which is not available for the DDL vdbs. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4971?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4971. --------------------------------- > Infinispan Hotrod can't access remote instance > ---------------------------------------------- > > Key: TEIID-4971 > URL: https://issues.jboss.org/browse/TEIID-4971 > Project: Teiid > Issue Type: Bug > Components: Infinispan, 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.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4464) Support Salesforce Bulk API for updates and deletes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4464?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4464. --------------------------------- > Support Salesforce Bulk API for updates and deletes > --------------------------------------------------- > > Key: TEIID-4464 > URL: https://issues.jboss.org/browse/TEIID-4464 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Juraj Duráni > Priority: Minor > > Teiid currently supports insert (TEIID-2248) and select (TEIID-4284). It would be nice to have this support also for update and delete. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4849. --------------------------------- > Google translator behaves unexpectedly with Double in WHERE clause of SELECT > ---------------------------------------------------------------------------- > > Key: TEIID-4849 > URL: https://issues.jboss.org/browse/TEIID-4849 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Priority: Minor > > Query like "SELECT DoubleNum FROM SmallA WHERE DoubleNum > 5.0" gives unexpected results for following values in DoubleNum column: > * value like '15.1' is probably by google spreadsheet interpreted as date (in function row in sheet appears 15.1.2017), SELECT query returns no results > * value like '150.1': SELECT returns null -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 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 December 2017