Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2994

Open cursor is not functioning as expected when used with Rename Table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • 10.3.1.4
    • 10.3.1.4
    • Miscellaneous
    • None

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            pandiri Ravinder Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: