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

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@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;... 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; ...................... >