[teiid-issues] [JBoss JIRA] Commented: (TEIID-1382) CTC test producing blank VQT errors but Squirrel does produce expected results

[Warren Gibson (JIRA)]

    [ https://jira.jboss.org/browse/TEIID-1382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12567959#comment-12567959 ] 

Warren Gibson commented on TEIID-1382:
--------------------------------------

The blank error files are also showing up in ModeShape testing.  Two (query 151 and 599) are showing up with blank error files.

> CTC test producing blank VQT errors but Squirrel does produce expected results 
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-1382
>                 URL: https://jira.jboss.org/browse/TEIID-1382
>             Project: Teiid
>          Issue Type: Bug
>          Components: Integration Tests
>            Reporter: Warren Gibson
>            Assignee: Van Halbert
>            Priority: Minor
>
> 4 vqt queries for DB2 97 are producting a blank XML error file.  
> Mapping S1001=SELECT * FROM VQT.Mapping1 ORDER BY IntKey
> Mapping S1002=SELECT VQT.Mapping1.* FROM VQT.Mapping1 ORDER BY IntKey
> Mapping S1003=SELECT * FROM VQT.Mapping1 AS X ORDER BY IntKey
> Mapping S1004=SELECT X.* FROM VQT.Mapping1 AS X ORDER BY IntKey
> An xml error file is being produced but it is completely blank.  It should be noted when I attempt to generate new test results they are also blank.  The summary text
> indicates the problem is related to Lob:
> 	 - Mapping1_Queries_Mapping1_S-1001~Unable to read data from the stream: java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
> 	 - Mapping1_Queries_Mapping1_S-1002~Unable to read data from the stream: java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
> 	 - Mapping1_Queries_Mapping1_S-1003~Unable to read data from the stream: java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
> 	 - Mapping1_Queries_Mapping1_S-1004~Unable to read data from the stream: java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
> When I run the 4 queries in Squirrel I get results and they seem to match the expected results so I think the queries are actually
> returning the proper results.  Therefore, I am marking this as a "Minor" problem.  It appears to be an issue with the query testing framework choking on Lob.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira