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"><...
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