[ 
https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12763454#action_12763454
 ] 

Knut Anders Hatlen commented on DERBY-4188:
-------------------------------------------

Performing clean-up in a finally block may hide the root cause in case of a 
test failure. In this particular case, if enableXplainStyle() fails before 
xpltest.sysxplain_resultsets has been created, the finally clause will fail 
with "table not found" and we won't see the original exception. I think it 
would be better to drop the table outside the finally clause, even if it means 
that subsequent test cases may fail, since then at least the root cause is 
reported. Alternatively, and perhaps better, we could call JDBC.dropSchema(dmd, 
"XPLTEST") from tearDown().

> "XplainStatisticsTest" fails w/ 'The exception 'java.sql.SQLException: 
> 'RS_ID' is not a column in table or VTI 'XPLTEST.SYSXPLAIN_RESULTSETS'.' was 
> thrown while evaluating an expression.'
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4188
>                 URL: https://issues.apache.org/jira/browse/DERBY-4188
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.2.0
>         Environment: OS: Linux 2.6.22-14-generic #1 SMP Sun Oct 14 23:05:12 
> GMT 2007 GNU/Linux
> JVM:
> phoneME Advanced (CVM phoneme_advanced_mr2-b34)
>            Reporter: Ole Solberg
>            Assignee: Ole Solberg
>         Attachments: DERBY-4188_1.diff.txt
>
>
> phoneME Advanced (CVM phoneme_advanced_mr2-b34) / Linux 2.6.22-14-generic #1 
> SMP Sun Oct 14 23:05:12 GMT 2007 GNU/Linux (Ubuntu)
> fails with
> "The exception 'java.sql.SQLException: 'RS_ID' is not a column in table or 
> VTI 'XPLTEST.SYSXPLAIN_RESULTSETS'.' was thrown while evaluating an 
> expression."
> in
> org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest.
> See 
> http://dbtg.thresher.com/derby/test/Daily/javaME/testing/testlog/ubuntu/768718-suitesAll_diff.txt

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to