Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
Description
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< ......................
>