Derby
  1. Derby
  2. DERBY-4890

Different string to boolean conversion on embedded and client

    Details

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

      Description

      The following code fragment behaves differently on client and embedded:

      PreparedStatement ps = c.prepareStatement("values cast(? as boolean)");
      ps.setString(1, "TRUE");
      ResultSet rs = ps.executeQuery();
      rs.next();
      System.out.println(rs.getBoolean(1));

      Embedded prints "true". Client raises an exception:

      Exception in thread "main" java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'BOOLEAN'.
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:72)
      at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358)
      at org.apache.derby.client.am.PreparedStatement.setString(PreparedStatement.java:884)
      at SetByte.main(SetByte.java:6)
      Caused by: org.apache.derby.client.am.SqlException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'BOOLEAN'.
      at org.apache.derby.client.am.PreparedStatement$PossibleTypes.throw22005Exception(PreparedStatement.java:3069)
      at org.apache.derby.client.am.PreparedStatement.setString(PreparedStatement.java:874)
      ... 1 more

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12526169 ] Default workflow, editable Closed status [ 12800492 ]
          Rick Hillegas made changes -
          Affects Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.7.1.0 [ 12314971 ]
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Attachment derby-4890-01-aa-setStringBoolean.diff [ 12459085 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-4891 [ DERBY-4891 ]
          Knut Anders Hatlen created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development