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

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.3.1.4
    • Component/s: Miscellaneous
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: