October 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1283) Race condition results in bad resultset for query on union

by Howard Abrams (JIRA)

Race condition results in bad resultset for query on union ---------------------------------------------------------- Key: TEIID-1283 URL: https://jira.jboss.org/browse/TEIID-1283 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Environment: MaxOS 10.6.4, JBoss 5.1.0 Reporter: Howard Abrams Assignee: Steven Hawkins Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS in this case) Take a view, call it 'B', backed by a file connector >From JDBC, make the query: Select * from (select * from A union select * from B) where foo='bar'. where 'bar' is only found in B, not A. Execute the query get back a resultset: ResultSet r = statement.executeQuery(); but this code will fail with a "resultset cursor is after the last row" if ( r.next ) String foo = r.getString(1); but this code will work correctly: Thread.sleep(1000); if ( r.next ) String foo = r.getString(1); Putting the union in a materialized view also works. -- 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

13 years, 12 months

2
8
0 / 0

[JBoss JIRA] Created: (TEIID-1237) Stored procedures should allow for better use of inout/out/return values

by Steven Hawkins (JIRA)

Stored procedures should allow for better use of inout/out/return values ------------------------------------------------------------------------ Key: TEIID-1237 URL: https://jira.jboss.org/browse/TEIID-1237 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.2 Teiid stored procedure command or assignment statements do not typically make use of inout/out/return values (the exception is if a resultset is not returned). It would be better to allow variables to be used in inout/out positions to capture the out values. e.g. instead of call proc(1) just implicitly creating the result set to return, a = call proc(1, b) would also assign the return value to a and would set an out value to b. -- 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

13 years, 12 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-1171) Add support for the with clause

by Steve Hawkins (JIRA)

Add support for the with clause ------------------------------- Key: TEIID-1171 URL: https://jira.jboss.org/browse/TEIID-1171 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.2 The with clause would be a useful feature to take advantage of common sub expressions. -- 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

13 years, 12 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1273) Add support of INSERT Statements

by julien reboul (JIRA)

Add support of INSERT Statements -------------------------------- Key: TEIID-1273 URL: https://jira.jboss.org/browse/TEIID-1273 Project: Teiid Issue Type: Feature Request Reporter: julien reboul Assignee: Steven Hawkins Please add support for INSERT statements inside a VDB. At least for the inderlying sources that can handle it (SQL Datasources for instance). -- 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

13 years, 12 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-1289) hasNext causes indexing issue

by Steven Hawkins (JIRA)

hasNext causes indexing issue ----------------------------- Key: TEIID-1289 URL: https://jira.jboss.org/browse/TEIID-1289 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1 Over a sequence of steps, a call to hasNext will casue the BatchIterator to not save it's state appropriately on a mark call. -- 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

13 years, 12 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1106) Create the ModeShape connector to be used with the ModeShape jdbc driver to access the ModeShape JCR repository

by Van Halbert (JIRA)

Create the ModeShape connector to be used with the ModeShape jdbc driver to access the ModeShape JCR repository --------------------------------------------------------------------------------------------------------------- Key: TEIID-1106 URL: https://jira.jboss.org/browse/TEIID-1106 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Van Halbert Assignee: Van Halbert -- 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

13 years, 12 months

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1168) Query Testing - CLOB, LOB, etc is returning an object reference in CTC rather than returning the content of the object (content is needed for validation purposes)

by Warren Gibson (JIRA)

Query Testing - CLOB, LOB, etc is returning an object reference in CTC rather than returning the content of the object (content is needed for validation purposes) ------------------------------------------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-1168 URL: https://jira.jboss.org/browse/TEIID-1168 Project: Teiid Issue Type: Bug Components: Integration Tests Reporter: Warren Gibson Assignee: Van Halbert Query testing is returning an object reference for CLOB, LOB, etc. In the past these were returned as a string. They should be converted to a string so the content can be validated. Examples: Query: SELECT * FROM XQTDoc.BQTDocTestDocument > > <actual_queryResults> > <select> > <dataElement type="xml">xml</dataElement> > </select> > <table rowCount="1" columnCount="1"> > <tableRow> > <tableCell> > <object>org.teiid.core.types.SQLXMLImpl@be76c7</object> > </tableCell> > </tableRow> > </table> > </actual_queryResults> > > > <expected_queryResults> > <select> > <dataElement type="xml">xml</dataElement> > </select> > <table rowCount="1" columnCount="1"> > <tableRow> > <tableCell> > <string><?xml version="1.0" encoding="UTF-8"?><xqt:BQTDocTest xmlns:xqt="http://www.metamatrix.com/XQTSchema"><SingleRow><IntKey>0</IntKey><StringKey>0</StringKey><IntNum/><StringNum>-24</StringNum><FloatNum>-24.0</FloatNum><LongNum>-24</LongNum><DoubleNum>-24.0</DoubleNum><ByteNum>-128</ByteNum><DateValue>2000-01-01</DateValue><TimeValue>00:00:00</TimeValue><TimestampValue>2000-01-01 00:00:00.0</TimestampValue><BooleanValue>false</BooleanValue><CharValue>1</CharValue><ShortValue>-32768</ShortValue><BigIntegerValue>-24</BigIntegerValue><BigDecimalValue>-24</BigDecimalValue><ObjectValue>-24</ObjectValue></SingleRow><SingleRow><IntKey>1</IntKey><StringKey>1</StringKey><IntNum>-23</IntNum><StringNum/><FloatNum>-23.0</FloatNum><LongNum>-23</LongNum><DoubleNum>-23.0</DoubleNum><ByteNum>-127</ByteNum><DateValue>2000-01-02</DateValue><TimeValue>01:00:00</TimeValue><TimestampValue>2000-01-01 00:00:01.0</TimestampValue><BooleanValue>true< ...................... > -- 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

13 years, 12 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-1333) Dynamic VDB can be set to ACTIVE, even when the data source is not available.

by Ramesh Reddy (JIRA)

Dynamic VDB can be set to ACTIVE, even when the data source is not available. ----------------------------------------------------------------------------- Key: TEIID-1333 URL: https://jira.jboss.org/browse/TEIID-1333 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.1.1 Attachments: interoperability-vdb.xml Dynamic VDB upon deployment is set to active, it was still missing the data source. -- 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

13 years, 12 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1091) Add remaining SQL/XML functions

by Steve Hawkins (JIRA)

Add remaining SQL/XML functions ------------------------------- Key: TEIID-1091 URL: https://jira.jboss.org/browse/TEIID-1091 Project: Teiid Issue Type: Sub-task Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 We should add the remaining functions, xmlparse, xmlserialize, xmlroot, etc. -- 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

14 years, 1 month

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1138) Add support to call binary web services

by Steve Hawkins (JIRA)

Add support to call binary web services --------------------------------------- Key: TEIID-1138 URL: https://jira.jboss.org/browse/TEIID-1138 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins We should add support to call http web services that return binary results. One problem is that JBoss WS does not support DataSource based calls. -- 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

14 years, 2 months

2
5
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2010