[DERBY-4889] Different byte to boolean conversion on embedded and client

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.7.1.1
• Component/s: JDBC
• Issue & fix info: Repro attached
• Bug behavior facts: Embedded/Client difference
• Assignee: Richard N. Hillegas
• Reporter: Knut Anders Hatlen
• Created: 06/Nov/10 01:06
• Updated: 29/Nov/10 14:21
• Resolved: 08/Nov/10 18:56

Description

The following code prints "true" with the embedded driver and "false" with the client driver:

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

If setByte() is replaced with setInt(), they both print "true".

Issue Links

• relates to: DERBY-4891 Enable testing of boolean type in ParameterMappingTest