[DERBY-5063] Embedded driver allows updateBytes() on BOOLEAN column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.8.1.2
• Component/s: JDBC
• Issue & fix info: Repro attached
• Bug behavior facts: Embedded/Client difference
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 20/Feb/11 20:58
• Updated: 30/Jun/11 09:21
• Resolved: 22/Feb/11 10:27

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.

Issue Links

• relates to: DERBY-5058 Add support for "boolean" data type in UpdatableResultSetTest