[teiid-issues] [JBoss JIRA] Work started: (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)
Van Halbert (JIRA)
jira-events at lists.jboss.org
Wed Sep 22 17:06:28 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TEIID-1168 started by Van Halbert.
> 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 at 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
More information about the teiid-issues
mailing list