[
https://issues.apache.org/jira/browse/DERBY-2994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravinder Reddy updated DERBY-2994:
----------------------------------
Component/s: Miscellaneous
Description:
In the context of following scenario
public void testRenameOpenCursoredTable() throws SQLException {
Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY ,
ResultSet.CONCUR_UPDATABLE);
assertUpdateCount(s , 0 , "create table t2(c21 int not null primary
key)");
assertUpdateCount(s , 1 , "insert into t2 values(21)");
assertUpdateCount(s , 1 , "insert into t2 values(22)");
ResultSet rs = s.executeQuery("select * from t2");
rs.next();
assertStatementError("X0X95" , s , "rename table t2 to fake");
}
I am expecting an open cursor and asserting the last Statement to throw an
Exception(with SQLState "X0X95") .But the cursor was not opened at the last
statement as the statement was executed successfully without any Exceptions.
Affects Version/s: 10.3.1.1
Fix Version/s: 10.3.1.1
> Open cursor is not functioning as expected when used with Rename Table
> -----------------------------------------------------------------------
>
> Key: DERBY-2994
> URL: https://issues.apache.org/jira/browse/DERBY-2994
> Project: Derby
> Issue Type: Bug
> Components: Miscellaneous
> Affects Versions: 10.3.1.1
> Reporter: Ravinder Reddy
> Fix For: 10.3.1.1
>
>
> In the context of following scenario
> public void testRenameOpenCursoredTable() throws SQLException {
> Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY ,
> ResultSet.CONCUR_UPDATABLE);
> assertUpdateCount(s , 0 , "create table t2(c21 int not null primary
> key)");
> assertUpdateCount(s , 1 , "insert into t2 values(21)");
> assertUpdateCount(s , 1 , "insert into t2 values(22)");
> ResultSet rs = s.executeQuery("select * from t2");
> rs.next();
> assertStatementError("X0X95" , s , "rename table t2 to fake");
> }
> I am expecting an open cursor and asserting the last Statement to throw
> an Exception(with SQLState "X0X95") .But the cursor was not opened at the
> last statement as the statement was executed successfully without any
> Exceptions.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
