[DERBY-4965] Boolean to char conversion results in integer

• 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: Release Note Needed, Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 11/Jan/11 10:28
• Updated: 29/May/12 08:52
• Resolved: 28/Feb/11 12:42

Description

Seen when running the Java EE CTS on Derby 10.7.1.1. The following code results in "1" being printed, whereas the expected result is "true":

PreparedStatement ps = c.prepareStatement("values cast(? as char(10))");
ps.setObject(1, Boolean.TRUE, Types.CHAR);
ResultSet rs = ps.executeQuery();
rs.next();
System.out.println(rs.getString(1));

Same seen when using VARCHAR or LONGVARCHAR instead of CHAR, and when using setBoolean() instead of setObject().

Issue Links

• is related to: DERBY-5788 BIT support regression and confusing message in 10.8.2.2: org.apache.derby.client.am.SqlException: Invalid character string format for type BOOLEAN