June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4199) Redshift fails locate pushdown

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4199?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4199: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1296599|https://bugzilla.redhat.com/show_bug.cgi?id=1296599] from ON_QA to VERIFIED > Redshift fails locate pushdown > ------------------------------ > > Key: TEIID-4199 > URL: https://issues.jboss.… [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3888?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3888: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1296599|https://bugzilla.redhat.com/show_bug.cgi?id=1296599] from ON_QA to VERIFIED > Redshift - there is not function SUBSTR (RS uses SUBSTRING) > ----------------------------------------------------------- > > Key: … [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3815) Oracle translator - OFFSET function does not work

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3815?page=com.atlassian.jira.plugin... ] Juraj Duráni reopened TEIID-3815: --------------------------------- The Teiid still returns no row. >From the log: {code:plain} 15:19:50,124 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78) VAmB/CPZtJOo.12.0.13 Processing NEW request: SELECT g_0.INTKEY AS c_0 FROM Source.SMALLA AS g_0 ORDER BY c_0 OFFSET 45 ROWS 15:19:50,125 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78) VAmB/CPZtJOo.… [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3815) Oracle translator - OFFSET function does not work

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3815?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3815: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1279460|https://bugzilla.redhat.com/show_bug.cgi?id=1279460] from ON_QA to ASSIGNED > Oracle translator - OFFSET function does not work > ------------------------------------------------- > > Key: TEIID-3815 > … [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3776) Teiid throws NPE if query contains AVG function on varchar type

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3776?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3776: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272975|https://bugzilla.redhat.com/show_bug.cgi?id=1272975] from ON_QA to VERIFIED > Teiid throws NPE if query contains AVG function on varchar type > --------------------------------------------------------------- > > … [View More]Key: TEIID-3776 > URL: https://issues.jboss.org/browse/TEIID-3776 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Execution of this query ends with NPE in Teiid: > SELECT stringnum FROM bqt1.smalla GROUP BY stringnum HAVING avg(stringnum) = '1' > Expected result: > Exception similar to - org.teiid.api.exception.query.QueryValidatorException: TEIID30492 The aggregate function AVG cannot be used with non-numeric expressions: AVG(BQT1.SmallA.StringNum) > Actual result: > {code:text} > 12:27:32,829 DEBUG [org.teiid.TRANSPORT] (New I/O worker #7) processing message:MessageHolder: key=619 contents=Invoke interface org.teiid.client.DQP.executeRequest > 12:27:32,830 DEBUG [org.teiid.PROCESSOR] (Worker52_QueryProcessorQueue378) Request Thread r77C2X0C5Gwa.10 with state NEW > 12:27:32,830 DEBUG [org.teiid.PROCESSOR] (Worker52_QueryProcessorQueue378) r77C2X0C5Gwa.10 Non-cachable command. > 12:27:32,830 DEBUG [org.teiid.PROCESSOR] (Worker52_QueryProcessorQueue378) r77C2X0C5Gwa.10 executing SELECT stringnum FROM bqt1.smalla GROUP BY stringnum HAVING avg(stringnum) = '1' > 12:27:32,831 ERROR [org.teiid.PROCESSOR] (Worker52_QueryProcessorQueue378) TEIID30019 Unexpected exception for request r77C2X0C5Gwa.10: java.lang.NullPointerException > at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:767) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:248) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:126) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:197) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:126) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:214) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:271) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:369) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40] > 12:27:32,832 DEBUG [org.teiid.PROCESSOR] (Worker52_QueryProcessorQueue378) java.lang.NullPointerException Sending error to client r77C2X0C5Gwa.10 > 12:27:32,833 DEBUG [org.teiid.TRANSPORT] (Worker52_QueryProcessorQueue378) send message: MessageHolder: key=619 contents=ResultsMessage rowCount=0 finalRow=-1 > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026) [View Less]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3600) DB2 - error getting substring if "from position" is out of range

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3600?page=com.atlassian.jira.plugin... ] Juraj Duráni reopened TEIID-3600: --------------------------------- The query is still failing. I can see condition in the source-specific command like follows: {code:sql} CASE WHEN 40 > length(varchar(g_0.TIMESTAMPVALUE)) THEN (length(varchar(g_0.TIMESTAMPVALUE)) + 1) {code} I believe that this is wrong as *(length(varchar(g_0.TIMESTAMPVALUE)) + 1)* is obviously greater than *length(varchar(g_0.… [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3600) DB2 - error getting substring if "from position" is out of range

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3600?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3600: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1248489|https://bugzilla.redhat.com/show_bug.cgi?id=1248489] from ON_QA to NEW > DB2 - error getting substring if "from position" is out of range > ---------------------------------------------------------------- > > … [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4002?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4002: ------------------------------------------------ Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1312196|https://bugzilla.redhat.com/show_bug.cgi?id=1312196] from ON_QA to ASSIGNED > Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema > --------------------------------… [View More]

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4090) Issue with entitysets/properties ending in auth or token

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4090?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4090: ------------------------------------- Trying trace back the reason for those checks is explained here http://stackoverflow.com/questions/3125296/can-i-exclude-some-concrete-ur... but, in that case you are correct that, OData layer will not accept "static" named VDB, or when using the "OAuth" based war, it will not allow "static" or "keycloak" named VDBs. I can not seem to … [View More]

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4106) Rename and align infinispan translators/resource-adapters for their purpose

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4106?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-4106. -------------------------------- Release Notes Text: Resolving the alignment, for any additional issues a new jira can be logged. Resolution: Done > Rename and align infinispan translators/resource-adapters for their purpose > ---------------------------------------------------------------------------- > > Key: TEIID-4106 > … [View More]

8 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016