db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4188) "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.'
Date Thu, 08 Oct 2009 11:36:31 GMT

    [ 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.


Mime
View raw message