From jira-events at lists.jboss.org Tue Jul 27 11:48:33 2010
Content-Type: multipart/mixed; boundary="===============1848546643551409721=="
MIME-Version: 1.0
From: Warren Gibson (JIRA) <jira-events at lists.jboss.org>
To: teiid-issues at lists.jboss.org
Subject: [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)
Date: Tue, 27 Jul 2010 11:48:33 -0400
Message-ID: <1290301149.5891.1280245713217.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>

--===============1848546643551409721==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Query Testing - CLOB, LOB, etc is returning an object reference in CTC rath=
er than returning the content of the object (content is needed for validati=
on 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=3D"xml">xml</dataElement>
>       </select>
>       <table rowCount=3D"1" columnCount=3D"1">
>         <tableRow>
>           <tableCell>
>             <object>org.teiid.core.types.SQLXMLImpl(a)be76c7</object>
>           </tableCell>
>         </tableRow>
>       </table>
>     </actual_queryResults>
>
>
>     <expected_queryResults>
>       <select>
>         <dataElement type=3D"xml">xml</dataElement>
>       </select>
>       <table rowCount=3D"1" columnCount=3D"1">
>         <tableRow>
>           <tableCell>
>             <string>&lt;?xml version=3D"1.0" encoding=3D"UTF-8"?&gt;&lt;x=
qt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"&gt;&lt;Sing=
leRow&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;Timestam=
pValue&gt;2000-01-01 00:00:00.0&lt;/TimestampValue&gt;&lt;BooleanValue&gt;f=
alse&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;-2=
4&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;TimeVal=
ue&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: htt=
ps://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       =



--===============1848546643551409721==--