Derby
  1. Derby
  2. DERBY-5533

Client differs from embedded when rs.updateInt overflows: 22015 vs 22003

    Details

    • Bug behavior facts:
      Deviation from standard, Embedded/Client difference

      Description

      stm.executeUpdate("create table t(i smallint)");
      stm.executeUpdate("insert into t values 1,2,3,4");

      ResultSet rs = stm.executeQuery("select i from t");

      rs.next();

      try

      { rs.updateInt(1, 100000); }

      catch (SQLException e)

      { // client: 22015 vs embedded 22003 }

      According to the standard, 22015 should be used for INTERVALs ("interval field overflow"). 22003 seems more correct, the standard uses that for "numeric value out of range".

      1. derby-5533-repro.diff
        6 kB
        Dag H. Wanvik
      2. derby-5533-test.diff
        14 kB
        Dag H. Wanvik
      3. derby-5533.diff
        56 kB
        Dag H. Wanvik
      4. derby-5533.stat
        1 kB
        Dag H. Wanvik
      5. derby-5533b.diff
        63 kB
        Dag H. Wanvik
      6. derby-5533b.stat
        1 kB
        Dag H. Wanvik

        Issue Links

          Activity

          Dag H. Wanvik created issue -
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-5534 [ DERBY-5534 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-repro.diff [ 12507115 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-repro.diff [ 12507116 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-repro.diff [ 12507115 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-repro.diff [ 12507210 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-repro.diff [ 12507116 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533-test.diff [ 12507275 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-5536 [ DERBY-5536 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533.diff [ 12507450 ]
          Attachment derby-5533.stat [ 12507451 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Issue & fix info Patch Available [ 10102 ]
          Dag H. Wanvik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Dag H. Wanvik made changes -
          Attachment derby-5533b.diff [ 12507743 ]
          Attachment derby-5533b.stat [ 12507744 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-5546 [ DERBY-5546 ]
          Dag H. Wanvik made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Issue & fix info Patch Available [ 10102 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Dag H. Wanvik made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12645535 ] Default workflow, editable Closed status [ 12802322 ]
          Kathey Marsden made changes -
          Labels derby_backport_reject_10_8

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Dag H. Wanvik
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development