December 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3874) Invalid source query for subquery referencing a common table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3874?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3874: ---------------------------------- Summary: Invalid source query for subquery referencing a common table (was: TeiidProcessingException using With Clause in limited scenarios (see description)) > Invalid source query for subquery referencing a common table > ------------------------------------------------------------ > > Key: TEIID-3874 > URL: https://issues.jboss.org/browse/TEIID-3874 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.2.6_2, 8.12.3 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > Attachments: withclause.tar.gz > > > TeiidProcessingException when using a With Clause requiring semi-join optimization and having a cross-source with clause subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3874) Invalid source query for subquery referencing a common table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3874?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3874. ----------------------------------- Fix Version/s: 8.13 8.12.4 Resolution: Done Updated the with clause assignment to look into nested plans created by rule merge virtual or other optimizations. > Invalid source query for subquery referencing a common table > ------------------------------------------------------------ > > Key: TEIID-3874 > URL: https://issues.jboss.org/browse/TEIID-3874 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.2.6_2, 8.12.3 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > Attachments: withclause.tar.gz > > > TeiidProcessingException when using a With Clause requiring semi-join optimization and having a cross-source with clause subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3874) TeiidProcessingException using With Clause in limited scenarios (see description)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3874?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3874: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1292490 Bugzilla Update: Perform > TeiidProcessingException using With Clause in limited scenarios (see description) > --------------------------------------------------------------------------------- > > Key: TEIID-3874 > URL: https://issues.jboss.org/browse/TEIID-3874 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.2.6_2, 8.12.3 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Attachments: withclause.tar.gz > > > TeiidProcessingException when using a With Clause requiring semi-join optimization and having a cross-source with clause subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3874) TeiidProcessingException using With Clause in limited scenarios (see description)

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-3874: ------------------------------------ Summary: TeiidProcessingException using With Clause in limited scenarios (see description) Key: TEIID-3874 URL: https://issues.jboss.org/browse/TEIID-3874 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.3, 8.7.2.6_2 Reporter: Johnathon Lee Assignee: Steven Hawkins Attachments: withclause.tar.gz TeiidProcessingException when using a With Clause requiring semi-join optimization and having a cross-source with clause subquery. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3872) Oracle Sequence error: Cannot infer EdmType for java type: oracle.sql.ROWID

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3872?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3872: --------------------------------------- So there are two issues here. The first is that we need other handling options for RowId. The second and probably more important here is that we cannot rely on the existing autogenerated keys logic for odata. Likely you are expecting the sequence value here and not the raw rowid correct? > Oracle Sequence error: Cannot infer EdmType for java type: oracle.sql.ROWID > --------------------------------------------------------------------------- > > Key: TEIID-3872 > URL: https://issues.jboss.org/browse/TEIID-3872 > Project: Teiid > Issue Type: Bug > Environment: MacOS X El Capitan, Teiid 8.12.2, Jbossdev studio, Oracle 11g > Reporter: Ivan Lucas Vargas > Assignee: Steven Hawkins > > Forum thread: https://developer.jboss.org/message/947527 > When trying to insert a record thru odata2 request when the ID field is mapped as an Oracle Sequence as described in the documentation as *<element name>:SEQUENCE=<sequence name>.<sequence value> *(https://docs.jboss.org/author/display/teiid812final/Oracle+Translator), the following error occurs: > TEIID16013 Error occurred producing OData result.: java.lang.IllegalArgumentException: Cannot infer EdmType for java type: oracle.sql.ROWID > at org.odata4j.core.OProperties.simple(OProperties.java:40) [odata-core-0.8.10.jar:0.8.10] > at org.teiid.odata.ODataSQLBuilder.buildEntityKey(ODataSQLBuilder.java:678) [classes:] > at org.teiid.odata.TeiidProducer.createEntity(TeiidProducer.java:232) [classes:] > at org.odata4j.producer.resources.EntitiesRequestResource.createEntity(EntitiesRequestResource.java:129) [odata-core-0.8.10.jar:0.8.10] > at org.odata4j.producer.resources.EntitiesRequestResource.createEntity(EntitiesRequestResource.java:116) [odata-core-0.8.10.jar:0.8.10] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_45] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_45] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_45] > at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_45] > at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:118) [classes:] > at org.teiid.odata.ODataServlet.service(ODataServlet.java:65) [classes:] > at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.9.Final-redhat-7.jar:] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.0.Final-redhat-15.jar:7.5.0.Final-redhat-15] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.3.Final.jar:7.5.3.Final] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_45] > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3873) Need 8.x Release PDF documentation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3873?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3873. ----------------------------------- Resolution: Won't Fix When we move out of confluence for documentation we'll reevaluate whether to kit the docs. > Need 8.x Release PDF documentation > ---------------------------------- > > Key: TEIID-3873 > URL: https://issues.jboss.org/browse/TEIID-3873 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Surendhar T > Assignee: Steven Hawkins > Priority: Blocker > Labels: release_notes > > Need 8.x Release PDF documentation > Reference Guide > Developer's Guide > Client Developer's Guide > Admin Guide > Caching Guide > Quick Start > Security Guide > API Docs -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3870) Add ability to properly qualify package objects

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3870?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3870: ---------------------------------- Component/s: JDBC Connector > Add ability to properly qualify package objects > ----------------------------------------------- > > Key: TEIID-3870 > URL: https://issues.jboss.org/browse/TEIID-3870 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > Even if the catalog name pattern matches package names, there is no option or recognition that contained procedures should be qualified as <package / catalog>.<name>. > We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages that are used as catalog names in the DatabaseMetaData. When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3870) Add ability to properly qualify package objects

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3870?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3870. ----------------------------------- Fix Version/s: 8.13 Resolution: Done Updated the import logic to look for a catalog name, which for oracle will mean the package and to use appropriate runtime names and names in source. Also oracle and possibly other sources may not provide a name for stored procedure / function return parameters, so a default was added - this was noticed when importing a packaged stored function. > Add ability to properly qualify package objects > ----------------------------------------------- > > Key: TEIID-3870 > URL: https://issues.jboss.org/browse/TEIID-3870 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > Even if the catalog name pattern matches package names, there is no option or recognition that contained procedures should be qualified as <package / catalog>.<name>. > We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages that are used as catalog names in the DatabaseMetaData. When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3873) Need 8.x Release PDF documentation

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3873?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3873: ------------------------------------- You can use export functionality of the confluence https://docs.jboss.org/author/display/teiid812final/Home go to tools, export to pdf As a project we choose not to provide them in the kit. > Need 8.x Release PDF documentation > ---------------------------------- > > Key: TEIID-3873 > URL: https://issues.jboss.org/browse/TEIID-3873 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Surendhar T > Assignee: Steven Hawkins > Priority: Blocker > Labels: release_notes > > Need 8.x Release PDF documentation > Reference Guide > Developer's Guide > Client Developer's Guide > Admin Guide > Caching Guide > Quick Start > Security Guide > API Docs -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3873) Need 8.x Release PDF documentation

by Surendhar T (JIRA)

Surendhar T created TEIID-3873: ---------------------------------- Summary: Need 8.x Release PDF documentation Key: TEIID-3873 URL: https://issues.jboss.org/browse/TEIID-3873 Project: Teiid Issue Type: Task Components: Documentation Reporter: Surendhar T Assignee: Steven Hawkins Priority: Blocker Need 8.x Release PDF documentation Reference Guide Developer's Guide Client Developer's Guide Admin Guide Caching Guide Quick Start Security Guide API Docs -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2015