db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Junjie Peng (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3801) Convert "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to junit.
Date Fri, 01 Aug 2008 15:34:31 GMT

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

Junjie Peng commented on DERBY-3801:
------------------------------------

Myrna , thanks for your verbose advices!
I'm still not so clear about:
1. For my code in testDropTableWithOpenHoldCursor() Line 227-231, 
                         try{
		dropTable("t1");
	    }catch (SQLException e) {
		assertSQLState("X0X95", e);
	    }
which is in embed mode,  when I want to drop a table with an open hold cursor, It should fail
with a SQLException "X0X95 ". I have expected it ,but in fact, it prompts ".ComparisonFailure:
Unexpected SQL state. ex 
pected:<42Y5...> but was:<X0X9...> ", why is it not ".ComparisonFailure: Unexpected
SQL state. expected:<X0X95...> but was:<******.> " ?
Furthermore, if I change the coed into
  try{
		dropTable("t1");
	    }catch (SQLException e) {
		assertSQLState("0000", e);
	    }
The exception message is still "ComparisonFailure: Unexpected SQL state. expected:<42Y5...>
but was:<X0X9...> ".  why is it not "ComparisonFailure: Unexpected SQL state. expected:<0000.>
but was:<******.> " ?
Is there something wrong with my code?

2. I have read through the four tools you mentioned. They are all good tools, but I feel puzzled,
if translating holdCursorIJ.sql use tools, will we  lose the junit view for this test on some
degree? 

Thank you!
Junjie


> Convert "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to junit.

> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-3801
>                 URL: https://issues.apache.org/jira/browse/DERBY-3801
>             Project: Derby
>          Issue Type: Test
>            Reporter: Junjie Peng
>            Assignee: Junjie Peng
>         Attachments: derby-3801-1-patch.txt
>
>
> Convert "org.apache.derbyTesting.functionTests.tests.lang.holdCursorIJ.sql" to junit.


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