Allow explicit casts of string values to BOOLEAN
------------------------------------------------
Key: DERBY-4658
URL: https://issues.apache.org/jira/browse/DERBY-4658
Project: Derby
Issue Type: Improvement
Components: SQL
Reporter: Rick Hillegas
The SQL Standard allows strings to be explicitly cast to BOOLEAN values.
Strings are the only type (other than BOOLEAN itself) which can be cast to
BOOLEAN. As part of our expanding support for the BOOLEAN datatype, we should
allow these casts.
Casting string types to boolean is defined by part 2, section 6.12 (<cast
specification>), general rule 20:
a) Trim whitespace off the string
b) Then apply the rules in section 5.3 (<literal>). This means that the trimmed
string must be 'TRUE', 'FALSE', or 'UNKNOWN', regardless of case.
c) Otherwise, raise an exception.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
