October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3310) Nesting aliases that match the engine recontext logic can lead to naming conflicts

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3310?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3310: --------------------------------------- Committed under: https://github.com/teiid/teiid/commit/91ab1efbd22cf7656d6fe0de1a7d0b54bdb... > Nesting aliases that match the engine recontext logic can lead to naming conflicts > ---------------------------------------------------------------------------------- > > Key: TEIID-3310 > URL: https://issues.jboss.org/browse/TEIID-3310 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > A query such as: > select (select e4 from pm1.g1 X__1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X__1, (select distinct e2, e3 from pm3.g1) X__2 where pm1.g1.e3 = X__1.e1 and pm1.g1.e2 = year(X__2.e3) > Will fail to process correctly as the X__1 and X__2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X__1.e1. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2883) Support Actian Analytics as a data source

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2883?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-2883: ------------------------------- Summary: Support Actian Analytics as a data source (was: Support ParAccel as a data source) > Support Actian Analytics as a data source > ----------------------------------------- > > Key: TEIID-2883 > URL: https://issues.jboss.org/browse/TEIID-2883 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Labels: alpha2 > Fix For: 8.12 > > > Support ParAccel as a data source -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3239) Cassandra: Update JAVA driver version to 2.1.3

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3239?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3239. --------------------------------- > Cassandra: Update JAVA driver version to 2.1.3 > ---------------------------------------------- > > Key: TEIID-3239 > URL: https://issues.jboss.org/browse/TEIID-3239 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Alpha2 > Fix For: 8.10 > > > Update to the latest version of Java driver for cassandra -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3205) Push down supported select expression even if other select expressions are not supported by the source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3205?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3205. --------------------------------- > Push down supported select expression even if other select expressions are not supported by the source > ------------------------------------------------------------------------------------------------------ > > Key: TEIID-3205 > URL: https://issues.jboss.org/browse/TEIID-3205 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Sanjeev Gour > Assignee: Steven Hawkins > Fix For: 8.10 > > > If the source supports for example the searched case expression and does not support a custom function, having both in the select caused searched case expression not to be pushed. More details are here- > https://developer.jboss.org/message/909439#909439 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1170) Support subqueries in temp table update/delete criteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1170?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1170. --------------------------------- > Support subqueries in temp table update/delete criteria > ------------------------------------------------------- > > Key: TEIID-1170 > URL: https://issues.jboss.org/browse/TEIID-1170 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.10 > > > Subqueries are currently not supported in temp table update/delete criteria. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2850) Add options to support sql server variant type

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2850?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2850. --------------------------------- > Add options to support sql server variant type > ---------------------------------------------- > > Key: TEIID-2850 > URL: https://issues.jboss.org/browse/TEIID-2850 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Due to a SQL Server driver issue, a variant column cannot be directly retrieved (it needs to be confirmed if this works with JTDS). A valid workaround is a native-query extension with an appropriate cast. > Beyond that we could: > - add an option for the translator to automatically convert to a string value > - allow for converts from object to be pushed down. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2821) Getting invalid Query against Postgres DB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2821?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2821. --------------------------------- > Getting invalid Query against Postgres DB > ----------------------------------------- > > Key: TEIID-2821 > URL: https://issues.jboss.org/browse/TEIID-2821 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 7.7 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.10 > > > Issuing the following query when postgres datasource is the target: > SELECT SUM(TBALANCE) FROM TELLERS JOIN BRANCHES ON BRANCHES.BID=TELLERS.BID GROUP BY TELLERS.BID ORDER BY TELLERS.BID > (which works when run directly against postgres) > And getting the following exception from Teiid: > Caused by: org.teiid.core.TeiidProcessingException: TEIID30088 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30088 Unrelated order by column TELLERS.BID cannot be used in a SET query, with SELECT DISTINCT, or GROUP BY > at org.teiid.query.resolver.util.ResolverUtil.resolveOrderBy(ResolverUtil.java:422) > at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:94) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:270) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) > at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:370) > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:722) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3258) Add support for quoted identifiers in set/show

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3258?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3258. --------------------------------- > Add support for quoted identifiers in set/show > ---------------------------------------------- > > Key: TEIID-3258 > URL: https://issues.jboss.org/browse/TEIID-3258 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The set / show statements assume that only non-qualified identifiers will be used. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2976) Using new database logging extension, getting error that indicates column isn't long enough

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2976?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2976. --------------------------------- > Using new database logging extension, getting error that indicates column isn't long enough > ------------------------------------------------------------------------------------------- > > Key: TEIID-2976 > URL: https://issues.jboss.org/browse/TEIID-2976 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.7.1 > > > Getting the following sporadically: > 11:57:57,538 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-2-thread-1) Value too long for column "TRANSACTIONID VARCHAR(50)": "'TransactionImple < ac, BasicAction: 0:ffffc0a80102:307704ce:5388aa39:169 status: ActionStatus.RUNNING >' (103)"; SQL statement: > insert into commandlog (id, applicationname, executionid, modelname, plan, principal, requestid, rowcount, sessionid, sourcecommand, sourcerequestid, sqlcmd, eventtype, logtime, transactionid, translatorname, vdbname, vdbversion) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-168] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3059) Support consuming SOAP based service that is secured by Kerberos authentication

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3059?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3059. --------------------------------- > Support consuming SOAP based service that is secured by Kerberos authentication > ------------------------------------------------------------------------------- > > Key: TEIID-3059 > URL: https://issues.jboss.org/browse/TEIID-3059 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR2, ER4 > Fix For: 8.7.1, 8.9 > > > CXF supports Kerberos based authentication in issuing a SOAP based web service call. This needs to be verified authentication scenario and further enhance code to support delegation of kerberos token. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015