January 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2792) Must pushdown compensation does not account for translator pushdown functions

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2792: ------------------------------------- Summary: Must pushdown compensation does not account for translator pushdown functions Key: TEIID-2792 URL: https://issues.jboss.org/browse/TEIID-2792 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.7 A translator function does not have truly belong to any schema and results in an exception if we attempt to compensate for it: TEIID30019 Unexpected exception for request 10BpOpvKhXev.15: java.lang.NullPointerException at org.teiid.query.metadata.TempMetadataAdapter.isVirtualModel(TempMetadataAdapter.java:403) [teiid-engine-8.6.0.Final.jar:8.6.0.Final] at org.teiid.query.optimizer.relational.rules.CapabilitiesUtil.supports(CapabilitiesUtil.java:451) [teiid-engine-8.6.0.Final.jar:8.6.0.Final] at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluatePushdown(SubqueryAwareEvaluator.java:359) [teiid-engine-8.6.0.Final.jar:8.6.0.Final] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2791) refreshmatviewrow should support composite keys

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2791?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2791. ----------------------------------- Resolution: Done Added an additional vararg parameter to allow for backwards compatibility with metadata. > refreshmatviewrow should support composite keys > ----------------------------------------------- > > Key: TEIID-2791 > URL: https://issues.jboss.org/browse/TEIID-2791 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7 > > > The current refresh procedure only allows for simple primary keys. This should be extended to allow for more complex scenarios. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2781) Unable to update database table with composite keys using OData

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2781?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2781: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1044746|https://bugzilla.redhat.com/show_bug.cgi?id=1044746] from NEW to MODIFIED > Unable to update database table with composite keys using OData > --------------------------------------------------------------- > > Key: TEIID-2781 > URL: https://issues.jboss.org/browse/TEIID-2781 > Project: Teiid > Issue Type: Bug > Components: SOAP Services > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.7 > > Attachments: odataerror.txt, post-screen-shot.png, Shell00990083.tar > > > Using Postgres db, and created a table with composite keys. > CREATE TABLE composite_key > ( > ou_id character varying(3) NOT NULL, > product_name character varying(15) NOT NULL, > product_price numeric(10,2), > CONSTRAINT composite_key_pkey PRIMARY KEY (ou_id, product_name) > ) > WITH ( > OIDS=FALSE > ); > ALTER TABLE composite_key OWNER TO postgres; > INSERT INTO composite_key VALUES ('1','1',1); > INSERT INTO composite_key VALUES ('1','2',1.20); > INSERT INTO composite_key VALUES ('2','1',2.10); > Deploy the VDB and use SOAP UI to do PUT (aka SQL UPDATE) generates attached odataerror.txt -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2785) Update ModeShape jdbc translator to return the JCR procedures in the getMetadatda() call

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2785?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2785: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1045206 > Update ModeShape jdbc translator to return the JCR procedures in the getMetadatda() call > ---------------------------------------------------------------------------------------- > > Key: TEIID-2785 > URL: https://issues.jboss.org/browse/TEIID-2785 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7 > > > The ModeShapeExecutionFactory should expose the JCR procedures in the metadata when the getMetadata(..) is called. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2673) CNF exception when getting data through infinispan-cache translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2673?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2673: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1011502|https://bugzilla.redhat.com/show_bug.cgi?id=1011502] from ASSIGNED to MODIFIED > CNF exception when getting data through infinispan-cache translator > ------------------------------------------------------------------- > > Key: TEIID-2673 > URL: https://issues.jboss.org/browse/TEIID-2673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Labels: infinispan > Fix For: 8.4.1, 8.7 > > > When getting data through infinispan-cache translator using remote hot rod access, DV will throw "...ClassNotFoundException: org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory". > Workaround: > Add "<module name="org.infinispan.client.hotrod"/>" as a dependency into module "org.jboss.teiid". -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2673) CNF exception when getting data through infinispan-cache translator

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2673?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-2673. -------------------------------- Resolution: Done Updated the module > CNF exception when getting data through infinispan-cache translator > ------------------------------------------------------------------- > > Key: TEIID-2673 > URL: https://issues.jboss.org/browse/TEIID-2673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Labels: infinispan > Fix For: 8.4.1, 8.7 > > > When getting data through infinispan-cache translator using remote hot rod access, DV will throw "...ClassNotFoundException: org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory". > Workaround: > Add "<module name="org.infinispan.client.hotrod"/>" as a dependency into module "org.jboss.teiid". -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2664) Misc OData issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2664?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2664: ---------------------------------- Fix Version/s: 8.7 > Misc OData issues > ----------------- > > Key: TEIID-2664 > URL: https://issues.jboss.org/browse/TEIID-2664 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.3 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.5, 8.7 > > > Make TeiidProviderProducer's client connection a bounded concurrent map where entries can be expired on given cached time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2664) Misc OData issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2664?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2664. ----------------------------------- Resolution: Done > Misc OData issues > ----------------- > > Key: TEIID-2664 > URL: https://issues.jboss.org/browse/TEIID-2664 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.3 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.7, 8.5 > > > Make TeiidProviderProducer's client connection a bounded concurrent map where entries can be expired on given cached time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2664) Misc OData issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2664?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-2664: ----------------------------------- This was not forward merged from 8.5.x into 8.6. > Misc OData issues > ----------------- > > Key: TEIID-2664 > URL: https://issues.jboss.org/browse/TEIID-2664 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.3 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.5 > > > Make TeiidProviderProducer's client connection a bounded concurrent map where entries can be expired on given cached time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2779) Configurable CommonTableExpression support for DB2

by Andriy Rokhmanov (JIRA)

[ https://issues.jboss.org/browse/TEIID-2779?page=com.atlassian.jira.plugin... ] Andriy Rokhmanov commented on TEIID-2779: ----------------------------------------- We did additional research, seems DB2 for z/OS V9.1 in Conversion Mode does not support ORDER BY inside CTE either. Error message we are getting: "ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE. SQLCODE=-4700, SQLSTATE=56038, DRIVER=4.12.55" The approach proposed on 20/Dec/13 3:46 PM does not help either. This makes CTE approach for DB2 on z/OS a very difficult to keep for certain DB2 versions. > Configurable CommonTableExpression support for DB2 > -------------------------------------------------- > > Key: TEIID-2779 > URL: https://issues.jboss.org/browse/TEIID-2779 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Affects Versions: 8.5 > Reporter: Andriy Rokhmanov > Assignee: Steven Hawkins > Fix For: 8.7 > > > The LIMIT clause (FETCH FIRST...) inside CTE (WITH...) is not supported on pre-V9 versions of DB2 on z/OS, or new versions of DB2 running in Compatibility Mode. > The CTE support in DB2 translator should be configurable. > See more information: > https://community.jboss.org/thread/235503 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2014