[teiid-issues] [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)

[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 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>&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;xqt:BQTDocTest xmlns:xqt="http://www.metamatrix.com/XQTSchema"&gt;&lt;SingleRow&gt;&lt;IntKey&gt;0&lt;/IntKey&gt;&lt;StringKey&gt;0&lt;/StringKey&gt;&lt;IntNum/&gt;&lt;StringNum&gt;-24&lt;/StringNum&gt;&lt;FloatNum&gt;-24.0&lt;/FloatNum&gt;&lt;LongNum&gt;-24&lt;/LongNum&gt;&lt;DoubleNum&gt;-24.0&lt;/DoubleNum&gt;&lt;ByteNum&gt;-128&lt;/ByteNum&gt;&lt;DateValue&gt;2000-01-01&lt;/DateValue&gt;&lt;TimeValue&gt;00:00:00&lt;/TimeValue&gt;&lt;TimestampValue&gt;2000-01-01 00:00:00.0&lt;/TimestampValue&gt;&lt;BooleanValue&gt;false&lt;/BooleanValue&gt;&lt;CharValue&gt;1&lt;/CharValue&gt;&lt;ShortValue&gt;-32768&lt;/ShortValue&gt;&lt;BigIntegerValue&gt;-24&lt;/BigIntegerValue&gt;&lt;BigDecimalValue&gt;-24&lt;/BigDecimalValue&gt;&lt;ObjectValue&gt;-24&lt;/ObjectValue&gt;&lt;/SingleRow&gt;&lt;SingleRow&gt;&lt;IntKey&gt;1&lt;/IntKey&gt;&lt;StringKey&gt;1&lt;/StringKey&gt;&lt;IntNum&gt;-23&lt;/IntNum&gt;&lt;StringNum/&gt;&lt;FloatNum&gt;-23.0&lt;/FloatNum&gt;&lt;LongNum&gt;-23&lt;/LongNum&gt;&lt;DoubleNum&gt;-23.0&lt;/DoubleNum&gt;&lt;ByteNum&gt;-127&lt;/ByteNum&gt;&lt;DateValue&gt;2000-01-02&lt;/DateValue&gt;&lt;TimeValue&gt;01:00:00&lt;/TimeValue&gt;&lt;TimestampValue&gt;2000-01-01 00:00:01.0&lt;/TimestampValue&gt;&lt;BooleanValue&gt;true&lt; ......................
>    



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