From jira-events at lists.jboss.org Tue Jul 27 11:48:33 2010 Content-Type: multipart/mixed; boundary="===============6117731402297333413==" MIME-Version: 1.0 From: Warren Gibson (JIRA) 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> --===============6117731402297333413== 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 > > > > > > > org.teiid.core.types.SQLXMLImpl(a)be76c7 > > >
> > > > > > > > > <?xml version=3D"1.0" encoding=3D"UTF-8"?><x= qt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"><Sing= leRow><IntKey>0</IntKey><StringKey>0</StringKey>= <IntNum/><StringNum>-24</StringNum><FloatNum>-24.0&= lt;/FloatNum><LongNum>-24</LongNum><DoubleNum>-24.0<= ;/DoubleNum><ByteNum>-128</ByteNum><DateValue>2000-01-= 01</DateValue><TimeValue>00:00:00</TimeValue><Timestam= pValue>2000-01-01 00:00:00.0</TimestampValue><BooleanValue>f= alse</BooleanValue><CharValue>1</CharValue><ShortValue= >-32768</ShortValue><BigIntegerValue>-24</BigIntegerValue= ><BigDecimalValue>-24</BigDecimalValue><ObjectValue>-2= 4</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><TimeVal= ue>01:00:00</TimeValue><TimestampValue>2000-01-01 00:00:01.0= </TimestampValue><BooleanValue>true< ...................... > = -- = 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 = --===============6117731402297333413==-- From jira-events at lists.jboss.org Wed Sep 22 17:06:28 2010 Content-Type: multipart/mixed; boundary="===============0062626879089891764==" MIME-Version: 1.0 From: Van Halbert (JIRA) To: teiid-issues at lists.jboss.org Subject: [teiid-issues] [JBoss JIRA] Work started: (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: Wed, 22 Sep 2010 17:06:28 -0400 Message-ID: <746968834.17850.1285189588444.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1290301149.5891.1280245713217.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============0062626879089891764== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ https://jira.jboss.org/browse/TEIID-1168?page=3Dcom.atlassian.jira.p= lugin.system.issuetabpanels:all-tabpanel ] Work on TEIID-1168 started by Van Halbert. > 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://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 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 > > > > > > > >
> > > > > > org.teiid.core.types.SQLXMLImpl(a)be76c7 > > > > > >
> > > > > > > > > > > > > > > > > > <?xml version=3D"1.0" encoding=3D"UTF-8"?><= ;xqt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"><Si= ngleRow><IntKey>0</IntKey><StringKey>0</StringKey&g= t;<IntNum/><StringNum>-24</StringNum><FloatNum>-24.= 0</FloatNum><LongNum>-24</LongNum><DoubleNum>-24.0&= lt;/DoubleNum><ByteNum>-128</ByteNum><DateValue>2000-0= 1-01</DateValue><TimeValue>00:00:00</TimeValue><Timest= ampValue>2000-01-01 00:00:00.0</TimestampValue><BooleanValue>= ;false</BooleanValue><CharValue>1</CharValue><ShortVal= ue>-32768</ShortValue><BigIntegerValue>-24</BigIntegerVal= ue><BigDecimalValue>-24</BigDecimalValue><ObjectValue>= -24</ObjectValue></SingleRow><SingleRow><IntKey>1&l= t;/IntKey><StringKey>1</StringKey><IntNum>-23</IntN= um><StringNum/><FloatNum>-23.0</FloatNum><LongNum&g= t;-23</LongNum><DoubleNum>-23.0</DoubleNum><ByteNum>= ;-127</ByteNum><DateValue>2000-01-02</DateValue><TimeV= alue>01:00:00</TimeValue><TimestampValue>2000-01-01 00:00:01= .0</TimestampValue><BooleanValue>true< ...................... > > = -- = 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 = --===============0062626879089891764==-- From jira-events at lists.jboss.org Thu Sep 30 14:33:39 2010 Content-Type: multipart/mixed; boundary="===============7232072642030679437==" MIME-Version: 1.0 From: Van Halbert (JIRA) To: teiid-issues at lists.jboss.org Subject: [teiid-issues] [JBoss JIRA] Resolved: (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: Thu, 30 Sep 2010 14:33:39 -0400 Message-ID: <1029188425.5282.1285871619748.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com> In-Reply-To: 1290301149.5891.1280245713217.JavaMail.tomcat@jira02.app.mwc.hst.phx2.redhat.com --===============7232072642030679437== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ https://jira.jboss.org/browse/TEIID-1168?page=3Dcom.atlassian.jira.p= lugin.system.issuetabpanels:all-tabpanel ] Van Halbert resolved TEIID-1168. -------------------------------- Fix Version/s: 7.1.1 Resolution: Done Resolved this issue for testing. > 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://jira.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 > > > > > > > >
> > > > > > org.teiid.core.types.SQLXMLImpl(a)be76c7 > > > > > >
> > > > > > > > > > > > > > > > > > <?xml version=3D"1.0" encoding=3D"UTF-8"?><= ;xqt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"><Si= ngleRow><IntKey>0</IntKey><StringKey>0</StringKey&g= t;<IntNum/><StringNum>-24</StringNum><FloatNum>-24.= 0</FloatNum><LongNum>-24</LongNum><DoubleNum>-24.0&= lt;/DoubleNum><ByteNum>-128</ByteNum><DateValue>2000-0= 1-01</DateValue><TimeValue>00:00:00</TimeValue><Timest= ampValue>2000-01-01 00:00:00.0</TimestampValue><BooleanValue>= ;false</BooleanValue><CharValue>1</CharValue><ShortVal= ue>-32768</ShortValue><BigIntegerValue>-24</BigIntegerVal= ue><BigDecimalValue>-24</BigDecimalValue><ObjectValue>= -24</ObjectValue></SingleRow><SingleRow><IntKey>1&l= t;/IntKey><StringKey>1</StringKey><IntNum>-23</IntN= um><StringNum/><FloatNum>-23.0</FloatNum><LongNum&g= t;-23</LongNum><DoubleNum>-23.0</DoubleNum><ByteNum>= ;-127</ByteNum><DateValue>2000-01-02</DateValue><TimeV= alue>01:00:00</TimeValue><TimestampValue>2000-01-01 00:00:01= .0</TimestampValue><BooleanValue>true< ...................... > > = -- = 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 = --===============7232072642030679437==-- From jira-events at lists.jboss.org Mon Jan 10 17:32:49 2011 Content-Type: multipart/mixed; boundary="===============6716328514619564495==" MIME-Version: 1.0 From: Steven Hawkins (JIRA) 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 --===============6716328514619564495== 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 > > > > > > > >
> > > > > > org.teiid.core.types.SQLXMLImpl(a)be76c7 > > > > > >
> > > > > > > > > > > > > > > > > > <?xml version=3D"1.0" encoding=3D"UTF-8"?><= ;xqt:BQTDocTest xmlns:xqt=3D"http://www.metamatrix.com/XQTSchema"><Si= ngleRow><IntKey>0</IntKey><StringKey>0</StringKey&g= t;<IntNum/><StringNum>-24</StringNum><FloatNum>-24.= 0</FloatNum><LongNum>-24</LongNum><DoubleNum>-24.0&= lt;/DoubleNum><ByteNum>-128</ByteNum><DateValue>2000-0= 1-01</DateValue><TimeValue>00:00:00</TimeValue><Timest= ampValue>2000-01-01 00:00:00.0</TimestampValue><BooleanValue>= ;false</BooleanValue><CharValue>1</CharValue><ShortVal= ue>-32768</ShortValue><BigIntegerValue>-24</BigIntegerVal= ue><BigDecimalValue>-24</BigDecimalValue><ObjectValue>= -24</ObjectValue></SingleRow><SingleRow><IntKey>1&l= t;/IntKey><StringKey>1</StringKey><IntNum>-23</IntN= um><StringNum/><FloatNum>-23.0</FloatNum><LongNum&g= t;-23</LongNum><DoubleNum>-23.0</DoubleNum><ByteNum>= ;-127</ByteNum><DateValue>2000-01-02</DateValue><TimeV= alue>01:00:00</TimeValue><TimestampValue>2000-01-01 00:00:01= .0</TimestampValue><BooleanValue>true< ...................... > > = -- = This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira = --===============6716328514619564495==--