[DERBY-984] BOOLEAN Type allows illegal casts and comparisons according to SQL Spec

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 15/Feb/06 14:54
• Updated: 17/Aug/07 22:38
• Resolved: 17/Aug/07 17:55

Description

The BOOLEAN type, implemented with DERBY-499, will allow illegal casts and comparisons. Issues surrounding this have also been discussed in DERBY-887.

The casts and comparisons for BOOLEAN need to be brought into line with the standard or the BOOLEAN work backed out, before 10.2. The developer working on this issue has indicated that he does not plan to complete the BOOLEAN work for 10.2

There is other outstanding work associated with BOOLEAN and I don't know whether that is a showstopper or not, but at least the casts and comparisons are. See discussion in DERBY-499.

Sub-Tasks

• Backout boolean work from the 10.2 branch immediately after the branch is created: Closed