October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2785) Designer needs a way to utilize pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2785?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2785. --------------------------------- > Designer needs a way to utilize pushdown functions > -------------------------------------------------- > > Key: TEIID-2785 > URL: https://issues.jboss.org/browse/TEIID-2785 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7 > > > Pushdown functions, such as the ones exposed by the ModeShapeExecutionFactory, should be available at design time. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2981) Add an OData query parameter that caches the resultset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2981?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2981. --------------------------------- > Add an OData query parameter that caches the resultset > ------------------------------------------------------ > > Key: TEIID-2981 > URL: https://issues.jboss.org/browse/TEIID-2981 > Project: Teiid > Issue Type: Feature Request > Components: OData > Affects Versions: 8.7 > Reporter: John Muller > Assignee: Steven Hawkins > Priority: Minor > Labels: Caching > Fix For: 8.8 > > > The Teiid caching guide indicates that the /*+ cache */ SQL hint is neccessary in order to cache results [1] . We would like two features added to the OData support: (1) to have a query parameter that basically injects the hint into the SQL statement run against the VDB and (2) a configuration setting that turns on OData resultset caching for all result sets smaller than some size (perhaps 256 as the default) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2960) Class cast exception with source batched update command

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2960?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2960. --------------------------------- > Class cast exception with source batched update command > ------------------------------------------------------- > > Key: TEIID-2960 > URL: https://issues.jboss.org/browse/TEIID-2960 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > A source batched update command will cause: > Caused by: java.lang.ClassCastException: org.teiid.query.sql.lang.BatchedUpdateCommand cannot be cast to org.teiid.query.sql.lang.ProcedureContainer > at org.teiid.dqp.internal.process.DataTierTupleSource.checkForUpdates(DataTierTupleSource.java:223) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:148 -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3018) Reflect view transformation sql into SYSTEM schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3018?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3018. --------------------------------- > Reflect view transformation sql into SYSTEM schema > -------------------------------------------------- > > Key: TEIID-3018 > URL: https://issues.jboss.org/browse/TEIID-3018 > Project: Teiid > Issue Type: Feature Request > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.8 > > > It would nice to reflect view transformation SQL in the SYSTEM schema > See https://community.jboss.org/message/879519?et=watches.email.thread#879519 for more detail -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2904) Expose "import" and "extension-metadata" Translator Properties through Admin API

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2904?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2904. --------------------------------- > Expose "import" and "extension-metadata" Translator Properties through Admin API > -------------------------------------------------------------------------------- > > Key: TEIID-2904 > URL: https://issues.jboss.org/browse/TEIID-2904 > Project: Teiid > Issue Type: Enhancement > Components: AdminApi > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.7 > > > Currently only "override" translator properties are exposed through Admin API. Teiid should also expose > * import properties > * extension metadata proeprties > for tooling purposes. Right now Teiid Connection importer in Designer, a user has to manually enter these values. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3162) Class files checked into Git

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3162?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3162. --------------------------------- > Class files checked into Git > ---------------------------- > > Key: TEIID-3162 > URL: https://issues.jboss.org/browse/TEIID-3162 > Project: Teiid > Issue Type: Bug > Components: Common > Reporter: Tom Arnold > Assignee: Steven Hawkins > Fix For: 8.9 > > > It looks like a large number of class files were accidentally checked into Git. This is generally considered bad practice. The files are in the salesforce-api and google-api modules. > Can verify using the Github file search. https://github.com/teiid/teiid/find/master (type ".class", not sure how to link to it). > Can do something like this to remove them: > {code} > find . -name '*.class' -exec git rm {} \; > {code} -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-994) Unable to execute Oracle pipelined table function as procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-994?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-994. -------------------------------- > Unable to execute Oracle pipelined table function as procedure > -------------------------------------------------------------- > > Key: TEIID-994 > URL: https://issues.jboss.org/browse/TEIID-994 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Oracle pipelined table functions (can be used in Oracle queries as TABLE(...)) that can be put in the FROM clause and used as if they were tables although they are really procedures. We found that we imported this table function, although didn't get it quite right - the result set was wrong, which may just be a deficiency of the JDBC import metadata. We were able to map the proc to a table and execute but when we did we got a PL/SQL error from the db. > Because this is a proc, we are executing it as a CallableStatement down in the JDBC connector which apparently does not work with DataDirect. I'm not sure how we can detect and do something different but seems like we need to have some metadata (procedure name in source?) that can tell us that this proc needs to be run differently and have the Oracle JDBC Connector deal with this properly. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

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

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2953) DB2: doesn't work with composite key

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2953?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2953. --------------------------------- > DB2: doesn't work with composite key > ------------------------------------- > > Key: TEIID-2953 > URL: https://issues.jboss.org/browse/TEIID-2953 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: DB2 with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > If I run a sql with composite key in DB2, Teiid translates it to something incorrect DB2 sql. > However, it works for postgres, mysql, and oracle. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3092) error with xml project minimization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3092?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3092. --------------------------------- > error with xml project minimization > ----------------------------------- > > Key: TEIID-3092 > URL: https://issues.jboss.org/browse/TEIID-3092 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > The project minimization logic will not look at the appropriate parent chain for each binding and can result in dropping columns that are used from the query which would be seen at runtime as a value not available from context exception. This became apparent with TEIID-3081 where the map order changed in different vms. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2014