Derby
  1. Derby
  2. DERBY-5063

Embedded driver allows updateBytes() on BOOLEAN column

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: 10.8.1.2
    • Component/s: JDBC
    • Labels:
      None
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Embedded/Client difference

      Description

      The following code inserts the value TRUE into the table T on the embedded driver:

      Statement s = c.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
      s.execute("create table t(b boolean)");
      ResultSet rs = s.executeQuery("select b from t");
      rs.moveToInsertRow();
      rs.updateBytes(1, "this is a test".getBytes());
      rs.insertRow();

      The client driver fails:

      java.sql.SQLException: An attempt was made to put a data value of type 'byte[]' into a data value of type 'BOOLEAN'.

      I believe the client driver is correct, and embedded should be changed to match it.

      1. derby-5063-1b.diff
        3 kB
        Knut Anders Hatlen
      2. derby-5063-1a.diff
        1 kB
        Knut Anders Hatlen

        Issue Links

          Activity

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development