February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3571) Infinispan-dsl-cache translator: Comparison operators don't work for char column

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3571?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3571. ----------------------------------- Resolution: Done It looks like no fix is needed here. Is there a doc note needed somewhere to say that char is not a supported source type? > Infinispan-dsl-cache translator: Comparison operators don't work for char column > ---------------------------------------------------------------------------------- > > Key: TEIID-3571 > URL: https://issues.jboss.org/browse/TEIID-3571 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > Comparison operators returns wrong result for column of type Character. > Sample queries: > {code} > SELECT CharValue FROM SmallA WHERE SmallA.CharValue < '1' > SELECT CharValue FROM SmallA WHERE SmallA.CharValue = '1' > {code} > These queries return no row even though they should have returned more than 20 rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3512) produce a lighter weight embedded kit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3512?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3512. ----------------------------------- Resolution: Done Marking as done now that the examples utilize maven and no kit is being produced with the WildFly builds 8.13+ > produce a lighter weight embedded kit > ------------------------------------- > > Key: TEIID-3512 > URL: https://issues.jboss.org/browse/TEIID-3512 > Project: Teiid > Issue Type: Feature Request > Components: Embedded > Reporter: Steven Hawkins > Assignee: Kylin Soong > > The embedded kit should be a small as possible, and it should be clear/easy to get dependency sets for each optional piece of functionality. This could include using maven to pull artifacts. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3862: ---------------------------------- Component/s: Documentation Fix Version/s: 8.12.5 Summary: Documentation in kit for certain datasources missing (was: Documentation in WildFly kit for certain datasources missing) > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3938) EdmDate and EdmTimeOfDay output in local timezone

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3938?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3938: --------------------------------------- Could they bring in Joda time (or JRE 8)? Using LocalTime and LocalDate as the canonical mapping would clarify that the values are not instants / intended to carry time zone information. > EdmDate and EdmTimeOfDay output in local timezone > ------------------------------------------------- > > Key: TEIID-3938 > URL: https://issues.jboss.org/browse/TEIID-3938 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12.5 > > > EdmDate and EdmTimeOfDay both assume GMT for incoming string values - however when the convert from Java objects to string they use the local/default Calendar. So when Teiid is on a server not in GMT date and time value sent via the odata4 translator will likely be wrong. > Ramesh: > I have posted a question to the Olingo development group here http://markmail.org/search/list:org.apache.olingo.dev#query:list%3Aorg.ap... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in WildFly kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ Yes, I will. > Documentation in WildFly kit for certain datasources missing > ------------------------------------------------------------ > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Reporter: Ramesh Reddy > Assignee: Van Halbert > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in WildFly kit for certain datasources missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3862: --------------------------------------- These are missing from the jboss as 7 kit as well. Van do you want to add these for 8.12.x? > Documentation in WildFly kit for certain datasources missing > ------------------------------------------------------------ > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Reporter: Ramesh Reddy > Assignee: Van Halbert > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3782) OData V4: Support system options over the operation based collections

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3782?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3782: --------------------------------------- Do you want me to take this one? > OData V4: Support system options over the operation based collections > --------------------------------------------------------------------- > > Key: TEIID-3782 > URL: https://issues.jboss.org/browse/TEIID-3782 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.11 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.12.x > > > Currently the system options like $top, $skip, $filter are not supported on results returned from Functions/Actions. Per OData specification this should be supported. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3948) Provide a different mechanism to update odata wars

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3948: ------------------------------------- Summary: Provide a different mechanism to update odata wars Key: TEIID-3948 URL: https://issues.jboss.org/browse/TEIID-3948 Project: Teiid Issue Type: Quality Risk Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0, 8.12.x Directly modifying the wars under the base modules is a bad practice. We need to have users modify non-kit artifact files in a different location. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3684) RoleBasedCredentialMapIdentityLoginModule throws exception at startup time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3684?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3684: ---------------------------------- Fix Version/s: 9.0 8.12.x > RoleBasedCredentialMapIdentityLoginModule throws exception at startup time > -------------------------------------------------------------------------- > > Key: TEIID-3684 > URL: https://issues.jboss.org/browse/TEIID-3684 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.x > > > If a data source is configured to use RoleBasedCredentialMapIdentityLoginModule, then exception is thrown at startup \[1\], because default username and password are null. Please, add module options "username" and "password" to set up default user (similar functionality have e.g. CallerIdentityLoginModule and PassthroughIdentityLoginModule), so DV is able to properly load data source at startup when no user is authenticated and therefore no mapping could be performed. > Example configuration \[2\]. Note, there is no exception if UsersRoles login module is used instead of RealDirect. However, it means that EAP users are separate from DV users. > *FYI:* > - credentialMap module option should be defined as URL (file://...). It would be nice to have this information in the documentation. > - I tried to use unauthenticatedIdentity module option for RealmDirect, but same exception has been thrown with different root cause (realm 'ApplicationRealm' not found). I do not know why. > \[1\] > ERROR [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-5) Exception during createSubject()PBOX000016: Access denied: authentication failed: java.lang.SecurityException: PBOX000016: Access denied: authentication failed > at org.jboss.security.plugins.JBossSecuritySubjectFactory.createSubject(JBossSecuritySubjectFactory.java:84) > at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1084) > at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1079) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0_40] > at org.jboss.jca.deployers.common.AbstractDsDeployer.createSubject(AbstractDsDeployer.java:1078) > at org.jboss.jca.deployers.common.AbstractDsDeployer.deployDataSource(AbstractDsDeployer.java:600) > at org.jboss.jca.deployers.common.AbstractDsDeployer.createObjectsAndInjectValue(AbstractDsDeployer.java:282) > at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.deploy(AbstractDataSourceService.java:316) > at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:120) > at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) > 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] > \[2\] > {code:xml} > <security-domain name="my-sec"> > <authentication> > <login-module code="RealmDirect" flag="required"> > <module-option name="password-stacking" value="tryFirstPass"/> >  > </login-module> > <login-module code="org.teiid.jboss.RoleBasedCredentialMapIdentityLoginModule" module="org.jboss.teiid" flag="required"> > <module-option name="password-stacking" value="useFirstPass"/> > <module-option name="credentialMap" value="file://${jboss.server.config.dir}/teiid-credentialmap.properties"/> > </login-module> > </authentication> > </security-domain> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3878) java.lang.Integer cannot be cast to java.math.BigDecimal

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3878?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3878: ---------------------------------- Fix Version/s: 9.0 > java.lang.Integer cannot be cast to java.math.BigDecimal > -------------------------------------------------------- > > Key: TEIID-3878 > URL: https://issues.jboss.org/browse/TEIID-3878 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.11.3 > Reporter: Mark Tawk > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0 > > Attachments: TEIID-3878.sql > > > I'm using Teiid 8.11.3 with oracle translator. > I have an aggregated query using teiid materialized views with the following simplified criteria: > (CASE WHEN ( "table1"."field1" = 1 ) THEN "table2"."yearfield" ELSE null END IN (2014) ) > The above criteria is reproducing a ClassCastException Integer cannot be cast to BigDecimal > if I change the criteria to the following, it passes without a problem: > ("table2"."yearfield" IN (2014) ) > Here is the error stack: > java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal > at java.math.BigDecimal.compareTo(BigDecimal.java:219) > at org.teiid.query.sql.symbol.Constant$2.compare(Constant.java:99) > at org.teiid.query.eval.Evaluator.compare(Evaluator.java:581) > at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:322) > at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:236) > at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:225) > at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:219) > at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) > at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:460) > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) > at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) > at org.teiid.query.processor.relational.GroupingNode.groupSortPhase(GroupingNode.java:490) > at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:366) > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:148) > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) > at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:306) > at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:238) > at sun.reflect.GeneratedMethodAccessor260.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:175) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) > at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:173) > at com.sun.proxy.$Proxy31.executeRequest(Unknown Source) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:667) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:533) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1068) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:320) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016