[teiid-issues] [JBoss JIRA] Closed: (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)

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed 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)
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1168
>                 URL: https://issues.jboss.org/browse/TEIID-1168
>             Project: Teiid
>          Issue Type: Bug
>          Components: Integration Tests
>            Reporter: Warren Gibson
>            Assignee: Van Halbert
>             Fix For: 7.1.1
>
>
> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira