From jira-events at lists.jboss.org Mon Jan 10 17:32:49 2011
Content-Type: multipart/mixed; boundary="===============6886325736877515263=="
MIME-Version: 1.0
From: Steven Hawkins (JIRA) <jira-events at lists.jboss.org>
To: teiid-issues at lists.jboss.org
Subject: [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)
Date: Mon, 10 Jan 2011 17:32:49 -0500
Message-ID: <207624135.3428.1294698769650.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com>
In-Reply-To: 1290301149.5891.1280245713217.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com

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


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

Steven Hawkins closed TEIID-1168.
---------------------------------



> Query Testing - CLOB, LOB, etc is returning an object reference in CTC ra=
ther than returning the content of the object (content is needed for valida=
tion 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 th=
e 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=
;xqt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"&gt;&lt;Si=
ngleRow&gt;&lt;IntKey&gt;0&lt;/IntKey&gt;&lt;StringKey&gt;0&lt;/StringKey&g=
t;&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-0=
1-01&lt;/DateValue&gt;&lt;TimeValue&gt;00:00:00&lt;/TimeValue&gt;&lt;Timest=
ampValue&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;ShortVal=
ue&gt;-32768&lt;/ShortValue&gt;&lt;BigIntegerValue&gt;-24&lt;/BigIntegerVal=
ue&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&l=
t;/IntKey&gt;&lt;StringKey&gt;1&lt;/StringKey&gt;&lt;IntNum&gt;-23&lt;/IntN=
um&gt;&lt;StringNum/&gt;&lt;FloatNum&gt;-23.0&lt;/FloatNum&gt;&lt;LongNum&g=
t;-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;TimeV=
alue&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

       =



--===============6886325736877515263==--