[DERBY-5451] Allow for casting numeric types to BOOLEAN

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.8.1.2
• Component/s: SQL
• Labels: cast conversion derby_triage10_10 sql syntax type typesystem
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 09/Oct/11 10:39
• Updated: 28/Sep/12 04:08

Description

According to the casting matrix:

http://db.apache.org/derby/docs/10.8/ref/rrefsqlj33562.html

it is currently not possible to write CAST(1 as BOOLEAN). At the same time, casting CHAR and VARCHAR as BOOLEAN is possible, e.g. CAST('1' as BOOLEAN), or CAST(CAST(1 as CHAR(1)) as BOOLEAN). This was recently implemented:

https://issues.apache.org/jira/browse/DERBY-4658