Uploaded image for project: 'Teiid'
  1. Teiid
  2. 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)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.1.1
    • None
    • Integration Tests
    • 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< ......................
      >

      Attachments

        Activity

          People

            van.halbert Van Halbert (Inactive)
            wgibson_jira Warren Gibson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: