October 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2175) document and possibly provide a workaround for 32-bit dates

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2175: ------------------------------------- Summary: document and possibly provide a workaround for 32-bit dates Key: TEIID-2175 URL: https://issues.jboss.org/browse/TEIID-2175 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 To have a more compact format Teiid is using a 32-bit serialized date. This is consistent with the jdbc spec as it allows for dates between 1900 and the end of 9999. Years prior to and after that range are allowed in java, so we make it explicit that these values may get truncated. The workaround would be similar to the allow NAN property. -- 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

12 years, 1 month

1
2
0 / 0

[JBoss JIRA] (TEIID-2149) Change the applicability of subqueryUnnestDefault

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2149: ------------------------------------- Summary: Change the applicability of subqueryUnnestDefault Key: TEIID-2149 URL: https://issues.jboss.org/browse/TEIID-2149 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 subqueryUnnestDefault should only apply during rewrite, since it is run without cost analysis. However the unnest logic should always run in the optimizer and if necessary the user can use the NO_UNNEST hint to keep the subquery inline. -- 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

12 years, 1 month

1
2
0 / 0

[JBoss JIRA] (TEIID-2150) Allow procedures to be called with end defaultable inputs

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2150: ------------------------------------- Summary: Allow procedures to be called with end defaultable inputs Key: TEIID-2150 URL: https://issues.jboss.org/browse/TEIID-2150 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 We should allow procedures to be called positionally and use default values for end parameters if they are not specified. Condiser: create foreign procedure proc (x integer, y string); If you currently issue "call proc()", we'll assume named parameters and use "call proc(null, null)". If you issue "call proc(1)", you'll get an exception. The new behavior would be to use "call proc(1, null)". Of course something like "call proc('a')" would still result in an exception. -- 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

12 years, 1 month

1
2
0 / 0

[JBoss JIRA] (TEIID-2161) Timezone conversion of pre-Gregorian calendar cutover times fail

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2161: ------------------------------------- Summary: Timezone conversion of pre-Gregorian calendar cutover times fail Key: TEIID-2161 URL: https://issues.jboss.org/browse/TEIID-2161 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.2 Timezone conversion of pre-Gregorian calendar cutover times fail on converting any timestamps before the year 1583. By changing the value of the attribute "bot" to "1583-01-01T00:00:00", the query succeeds. This affects non-timezoned XMLTable values, the modifyTimeZone function, and Statement/ResultSet get/set timestamps with alternative calendars specified. -- 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

12 years, 1 month

1
4
0 / 0

[JBoss JIRA] (TEIID-2180) Limiting source tables in dynamic VDBs using importer.excludeTables

by Samier Nadji (JIRA)

Samier Nadji created TEIID-2180: ----------------------------------- Summary: Limiting source tables in dynamic VDBs using importer.excludeTables Key: TEIID-2180 URL: https://issues.jboss.org/browse/TEIID-2180 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Affects Versions: 8.1 Reporter: Samier Nadji Assignee: Steven Hawkins JDBCMetdataProcessor.getColumns() calls metadata.getColumns() for all the tables even the excluded ones. The while loop to process the columns is what takes a long time. Is it possible to change the code in JDBCMetdataProcessor.getColumns() to only get columns for the tables that are included in the tableMap? i.e. if an exclusion filter is specified, call metadata.getColumns() separately for each table. -- 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

12 years, 1 month

2
3
0 / 0

[JBoss JIRA] (TEIID-2155) Embedded kit is missing connector jars

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2155: ------------------------------------- Summary: Embedded kit is missing connector jars Key: TEIID-2155 URL: https://issues.jboss.org/browse/TEIID-2155 Project: Teiid Issue Type: Bug Components: Embedded Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 A late change to the embedded example switched to using the FileConnectionImpl, however the jar was not included. It makes sense in general though to allow the usage of our connector jars outside of a rar deployment, since that provides a convenient ConnectionFactory and familiar configuration options. -- 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

12 years, 1 month

2
5
0 / 0

[JBoss JIRA] (TEIID-2153) Allow LOBs to be accessable after the statement close in the local connection scenarios

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2153: ----------------------------------- Summary: Allow LOBs to be accessable after the statement close in the local connection scenarios Key: TEIID-2153 URL: https://issues.jboss.org/browse/TEIID-2153 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.0 Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 8.2 When a LOB returned the resultset, the contents of it are only accessed when resultset/statement and/or connection object is not closed, so that internal resources can be appropriately cleaned up. This can be relaxed in the local connection scenarios, as the data access is occurring in the same VM, by taking advantage of single read nature of SQL/XML to cleanup once the resource is read or closed. -- 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

12 years, 1 month

2
4
0 / 0

[JBoss JIRA] (TEIID-2148) Add enhancements to more efficiently handle large documents/files

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2148: ------------------------------------- Summary: Add enhancements to more efficiently handle large documents/files Key: TEIID-2148 URL: https://issues.jboss.org/browse/TEIID-2148 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The default strategy of Teiid is to copy the inputstream sent back from CXF (or anything returning a Source/DataSource). To reduce latency this copy should be performed during read, rather than all at once. Ideally we should investigate the CXF internals to see if we can get a handle to a temp file, which would completely eliminate the need for a copy. Alternatively or in addition to this approach, the ws translator should offer an option to return a single use SQL/XML value to the engine. -- 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

12 years, 1 month

1
3
0 / 0

[JBoss JIRA] (TEIID-2163) add support for binary xml serialization

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2163: ------------------------------------- Summary: add support for binary xml serialization Key: TEIID-2163 URL: https://issues.jboss.org/browse/TEIID-2163 Project: Teiid Issue Type: Sub-task Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 We should add the ability to serialize as blob/varbinary with a specified encoding. -- 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

12 years, 1 month

1
3
0 / 0

[JBoss JIRA] (TEIID-2118) XML encoding in Resteasy webservices

by Mónica L.A. (JIRA)

Mónica L.A. created TEIID-2118: ---------------------------------- Summary: XML encoding in Resteasy webservices Key: TEIID-2118 URL: https://issues.jboss.org/browse/TEIID-2118 Project: Teiid Issue Type: Bug Components: Common Affects Versions: 7.7 Environment: Windows 7 64 Reporter: Mónica L.A. Assignee: Steven Hawkins Publishing a result procedure in a REST Service generated by "Generate RestEasyWay" functionality an Error "lectura XML: mal formado" appears. Executing this procedure of this service in the designer there're no errors -- 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

12 years, 1 month

2
3
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2012