You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ole Solberg (JIRA)" <ji...@apache.org> on 2009/04/27 09:29:30 UTC

[jira] Created: (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.'

"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: Regression Test Failure
    Affects Versions: 10.5.1.2
         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


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.

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

Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12763329#action_12763329 ] 

Bryan Pendleton commented on DERBY-4188:
----------------------------------------

Those changes look fine to me. Thanks for tracking this down, Ole!

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

[jira] Updated: (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.'

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4188:
-------------------------------

    Attachment: DERBY-4188_1.diff.txt

Some testcases in XplainStatisticsTest did not take into account that the order in which testcases could be run may differ. Specifically, phoneME runs testcases in the opposite order of other jvms we are running tests on.

XplainStatisticsTest now ran ok on phoneME and jvm1.6. 
Running suites.All now.

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

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

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
    [ 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.

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

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12763381#action_12763381 ] 

Ole Solberg commented on DERBY-4188:
------------------------------------

DERBY-4188_1.diff.txt committed to trunk as revision 823066.

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

[jira] Closed: (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.'

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg closed 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.'
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 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.

[jira] Resolved: (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.'

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg resolved DERBY-4188.
--------------------------------

    Resolution: Fixed

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

[jira] Updated: (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.'

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-4188:
---------------------------------

    Bug behavior facts: [Regression, Regression Test Failure]  (was: [Regression])

> "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.1.2
>         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
>
> 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.

[jira] Assigned: (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.'

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg reassigned DERBY-4188:
----------------------------------

    Assignee: Ole Solberg

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