[DERBY-4613] Make client driver treat BOOLEAN columns the same way as the embedded driver does.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.7.1.1
• Component/s: SQL
• Issue & fix info: Patch Available
• Bug behavior facts: Embedded/Client difference, Seen in production, Wrong query result
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 12/Apr/10 18:14
• Updated: 29/Nov/10 14:22
• Resolved: 12/May/10 12:18

Description

The only operation currently allowed on BOOLEAN columns is to select them from the system tables. For instance, the following query selects BOOLEAN values:

select systemalias from sys.sysaliases;

There are discrepancies in how the embedded and client drivers handle these BOOLEAN columns. The embedded behavior is correct and the client behavior should conform. I will attach a spec describing what needs to be done.

Issue Links

• is part of: DERBY-499 Expose BOOLEAN datatype to end users