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