October 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1739) VDB deployment fails if metadata index file has been removed due to NPE during Index.initialize

by Larry O'Leary (JIRA)

VDB deployment fails if metadata index file has been removed due to NPE during Index.initialize ----------------------------------------------------------------------------------------------- Key: TEIID-1739 URL: https://issues.jboss.org/browse/TEIID-1739 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.5 Reporter: Larry O'Leary Assignee: Steven Hawkins VDB couldn't be deployed, so customer restarted SOA-P server and the server.log shows: DEPLOYMENTS MISSING DEPENDENCIES: Deployment "VDBDeployer" is missing the following dependencies: Dependency "SystemVDBDeployer" (should be in state "Create", but is actually in state "**ERROR**") DEPLOYMENTS IN ERROR: Deployment "SystemVDBDeployer" is in error due to the following reason(s): java.lang.NullPointerException, **ERROR** ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=SystemVDBDeployer state=Create java.lang.NullPointerException at org.teiid.internal.core.index.BlocksIndexInput.close(BlocksIndexInput.java:65) at org.teiid.internal.core.index.Index.initialize(Index.java:222) at org.teiid.internal.core.index.Index.<init>(Index.java:82) at org.teiid.metadata.index.IndexMetadataFactory.getMetadataStore(IndexMetadataFactory.java:119) at org.teiid.deployers.SystemVDBDeployer.start(SystemVDBDeployer.java:48) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) Although we do not yet know what has caused this situation, the NPE is a direct result of a bug in the way the index initialization is performed. In the event the file can not be read, we should simply remove the index entry but we don't get this far because when the file fails to be opened, we attempt to close it to ensure we cleanup our code. The problem is, the object was never initialized due to the file not being opened and therefore, we cause a NullPointerException: Specifically, org.teiid.internal.core.index.BlocksIndexInput.close(): if (raf != null) raf.close(); vraf.close(); should be something like: if (raf != null) raf.close(); if (vraf != null) vraf.close(); -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1693) Update Teiid ADmin Console Documentation

by Ted Jones (JIRA)

Update Teiid ADmin Console Documentation ---------------------------------------- Key: TEIID-1693 URL: https://issues.jboss.org/browse/TEIID-1693 Project: Teiid Issue Type: Task Components: Documentation Affects Versions: 7.4 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.4.1 The documentation needs to be brought up to date -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1701) Misc procedure enhancements

by Steven Hawkins (JIRA)

Misc procedure enhancements --------------------------- Key: TEIID-1701 URL: https://issues.jboss.org/browse/TEIID-1701 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Add support for compound/block statements (rather than only allowing them at the top level of loops/if), BEGIN [[NOT] ATOMIC] for block level transactions, loop/block labels, and the leave statement. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1602) Add support for like_regex and other regex functions

by Steven Hawkins (JIRA)

Add support for like_regex and other regex functions ---------------------------------------------------- Key: TEIID-1602 URL: https://issues.jboss.org/browse/TEIID-1602 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.5 Consider adding: like_regex substring_regex (as well as ANSI substring handling) position_regex this would somewhat obviate the need to add similar predicate handling although that should be added eventually as well. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1671) Need to add a place holder for the future deployment of Netezza

by Van Halbert (JIRA)

Need to add a place holder for the future deployment of Netezza --------------------------------------------------------------- Key: TEIID-1671 URL: https://issues.jboss.org/browse/TEIID-1671 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Ramesh Reddy Priority: Blocker Fix For: 7.4.1 Add a place holder in 7.4.x for the ability to slide in Netezza when it becomes available. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
3
0 / 0

[JBoss JIRA] (TEIID-1771) 7.3 or older clients see the wrong column metadata

by Steven Hawkins (Created) (JIRA)

7.3 or older clients see the wrong column metadata -------------------------------------------------- Key: TEIID-1771 URL: https://issues.jboss.org/browse/TEIID-1771 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 The fix for TEIID-1534 corrected column name vs. column label. However 7.3 clients use the column name and label interchangeably and typically uses column name. When running against 7.4 or later the column name needs to be reported as the label for legacy clients to work appropriately. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-1694) Add addition ansi sql function support

by Steven Hawkins (JIRA)

Add addition ansi sql function support -------------------------------------- Key: TEIID-1694 URL: https://issues.jboss.org/browse/TEIID-1694 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 7.5 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.5 Add parsing/support for: substring using from/for trim extract -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1560) Add support for user defined / pushdown aggregate functions

by Steven Hawkins (JIRA)

Add support for user defined / pushdown aggregate functions ----------------------------------------------------------- Key: TEIID-1560 URL: https://issues.jboss.org/browse/TEIID-1560 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 Add support for user defined aggregate functions. This would also affect the function model metadata. Our aggregate handling logic will need to be generalized to make this possible. Starting with the parser we've got special handling for built-in aggregates. for user defined aggregate handling just a static method will not work as the function needs to retain state across each group. Could require that the implementing class extends AggregateFunction. Could also allow user defined aggregates to take an order by clause. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1328) API request: Programatically modify the VDB

by Mark Addleman (JIRA)

API request: Programatically modify the VDB -------------------------------------------- Key: TEIID-1328 URL: https://jira.jboss.org/browse/TEIID-1328 Project: Teiid Issue Type: Feature Request Components: AdminApi Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor I'd like an API to programatically modify the VDB. It would be ideal to modify the VDB using DDL through Teiid. Our primary use case is accessing a dynamic set of datasources through Teiid. When a datasource is added, we would INSERT the appropriate entries into MODEL, PROPERTIES, DATASOURCES tables. Teiid would reread the appropriate metadata from the associated translators. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 10 months

6
35
0 / 0

[JBoss JIRA] Created: (TEIID-1326) API request: rewrite query/command before it reaches the teiid planner

by Mark Addleman (JIRA)

API request: rewrite query/command before it reaches the teiid planner ----------------------------------------------------------------------- Key: TEIID-1326 URL: https://jira.jboss.org/browse/TEIID-1326 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins I'd like an API to inspect and rewrite a user query/command before it reaches the Teiid planner. The use case is to rewrite the query/command to implement view-like capabilities. For example: SELECT a,b,c FROM table1 AS t WHERE t.a='xyz' would be rewritten as: SELECT a,b,c FROM (SELECT a,b,c FROM table2 UNION SELECT a,b,c FROM table3) AS t I imagine this API would be similar to the translator API: it would receive a data structure representing the query/command and use a visitor to rewrite the query. As a convenience, it would be nice to have something similar to the SQLConversionVisitor. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

6
19
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2011